I have a boolean field (“isActive”) on a custom data type. The field can be “yes”, “no” or it may be empty. I would like to search for all records where this field does not equal “no”. In other words, I want the search to return all instances where the field equal “yes” or is blank.
I thought that using the search constraint: isActive <> “no” would accomplish that, but it does not. If I have 5 records and isActive fields for each record are empty, the search returns zero records instead of 5.
Is this expected behavior?
Thanks!