Examples of Expressions

Some examples of the types of expressions that can be constructed follow:
  1. The following expressions match all rows or resources that have a name which begins with 'tr' and ends with '0', where 'Name" indicates the column or attribute that is to be used in the evaluation: 
    Name =~'tr.*0'
Name LIKE 'tr%0'
  2. The following expressions evaluate to TRUE for all rows or resources that contain 1, 3, 5, 6, or 7 in the column or attribute that is called IntList, which is an array: 
    IntList|<{1,3,5..7}
IntList in (1,3,5..7)
  3. The following expression combines the previous two so that all rows and resources that have a name beginning with 'tr' and ending with '0' and have 1, 3, 5, 6, or 7 in the IntList column or attribute will match: 
    (Name LIKE "tr%0")&&(IntList|<(1,3,5..7))
(Name=~'tr.*0') AND (IntList IN {1,3,5..7})