Skip to Main Content
Preset Feature Feedback
Status Gathering Feedback
Categories Enhancement
Created by Charles Vinis
Created on Dec 17, 2021

Allow for Filtering of NULL and non-NULL Values Without Custom SQL

What is the problem or goal the end user is trying to solve or accomplish?

Currently it is not possible to filter for NULL and/or non-NULL values at the same time (without using custom SQL). The IN operator on the FILTER configuration doesn't have null/not null values.

How are they solving it currently?

Users need to use the Custom SQL option on the FILTER to achieve this goal. Another possible workaround is to manually type <NULL> on the value Options drop-down.

What is the recommended solution by the Customer?

Include null and not null options on the IN operator filter.

  • Attach files