How to use Multiple IS NULL in /in-db filter under Custom filter

[Simi_M]

Hi, 

I'm getting below error when working on custom filter:

I have list of columns to check for Null values but not sure if I can have multiple filters. I'm fetching data from oracle.

Can somebody help?

[atcodedog05]

Hi @Simi_M 

Is it working with single filter condition ?

And can you show the complete error message.

[BrianR]

Hi @Simi_M, in Oracle, have you tried this syntax...

"F1" IS NULL
OR
"F2" IS NULL

i.e, try replacing the = with a IS and see if that works. I just tested on a local Oracle DB and that syntax appears to work.