Home > Forum > Rules, JS, SQL > Defining EMPTY or NULL in report's filters

Defining EMPTY or NULL in report's filters

0

03.10.2023

18:34

Hello all,

Does anyone knows how to configure filters in reports that will something like:

'Field A' EQUAL Empty

We always have to choose Not equal to a specific value

Thank you!

03.10.2023

19:01

Hi Andreia

Not sure in what version this had been introduced, but you can use the "Additional filter" section of the view or use the "Value filter" of a column to filter empty values.

Solution (0)

Helpful (1)

Wrong answer (0)

04.10.2023

08:32

Hi,

If you mean a filter in the report configuration, you can use the filter as Markus described.
Or if you want to permanently set a filter so that the user cannot remove the filter from the report, use an SQL filter.
Regards.

Solution (1)

Helpful (0)

Wrong answer (0)

13.10.2023

12:49

In reply to: Karol Częczek

Hi!

Thank you both!
I went with the solution from Karol because I wanted a permanently filter for the empty cases!

Thank you for your help!

Solution (0)

Helpful (0)

Wrong answer (0)