Skip to Main Content
Feature Request FR-4283
Product Area Page Components
Status CLOSED

1 Voters

Filter interactive report with "does not contain" also filter empty values.

michael.schilling Public · Feb 21 2025

Idea Summary
Filter interactive report with "does not contain" also filter empty values.
It would be helpful to add an option to include empty values in Regular Expression search.
 

Use Case
My current work around is to change the source of report to change null values to blank.
But with this the filter condition “is (not) empty” is not possible, but also there is no option to deactive this condition.

Preferred Solution (Optional)
Add an option to include null values

does not contain ABC to NOT LIKE ‘%ABC%’
-→
does not contain ABC to NOT LIKE '%ABC%' or is null

We reviewed this idea carefully, and while it was interesting, we concluded that due to all the internal implications we need to take into account, it is unlikely to make its way into APEX.

Comments

Comments

  • vincent morneau Admin OP 11 days ago

    This risks being a change of behavior on existing applications. Given other flexible ways an IR can filter (row search), this idea is not likely to be actioned.

  • michael.schilling OP 10 days ago

    The default should be without null. This is the current behaviour and does not change existing application. Just a new option as switch (default: disabled) to include null values.