Combining the "Is Null" and "Is Empty" filter options
Q:
I would like to combine the behavior of both 'Is Empty' and 'Is NULL' filter options, as the end user doesn't understand the difference. So if someone selects "Is Empty", all the records that contain an empty string or a NULL value for the filtered column should be loaded. Is this possible?
A:
You can achieve this by converting all the NULL values from your database to empty strings,
in the SQL query that populates the grid. This way, you need to use only the"Is Empty" option.
|