Hi
in a backend form we need to test if one field "myField" is empty or if it is not empty
SO we have:
* a checkbox field "is_empty" whose values are 1 or 0. The search criteria is NONE since we don't want to actually search on this field
* the myField with a search criteria set to EMPTY and a conditional state that says that this field is ACTIVE / VISIBLE only if "is_empty" is set to 1
However in both cases (is_empty =0 or is_empty =1) the search performs the SQL query with myField ="" !!
The conditional state works because we see myField appearing or disappearing in the search form depending on the value of is_empty
it is ACTIVE state of the conditional state that doesn't seem to work
Any idea please ?
thanks
cyril