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).
See also:
Simple Filter – special operators # (is null) and !# (is not null)
Groovy Filters for Data Reading – operators NULL, NOT_NULL
Null values in filters and api.find/stream/findLookupTableValues
How to include attributes with NULL values in Custom Events (omitNullFields = false)?
Found an issue in documentation? Write to us.
Pricefx version 12.0