⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

Filters don't show results with NULL value

Started by darkstalker, 24 February 2020 - 14:45 PM

Single Page

darkstalker

Member

Posted 24 February 2020 - 14:45 PM

Hi, John !

I have a table with varchar fields with "enable NULL" and NULL value as default.

I noticed that, when i filter results and select " field is empty " , the NULL values don't show up.

I partially solved the problem disabling the "enable NULL" in the mysql database and modifying each record to empty string.

I think you should add the NULL check in every filter where "field is empty" is available.

Thanks !