Skip to main content

How to search null when filter type is enumeration ?

 

 Hi @DalKylekY ,

Enumeration column will be null only if it is declared to permit NULL. If an ENUM column is declared NOT NULL , its default value is the first element of the list of permitted values.

So it depends on the field, whether NULL is listed or not. Could i know the core form and field your referring to.

Nilushi -


Hello @DalKylekY,

I believe your expectation is when an enumeration is "Required=false" (i.e. is nullable) the Aurena client needs to provide an option to filter for empty values?

Currently the Aurena client supports searching for a specific value or several values of an enumeration. It does not support searching for empty values (NULL values), negation of a value or any other logical combinations of those.

Hope this answers your question.

 

Cheers!