When looking at records in List View which contain at least one boolean column, using the search function (Magnifying Glass Icon) to search values 'true' in that boolean column returns unexpected results. The results returned are all records that are false instead of true.

 

 

1. Open a list that has a boolean field like /incident_list.do
2. Open the search function located near the column labels clicking on the magnifying glass
3. Enter the boolean value 'true' in the field under column 'Active'
4. Press enter to start the search

Observe the search will return all the inactive records.

After carefully considering the severity and frequency of the issue, and the cost and risk of attempting a fix, it has been decided to not address this issue in any current or near future releases. We do not make these decisions lightly, and we apologize for any inconvenience.

The equals '=' operator always needs to be specified for boolean values, so the workaround in order to return the correct results is to type '=true' in the boolean column, instead of 'true'.