5.9 1904 - Yes/No attribute when null in DB affecting rules

Rennur

v5.9 build 1904,

When the Yes/No attribute's (IsDeleted) value in the database (MySQL 5.5) is 'null' then the query Query rule to display products is:

FIND Products WHERE Object.IsDeleted<>'Yes'
is not executing properly and not showing any query results.

Since both null and 0 values <> 1 or Yes (1 as stored in the DB) the query should list the products.

BSV emailed.

Cheers

aware_support

The query doesn't work because the value is set to NULL in the database (UNDEFINED). Please make sure that you initialise the value of the Yes/No attribute to Yes or No, so that the database doesn't have undefined values for this field.

Rennur

Logically, UNDEFINED (null) should still be recognised as 0 or No value when used in rules.
Why have the initial value as a option then? It is clearly compulsory.

Rennur

Logically, UNDEFINED (null) should still be recognised as 0 or No value when used in rules.
Why have the initial value as a option then? It is clearly compulsory.

crisg0112

If I may add, using Yes/No in MSSQL, the option "value must be provided" is ignored.

User can still save the form.