Simple Expressions

When you specify criteria for a group, only those assets that satisfy the expression criteria are included in the group. For example, to define a group that includes only those assets with the location code Admin, you would write the expression Location is Admin. The word is is an operator, which is equivalent to the mathematical symbol =. Conversely, the operatoris notwould exclude all assets with Location code.

The table below lists each available operator and its equivalent mathematical symbol (if any). In addition, the If and Then columns provide an example of results returned by each operator. The example for the Is operator reads: "If the criteria for the selected field Is 5, then the asset selected for the group will be 5."

Operator	Mathematical Symbol	If	Then
Contains (*abc*)		xyz	All occurrences of the specified string, xyz
Does not contain		xyz	All occurrences not containing the string, xyz
Begins with (abc*)		xyz	All occurrences beginning with the string, xyz
Ends with (*abc)		xyz	All occurrences ending with the string, xyz
Is	=	5	5
Is not	¹	5	1, 2, 3, 4, 6, 7, 8, 9, 10
Is less than	<	5	1, 2, 3, 4
Is greater than	>	5	6, 7, 8, 9, 10
Is between *		5, 8	5, 6, 7, 8
Is not between *		5, 8	1, 2, 3, 4, 9, 10
Is not blank	Î	Any	Include all with any data
Is blank	Ï		Include only those with no data
Equals	=	5	5
Does not equal	¹	5	1, 2, 3, 4, 6, 7, 8, 9, 10
Equals or is less than	=<	5	1, 2, 3, 4, 5
Equals or is greater than	=>	5	5, 6, 7, 8, 9, 10

 

* The Is between and Is not between operators do not have an equivalent mathematical symbol. They search for all values through the specified value range - including the first and last values.