⚠ 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. ⚠


profile picture

Filters don't show results with NULL value


  • profile picture
  • 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 !