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

Building Queries