⚠ 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



darkstalker
  • 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 !