Advanced Search broken if checkbox field empty

PHPMaker General Discussion (PHPMaker)
1

(v2026)

My table has multiple fields, one of those is a checkbox field with a single possible value (‘Y’).

If I make any advanced search but don’t select that checkbox, I always get zero results. Turns out this is being added to the filter:

EXISTS (SELECT * FROM STRING_SPLIT([MY_FIELD], ',') WHERE value IN (''))

I only get any results in my advanced searches if I select that checkbox, in which case the filter contains (among other criteria) this:

EXISTS (SELECT * FROM STRING_SPLIT([MY_FIELD], ',') WHERE value IN ('Y'))

Nothing related to MY_FIELD should be added to the search filter if I leave it empty in the advanced search form, right? I’m using V2026.07 and SQL Server.

2

You should use a true boolean field, see Field Setup -> Checkbox:

Note For MySQL, PHPMaker considers enum('Y','N') and enum('1','0') as boolean fields. For Oracle, fields with two and only two User Values (see below) and the labels and values are "Y" and "N" (or "1" and "0") will be considered as boolean fields. PHPMaker will display a boolean field by a checkbox automatically.

For SQL Server, you should use bit type. It will be mapped by Doctrine as boolean automatically.