How to search for empty values in Bulk Task Population Object Filters

book

Article ID: 104963

calendar_today

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.

Environment

Release:
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.