I am having some trouble with search query.
Suppose I have a payload like this.
[
{
"alias": "helloearth",
"emailAddress": "[email protected]",
"isManager": false,
"lastRefresh": "2023-10-10",
"managerRef": {
"type": "IDENTITY",
"id": "1010101010101010",
"name": "[email protected]"
},
"lifecycleState": {
"stateName": "active",
"manuallyUpdated": false
},
"processingState": null,
"identityStatus": "UNREGISTERED",
"attributes": {
"country": "USA",
"firstname": "Hello",
"city": "Dallas",
},
"id": "abc",
"name": "Earth, Hello",
"created": "2023-10-02",
"modified": "2023-10-10"
}
]
I am trying a search query to find all identities with managerRef not null. So, I am using this command in query. _exists_:managerRef
. But, I am getting 0 results. Also, if I try, _exists_:managerRef.name
, I am getting 0 results.
It works when I use the same query inside attributes. Such as _exists_:attributes.country
pulls data and getting results. In other cases besides _exists_
, I am getting null as well for those cases. But works if pulling value present inside attributes{}
.
What am I missing here?
Any Idea?
I am following as per the documentation.