How can I use a Power Filter to filter for IS NULL or NOT NULL conditions

Document ID : KB000055284
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

How can I use a Power Filter to filter for IS NULL or NOT NULL conditions?
I am trying to use a power filter with a condition that tests for a NULL value, but it does not seem to work correctly.
   

Solution:

The Power Filter is currently designed to search for values only. If you leave the field empty (NULL value) that field is not included in the filtering. There is no current functionality that allows the configuration of the power filter to search for NULL or NOT NULL values.

Reference Enhancement Request CLRT-5847 (78941) - ERQ - Would like to be able to filter on IS NULL or IS NOT NULL value
This ERQ is currently in review with our Product Management team and proposed for a future release.

There are also some 'ideas' posted into the CA Communities. You can visit these ideas and add your comments and 'vote' or 'promote' these ideas.

Within the 'CA Clarity' community, navigate to the 'Ideas' tab and enter 'filter null' for your search phrase.