Searching Choices Lists with Relational Operators
The relational operators are <, <=, >=, and >. When you search choice lists with a relational operator, the search is based on the order of the choices in the list.
For example, if the choices in the Problem Area list are ordered:
Apps - Goldmine
Apps - MS Excel
Apps - MS Outlook
Apps - MS Word
Apps - Other
HW - Disk
...
the query Problem Area < HW - Disk returns all the application-related issues.
When a choice list uses a non-alphabetical sort order, the sense of the relational operators is reversed. For example, if the Priority list is ordered:
Highest
High
Medium
Low
Lowest
the query Priority > Medium returns issues marked High or Highest, and the query Priority < Medium returns issues marked Low or Lowest.
Related Topics