[SOLVED] List filters and empty or null fields

Hi, which is the right sql syntax that allows to run the filter also if there are fields empty or null?
Example: (`cb_field1` LIKE '%[cb_field2]%')
If the field2 is empty, the filter does not work because it does not find a value and displays all data.
I tried this:
((`cb_field1` LIKE '%[cb_field2]%') OR `cb_field2` IS NULL)
but it does not work.
Thank you.

The below should work fine.


The above should check that field 1 contains field 2 of the viewing user or if field 1 is null or if field 1 is empty. If you're wanting it to check if field 1 contains field of the viewing user or that field 2 of the viewing user is empty you could use the below.


For more information on SQL please see the below tutorials and documentation.

www.w3schools.com/sql/default.asp
www.w3schools.com/sql/sql_quickref.asp
dev.mysql.com/doc/refman/5.6/en/index.html

Does not work, still returns all values.

Seen that the SQL string for reading empty fields does not function, can be a powerful way to use CB Auto Action and in phase of subscription with the method UPDATE populate fields with symbol "-", that fills the field and at the same time represents an empty field for the user?
Thank you.

Sorry, I noticed that it is not a good option because complete the percentage of the user profile.

What doesn't work? The first or second one? The first one should work fine. The second one is a bit weird, but should work (it's strange to compare empty string to empty string in SQL). You'll need to better describe what you're wanting to filter the list to in order for me to suggest anything further.