Null Values and Sorting/Filtering

This section summarizes NULL values behavior throughout the application. This behavior is aligned with the standard handling of null values in databases.

• Nulls are not values. 

  null == null -> false
  

• You need to add an explicit "is null" or "is not null" where appropriate.

• If you need to work with nulls, create something like "N/A" value to replace the null.

Filtering:

• Nulls never work in the regular "compare" type filter operators. There are specific isNull and isNotNull operators. 

• The operator 'is not one of' automatically excludes null values. 

Sorting:

• When sorting on columns with null values, the null values will always be at the top (regardless of ascending or descending order).