03/09/2023 04:23 AM
I am able to filter the accounts with condition startswith(userPrincipalName,'Priv_') but is not filtering with NOT condition i.e. as per business requirement, I have to filter the accounts whose prefix does not start with "Priv_". Please provide any example with Not condition.
03/09/2023 09:49 AM
You can try to use ne but I believe it will check for the exact match and not the prefix.
userPrincipalName ne 'abc'
Please note, this filter should work with your Azure REST api as well, so best would be to try in postman first and see if ne and startswith work together to achieve your requirement.
03/09/2023 09:52 AM
eq qorks but ne does not work.
03/09/2023 10:00 AM
Can you share the exact filter expression you are using for ne and the data in the logs you see for the same.
03/10/2023 12:13 AM - last edited on 03/10/2023 09:57 AM by Dave
03/22/2023 02:40 PM
I just verified this and looks like not equal to filter option is currently not supported. This feature is already in the future road map and being worked on. Below is the idea reference.