How do I create a filter that includes the option for 'none' on a non-required field?

Question

We have a non-required radio list field, and are building a filter which we want to include the option for 'none' (that is automatically added).

Anyone know how to include the option for 'none' as a filter parameter?

Eric White9 · Answer

Thanks Udo for your response, it was helpful

cheers!

Udo Brand · Answer

"none" is identical to empty so the query for this field (e.g. "Pet") is

Project = ZOO and (Pet in (Dog, Cat, Iguana) or Pet is empty)