Share:

PREVIOUS  |  NEXT

Search Operators

Quick Links


Workflow enables you to use search operators to enhance your ability to quickly find cases with specific information. Search operators represent logical relations among data (equal, less than, greater than, or between a range). You can search for a case using keywords or dates, and you can use the operators to narrow your search.

Use the following links to access tables with examples and explanations of search operators with different search strings.

Important: You must use the proper syntax as shown in blue in the  Examples columns in the following tables. Your search values can vary.

Using Search Operators with Dates

[Back to top]


Operators Examples Returns Values
Greater than > 01/12/16 After January 12, 2016 (excludes January 12)
Less than < 01/12/16 Before January 12, 2016 (excludes January 12)
Equal to = 01/12/16 On January 12, 2016
Between in ( 01/12/16 , 01/18/16 ) Between January 12 and 18, 2016 (includes both dates)


Using Search Operators with Numbers

[Back to top]


You can use search operators with whole numbers and decimal numbers.

Operators  Examples  Returns Values
Greater than > 5 Greater than 5
Greater than > 5.123 Greater than 5.123
Less than < 5 Less than 5
Less than < 5.678 Less than 5.678
Equal to = 5 Equal to 5
Equal to = 5.4 Equal to 5.4
Between in (1, 10) Between 1 and 10 (includes 1 and 10)
Between  in (1.11, 10.22) Between 1.11 and 10.22 (includes 1.11 and 10.22) 

Note: When you use an operator to search for a whole number, such as > 5, Workflow will return all whole numbers and decimal numbers that are greater than 5.

Using Search Operators with Text

[Back to top]

Operators  Examples Returns Values
Greater than > abc Text strings that are alphabetically after abc (excludes abc).

Example: abd and abcx are greater than abc, while aaa and aba are not.

Less than abc

Text strings that are alphabetically before string abc (excludes abc ).

Example: aaa and aba are less than abc , while abd and abcx are not.

Equal to = abc Exact matches for abc.
Between  in ( abc, ad)

Text strings that are alphabetically after abc and before ad (includes both abc and ad ).

Example: abcx and ac are in this interval while aaa and ae are not.

Using Search Operators with Custom Fields with Predefined Values

[Back to top] 

Operators Example Explanation
 Equal to  = IE, Chrome  If you have a custom field named Browser, and Browser has these predefined values: IE, Firefox, and Chrome, you can use this syntax to find all cases with either IE or Chrome values