Search for Empty Value

Identity Security Cloud (ISC) ISC Discussion and Questions
1

Is there a way to search for an attribute that exists but is empty?

NOT _exists_:attributeName

Only returns those where the attribute does not show up on the Identity Cube. But if the value is empty and there is a transform, the Identity attribute is populated with an empty value.

For example, we have a dateFormat transform that if the input is empty the Identity Attribute will still exist.

{

"attributes": {

    "inputFormat": "yyyy-MM-dd",

    "outputFormat": "ISO8601"

},

"id": "Date Format",

"type": "dateFormat"

}

2

Hi @ethompson
I do not have a dataset to test but did you try a query in search like attributes.location.exact:"" to look for empty location?

1 Like
3

Thanks @yannick_beot the exact keyword is just what I am looking for.