How to search null when filter type is enumeration ?
Best answer by Imal Thiunuwan
View original
This topic has been closed for comments
Userlevel 5
+8
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 -
Userlevel 6
+16
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!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.