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.