How to search for empty values in Bulk Task Population Object Filters
Article ID: 104963
Updated On:
Products
CA Identity Manager
CA Identity Governance
CA Identity Portal
Issue/Introduction
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.
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.
Environment
Release:
Component: IDMGR
Component: IDMGR
Resolution
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.
where ( Employee Number != * )
This will return all users who have no value for the specified attribute.
Feedback
Yes
No
Powered by
