Hello
Apex 22 here. Users use filters like “comment does not contain ABC” in interactive reports, and their expectation is that empty comments would be returned as well (as they don't contain that string of course)
However, Apex seems to filter out NULL columns when applying filters like that.
The workaround I suggested was to use row filters like: X IS NULL OR X NOT LIKE '%ABC'%'
That works but it is not very user friendly.
Another option is to change the report query to return a non-null value (like a space or a dash) so the filter works as expected, but that would require changing all reports/columns where this is an issue.
Any other suggestions? Ideally I'd like a “include NULL values” in the contains filter :)
Thanks
Luis