Fields in the advanced search bar

Use the advanced search bar to use field names in the search criteria.

To use the field names as a search criteria, enclose field labels in single quotation marks such as 'Short Description'

If a field name already contains a quotation mark as part of the name. For example, the field Submitter's Phone Number has a single quotation mark in the form of an apostrophe in the field name. In such a scenario, add another single quotation mark next to it when you use this field name in a search criteria. For example, enter it as 'Submitter''s Phone Number'.

Alternatively, instead of entering the field label and the quotation marks into the advanced search bar, you can select the field name from the Field List dialog box. The field name is automatically added, with the correct syntax, to the search statement.

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

The following table gives information about using different fields in a search statement:

Field	Search statement syntax
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"
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

Field

Search statement syntax

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"

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

Keywords in the advanced search bar

You can use the following keywords in search fields that support character values:

$NULL$ : to search for requests that have no value in a field.
For example, to search for requests that have not been assigned that is, requests with no value in the Assigned to field, enter 'Assigned to' = $NULL$.
The most commonly used keywords are:
- $DATE$
- $TIME$
- $TIMESTAMP$
- $USER$
- $WEEKDAY$

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

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).

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

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.