Using fields in the advanced search bar

Enclose field labels in single quotation marks. For example:

'Short Description'

If a field name contains a single quotation mark (such as an apostrophe), add another single quotation mark next to it. For example, if the field is named Submitter's Phone Number, enter it as 'Submitter''s Phone Number'. Instead of entering the field label and the quotation marks into the advanced search bar, you can click the field's label in the form, or select the field from the Field List dialog box. The field name is automatically added, with the correct syntax, to the search statement.

To search on a field that does not have a label, see your administrator for the field ID. Use this ID instead of the name enclosed in single quotation marks.

Using status history fields

Status history fields must have all of the following information enclosed within single quotation marks:

The name or ID of the status history field followed by a period.
The name or index of the status value that you want to match followed by a period.
The keyword USER (for the user who changed the request to that status) or TIME (for the time last changed to that status).

The following example uses names:

'Status History.Fixed.TIME' < "07/01/08"

Using currency fields

For currency fields, you must enclose one of the following items in single quotation marks:

The name or ID of the currency field. For example:
'Currency Field' = $NULL$
The name of the currency field, followed by a period, followed by a specific portion of the currency field's value, such as the date or a functional currency value. For example:
'Currency Field.VALUE' < 5000

Using keywords in the advanced search bar

You can use keywords anywhere that you can enter character values.

You can use the $NULL$ keyword to search for requests that have no value in a field. For example, to search for requests that have not been assigned (requests with no value in the Assigned to field), enter 'Assigned to' = $NULL$.

The most commonly used keywords are: $DATE$, $NULL$, $TIME$, $TIMESTAMP$, $USER$, and $WEEKDAY$.

Keywords are case-sensitive and use only UPPERCASE, as shown in the following table.

Keywords

Using values in the advanced search bar

Enclose nonnumeric values (including time, selection, and currency values) in double quotation marks (for example, "07/01/20" for July 1, 2020).

Using selection field values

You can specify selection field values as text values (in quotation marks) or numeric values or IDs (not in quotation marks). For example, if you have a Status field with the option buttons labeled Open, Fixed, and Verified, you can enter "Open" or 0 to specify the value of Open, because Open is the first selection value in the selection field. For example:

'Status'="Open"

'Status'= 0

Using currency field values

For currency fields, use the Currency Codes submenu to select an available currency code. When you select a currency code, the double quotation marks are automatically entered (for example, "USD"). Add the currency value within the double quotation marks (for example, "100 USD").

If you do not specify a currency code, the primary allowable currency type is assumed.