Hi all,
I want to use the filterString source attribute to filter out users upon aggregation whose “Employee #” values are null.
I have tried the following filterString values and IDN seemingly does not like the “#”.
“value”: “(Employee # == null)”
“value”: “(“Employee #” == null)”
Any suggestions?
Here is more on filterStrings: IdentityNow Account Filtering during Account Aggregation - Compass (sailpoint.com)
Welcome to the developer community Danica.
When you say that IDN does not like “#”, are you seeing an error? Any information about the error message or outcome that you are seeing might help with a solution.
Just looking at the example you provided, my first guess is that the attribute you are referencing is not correct. I don’t think IDN allows account attributes to have spaces in the name. Here is an example account schema for one of my sources.
If I want to filter out all accounts who’s givenName is empty, then I would use the following filter:
"value": "( givenName == null )"
Please double check the attribute name for your employee number field.
