IsEmpty

The IsEmpty() function checks whether the input parameter is empty.

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

If the input parameter is a list or a collection (like Concept-Set), then the IsEmpty function checks if the list has 0 rows.

The HasValue() function checks the opposite of this function.

Returns true if parameter is empty.

Returns false if parameter is not empty.

Syntax

IsEmpty(parameter)

IsEmpty( "1" ) => False

IsEmpty(unknownnumber) => True

IsEmpty( "" ) => True

IsEmpty( " " ) => False

IsEmpty( '' ) => False

IsEmpty( {} ) => True

IsEmpty( [List WithRows] ) => False

IsEmpty( [List WithNoRows] ) => True

Parameters

NameTypeRequiredDescription

parameter

any

Field that is checked for a value

Last updated