Operators
Last updated
Was this helpful?
Last updated
Was this helpful?
Both and use operators to compare data. Appfarm supports many different operators depending on the data type of the values you are comparing.
You can use to check for equality or difference between two values. check for the presence or absence of a value. To search for the presence of text in a value, are available.
As an example, if you were to filter a data source on all active Projects, you would construct the filter Projects.Status EQUALS Active. EQUALS is the operator, Projects.State is the left operand and Active is the right operand.
Equals
Check if two values match. Both values must be of the same data type.
Not equals
Check if two values do not match. Both values must be of the same data type.
<
Available for Integer, Float, and Datetime data types. Check if a value is less than another.
<=
Available for Integer, Float, and Datetime data types. Check if a value is less than or equal to another.
>
Available for Integer, Float, and Datetime data types. Check if a value is greater than another.
>=
Available for Integer, Float, and Datetime data types. Check if a value is less than or equal to another.
Warning
Properties with a Boolean data type can be undefined which is neither true nor false. Typically you should use Not equals true when comparing boolean values instead of Equals false to ensure you capture these values.
Is any of
Is none of
Exists in
Available for Reference data type. Check for the presence of an object in another data source. The data source can be restricted to selected objects, not selected objects, or a filtered selection.
Not exists in
Available for Reference data type. Check for the absence of an object in another data source. The data source can be restricted to selected objects, not selected objects, or a filtered selection.
Has all of
Has some of
Has none of
Has value
Check for the presence of a value, and that the property is not empty or set to null.
Has no value
Check for the absence of a value, such as when the property is empty or set to null.
All string operators are case insensitive.
Contains
Objects whose name property contains the exact phrase big blue button.
Contains all
Objects whose name property contains all three words big, blue, and button, including as part of larger words.
Contains all words
Objects whose name property contains all three standalone words big, blue, and button.
Contains any
Objects whose name property contains at least one of the three words big, blue, or button, including as part of larger words.
Not contains
Objects whose name property does not contain the exact phrase big blue button.
Not contains all
Objects whose name property does not contain all three words big, blue, and button, including as part of larger words.
Not contains all words
Objects whose name property does not contain all three standalone words big, blue, and button.
Not contains any
Objects whose name property does not contain any of the three words big, blue, or button, including as part of larger words.
Check for the presence of a value in another data source or static value. Both values must be of the same data type. It can also be used to check against , for example Project.Status IS ANY OF New, Started.
Check for the absence of a value in another data source or static value. Both values must be of the same data type. It can also be used to check against , for example Project.Status IS NONE OF Completed, Archived.
Available for Reference data type with . Check if all of the IDs of the left operand are present in the data source of the right operand. In this case, the left operand is a multi-reference property, containing a list of IDs (references).
Available for Reference data type with . Check if some of the IDs of the left operand are present in the data source of the right operand. In this case, the left operand is a multi-reference property, containing a list of IDs (references).
Available for Reference data type with . Check if none of the IDs of the left operand are present in the data source of the right operand. In this case, the left operand is a multi-reference property, containing a list of IDs (references).
When the left operand has a data type of String, the string operators are made available, and you can compare the value against another string. Note that these operators are not available when constructing filters in data sources. They are only available when constructing client-side conditions and filters in the or .