Skip to main content

Hi @ALL

 i try to do smth like this. one dynamic filter should execute the NULL values in the table.

 

FILTER "table". "column" = CASE WHEN <%=option1%> = 'abc' THEN NULL END;

 

all other filters work but i cannot return null values from the same table. I have tried this formula 

 

FILTER "table". "column" = CASE WHEN <%=option1%> = 'abc' THEN Filter_TO_NULL("table". "column") END;

 

but when i have tested, i realized that i did bring up all values but not Null values from table. Does anyone have an idea?

Can you try the following?
FILTER 1 =
CASE WHEN <%=option1%> = 'abc'
THEN ISNULL("table"."column")
ELSE 1 END;

This filter should operate with the following rules:
If option1 = 'abc', only records where table.column is null should show up.

if option1 does not = 'abc', it will show all records.

Reply