v:2024
Field Name: status
type: TINYINT
values: 0 or 1
field type: "Radio"
Value: 1 - Yes
Value: 0 - No
on list page "status" displays correct values (yes/no)
if query: status == 1/yes, returns 3609 records from 4445 -- which is correct (836 are inactive...)
if query: status == 0/no, returns 4445 records from 4445 -- which is incorrect should return 836
i activated the extended search and noticed that 2 fields createdby and modifiedby have a default value of my admin account (-1) that is set, if i clear these the search for active = 0 succeeds on the extended panel, but on the query form it still doesn;t return the status =0 result set.
i disabled/removed them from the search options, so on the extended search the query works with status=0, but on the query builder it doesn't show those two fields in the picklist, but still doesn't filter correctly.