You can use the relational operators anywhere in the Query window. Relational operators are especially useful in non-text fields (such as date and time fields) when you want to query for a value within a numerical range. (See Using Operators in the Query Bar for the list of additional operators you can use only in the query bar.)
| Operator | Action |
|---|---|
|
< |
Match contents that are less than the value. |
|
> |
Match contents that are greater than the value. |
|
!= |
Match contents that are not equal to the value. |
|
<= |
Match contents that are less than or equal to the value. |
|
>= |
Match contents that are greater than or equal to the value. |
|
= |
Match contents that are exactly equal to the value. |
Note: You can override the search style specified by your AR System administrator using relational operators. For example, you can use = (an equals sign) to search for an exact match even if your AR System administrator specified the search style to be Anywhere. For more information about the different search styles, see Query-by-Example.
The example shown in the figure below uses the "=" relational operator. In the example, Open Ticket Status is selected and =Bob is entered in the Submitter field. The resulting search finds all open ARs with an exact match for "Bob" in the Submitter field.
To search for all ARs created after a date or time, simply use the ">" (greater than) relational operator and one of the date and time formats discussed in Filling in Fields. For example, set Modified Date to > June 5, 1994 11:59 to select all ARs modified after June 5, 1994 11:59.
Copyright © 1996, Remedy Corporation. All rights reserved.