When using Filter out the query add's a is not NULL to that field

[Matt Saxton - G]

IS this something that is supposed to happen or is there an issue.. I tried this on the demo site and got the same results.


1 Login and do a list view on anything in the task table.
2 Choose filter out where something is not NULL
3 Look at the filter or query you will see that 2 filters were added and one being NOT NULL

all 3 of my box's are having this issue.. Confirmed to happen on the demo007 system as well.

[CapaJC]

This is by design. System behavior without the second condition is that you won't see any records where that field does not have a value. It goes back to an initial design decision very early on regarding how null is handled.

[cdunn]

Is there anyway to turn off this condition?

[CapaJC]

Not currently. If the second condition wasn't automatically added, then doing a "Filter Out" from a list cell value wouldn't work as most people would expect. You'd filter out, say, all incidents where Category is "Network", expecting to still see incidents without *any* category, but they'd also be removed without that second condition.