How to search for empty values in Bulk Task Population Object Filters
Article ID: 104963
CA Identity ManagerCA Identity GovernanceCA Identity Portal
In the Population Filter for a Bulk Task Definition, how can we create a filter for users who have no value for a specific attribute?
If we set a filter without specifying any value, e.g. where (Employee Number = ) the error "Missing expression value" is shown when previewing the population. Using a filter such as "where (Employee Number = "")" does not return any results.
Release: Component: IDMGR
Configure the filter to return users where the attribute value does not equal '*'. For example: where ( Employee Number != * )
This will return all users who have no value for the specified attribute.