This is the documentation for Paper Plane 11.0.
Documentation for the upcoming version Clover Club 12.0 can be found here.
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
andisNotNull
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)?
Pricefx version 11.0