Skip Navigation
Filtering by NULL values in a report
Answer ID 8791   |   Last Review Date 10/09/2018

How do I filter by NULL values in a report?


Oracle B2C Service, All versions


A filter cannot be set to include or exclude null values.


A report can only use an "is null" or an "is not null" filter if the filter is not selectable at run time.

To adjust this setting while viewing a filter in the Reports Designer, deselect the "Make this filter selectable at run time" option. This will add both null filter options to the Operator dropdown menu.

Edit Filter > Make this filter selectable at run time checkbox

Click to enlarge image

See Answer ID 1744: Values of the Operator field when configuring report filters for additional details.