IsNotNullOrDefaultAny

Description

At least one of the expressions are not void of a value or does not have the database-specific empty string default value.

When used with non-string data types, the results produced by this function may differ across databases, since the different underlying databases handle empty value logic differently.

Input arguments

Argument Name	Data Type		Description
Fields	String		Fields to be evaluated.
	DateTime
	Decimal
	Integer
	Real

Return type

Boolean (True/False, Yes/No)

Example

Explanation

Determine if any of the fields (FieldA, FieldB, FieldC) are not null or do not have the database-specific empty string default value.

Configuration

Result