isNull

The isNull function returns true if the given value is null or undefined.

Usage

isNull(field)

Example:

where isNull(optional_field)

This matches records where optional_field is null or not present.