Comparison Functions

 

The most common comparison functions are provided in the table below. In addition the description, syntax, arguments, and an example have all been provided.

 

Function Name	Description	Syntax	Arguments	Example
AllAreTrue	Returns true if all of the provided conditions are true. You may want to use this function to define a rule.	AllAreTrue(condition1, ...)	condition: intrinsic-conditions to evaluate	AllAreTrue(a=1,b=2,c=3)
AnyAreTrue	Returns true if any of the provided condtions are true. Otherwise false. You may want to use this function to define a rule.	AnyAreTrue(condition1, ...)	condition: intrinsic-conditions to evaluate	AnyAreTrue(a=1,b=2,c=3)
NoneAreTrue	Returns true if none of the provided conditions are true. Otherwise false. You may want to use this function to define a rule.	NoneAreTrue(conditional1,...)	condition: intrinsic- conditions to evaluate	NoneAreTrue(a=1, b=2, c=3)
IsNullOrEmpty	Returns true if a field is null or empty (unassigned).	IsNullOrEmpty(field)	field: intrinsic- a field of datatype text.	IsNullOrEmpty(Field1)