I'm struggling using power filters to return null values. Is there an expression that can be used to do this as using the != expression does not return nulls ?
The short answer is no.
If you put
power filler null
in the search box you get threads back to day 1.
What I've seen proposed before is to create the filter so that it excludes everything except the null's.
Document ID: TEC440054 Last Modified Date: 7/2/2014 Hide Technical Document Details
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.
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.
More Information:Reference Enhancement Request CLRT-5847 (78941) - ERQ - Would like to be able to filter on IS NULL or IS NOT NULL valueThis 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. Here is a link to this location : CA Clarity Ideas for Filter Null
Reference Enhancement Request CLRT-5347 (78336) - Process - Configure Conditions on Null FieldsThis ERQ is currently in review with our Product Management team and proposed for a future release.
Keywords: CLARITYKB, CLRT-5847, CLRT-5347, ERQ, 78941, 78336, niku kb id 8734.
And then, there re ideas submitted around this -
What exactly are you trying to filter? If you're trying to get results for a string field that is empty, field='' should work I think but I suppose that depends on the type of field.
Have you tested that to work?
If you need that filter just for once consider querying the database.
If you need it more than once consider using a portlet.
SQL gives better options for null criteria.
I just tested and the following worked on a custom lookup field for me, I'd imagine it would work for any "string" type field:
( project.orh_secondgoal != "")
Wait, I just reread the question and think I misunderstood. Sounds like the OP is trying to filter on say "Name != "Some Name" and have that return results where Name is null OR something other than "Some Name", and Clarity only returns the something other than part. Unfortunately that doesn't seem to be working
( project.orh_secondgoal == "")
evaluates fine but returns nothing, I assume because in the DB it is really Null rather than an empty string, and trying to use Null in the expression will not evaluate at all. I stand corrected.
I tend to buy that, ie that you can filter for a blank string, but the difficulty comes when there is null in the db.
Retrieving data ...