AzuareAD Accounts_Filter not working with not condition

[vikasjain9999]

Hi,

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.

[SB]

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.

[vikasjain9999]

Hi Sahil,

eq qorks but ne does not work.

Regards,

Vikas

[SB]

Can you share the exact filter expression you are using for ne and the data in the logs you see for the same.

[vikasjain9999]

Hi Sahil,

Please find the below filter expression along with attached logs.

userPrincipalName ne 'cld-alain.bis@companyname.onmicrosoft.com'

Regards,

Vikas

[This post has been edited by a Moderator to remove sensitive information.]

[SB]

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.

https://ideas.saviynt.com/ideas/EIC-I-4379