000036716 - RSA Identity Governance & Lifecycle review filters incorrectly exclude items with null values in selection criteria

Document created by RSA Customer Support Employee on Sep 12, 2018
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000036716
Applies ToRSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 7.1.0, 7.0.2
IssueWhen selecting review criteria using users selection or contents of a review based on the value of an attribute using not equal todoes not contain or does not match; the filter fails to include records where the attribute value is null.

For example, when selecting an Eentitlement where an attribute does not have a value true; the review is expected to show all entitlements including those with null values for the attribute. To accomplish this, not like comparator is used. The review fails to include records with null values for the attribute.
User-added image
CauseThis is a known issue in the following versions.
  • RSA Identity Governance & Lifecycle 7.0.2
  • RSA Identity Governance & Lifecycle 7.1.0 
ResolutionThis issue will be corrected in a future version of the product.
WorkaroundBy default, the review results selector does not correctly select data where the value of the attribute is null; but you can explicitly add a clause to detect this use case.

To show the full results as intended, you can add an explicit condition to accommodate for null objects in the dataset; by adding a line for your attribute using the is null comparator. 

For example, add a comparator that selects is null condition in addition to the does not match condition.
User-added image