Is it possible to query a null value in a queryFilter?

Troubleshooting
, , ,
#1

I tried to search null mail value when using queryFilter REST, is it possbile?

example
https://{{idm_url}}?_queryFilter=mail+eq+null

Thank you

#2

You could use the ‘pr’ (presence) operator @yohanescalvin:

_queryFilter=mail+pr

Regards
Patrick

#3

Hi thank you for the reply,

So how the query gonna be like? is it _queryFilter=mail+pr or _queryFilter=mail+pr+null?

If i tried _queryFilter=mail+pr, it will return all user instead finding the null mail attribute user.

#4

Yes, you have to negate it, e.g _queryFilter=!+mail+pr

1 Like
#5

Thank you it is working on my side :)

2 Likes