SYMPTOM
In Strategy Secure Enterprise 10.x, it is seen that the view filter is not applied as in earlier versions for attributes with NULL IDs.
Consider a report with an attribute 'A' that contains 2 elements with NULL IDs, but different DESC data.
- One element (call it a1) has ID = NULL and the corresponding DESC = NULL
- The second element (call it a2) also has ID = NULL and the DESC = Not Assigned.
When creating a report with the following view filter, element a2 is excluded as expected, but the element a1 with NULL DESC is also not seen on the grid.
A NOT IN LIST “Not Assigned”
In Strategy 9.4.1, the behavior was different where only attribute a2 was not displayed on the grid.
CAUSEThis is working as designed in Strategy 10.x. A design change has been implemented in Strategy Secure Enterprise 10.0 where data with NULL ID is excluded from the dataset (Null Checking option doesn't take effect for filter evaluation).
ACTIONAn enhancement has been logged with Strategy to modify this behavior. Strategy will continue to investigate and post updates as soon as they are available.
Users should also take advantage of the Ideas Exchange to comment further on the enhancement.
WORKAROUND:Add an “OR” condition for attribute form ID “Is Null” to add the Null (AttributeID) Null (AttributeDESC) value back as shown below: