I tried to search null mail value when using queryFilter REST, is it possbile?
example
https://{{idm_url}}?_queryFilter=mail+eq+null
Thank you
I tried to search null mail value when using queryFilter REST, is it possbile?
example
https://{{idm_url}}?_queryFilter=mail+eq+null
Thank you
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.
Yes, you have to negate it, e.g _queryFilter=!+mail+pr
Thank you it is working on my side :)
This article is very useful and I have come across similar issues. How will we apply when we have multiple AND filter and if one of them is empty that should be ignored.
I tried a filter like this and it seems to be working fine,
_queryFilter = (id+eq+‘1’)+and+!(status+pr)