Add EXISTS and NOT EXISTS operands to filter options
When using the filters?: "Different from" and "Not in List" , if the table contain null values, all rows which contain null values in the specific field will be dismissed from the query.
for example, when filtering on the below table, where description not in "Activation fee" ( for example), all the revenue category for "ATM\POS" will be removed from the result.
the reason for it: behind the scene the SQL query will generate the following code:
1. For Different from - Description =! "Activation fee"
2. For "Not in List" - Description not in ("Activation fee")
in both cases the SQL will return false value when compering to the Null description, and then any item which contain null description, will be removed. this is how SQL works..
the solution: implement the query to use "Not Exists" instead of Not in and =!.