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

Document ID : KB000104963
Last Modified Date : 05/07/2018
Show Technical Document Details
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.
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.