HasValue

The HasValue() function checks whether the input parameter is not empty and has a specific value.

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 a Concept-Set), then the HasValue() function checks if the list has at least 1 row.

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

Returns true if parameter is not empty and contains a specific value. Returns false if parameter is empty.

Syntax

HasValue(parameter)

HasValue( "1" ) => True

HasValue(unknownnumber) => False

HasValue( "" ) => False

HasValue( " " ) => True

HasValue( '' ) => True

HasValue( {} ) => False

HasValue( [List WithRows] ) => True

HasValue( [List WithNoRows] ) => False

Parameters

NameTypeRequiredDescription

parameter

any

Field that is checked for a value

Last updated