How to search null when filter type is enumeration ?
Solved
How search null in enumeration type
Best answer by Imal Thiunuwan
Hello
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!
This topic has been closed for comments
+8Hi @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 -
+16Hello
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.