Searching for "is null" is not working

PHPMaker General Discussion (PHPMaker)
1

Hi there,

For phpmaker2025.5.

We use “User select” on “Advanced Search Page” for a field. Generate all files. When we select “is null” on the list page and hit search, it shows the records that is NOT null.

Please let us know how to fix it. Thanks.

2

Cannot simulate. If you enable debug, you should see that the SQL in the debug panel should be correct

SELECT * FROM Table WHERE Field IS NULL