Define a complex search criteria by using the advanced search bar

Use the advanced search bar to define a more complex set of criteria than to search by using only fields in a form. For example, you can search for all requests with two different values, such as Fixed or Closed, in the same field. 

When you specify search criteria in the advanced search bar, you can use the same operators as in the form, and several more. See Using relational operators in the advanced search bar.

Related topics

Running-and-saving-searches

Performing-searches-with-FTS

The easiest way to build your search in the advanced search bar is to select the fields, status history fields, keywords, values, currency codes, currency field sub-values, and selection field values directly from the Fields menu to the right of the bar. When you select items directly from this menu, the correct syntax is automatically entered. You can also type the information directly into the advanced search bar.

Important

  • If you enter search criteria in the advanced search bar and then hide the advanced search bar, the criteria is still used to find matching requests. If you entered criteria in the advanced search bar and then decide not to use it, you must clear the advanced search bar before you hide it.
  • (PostgreSQL database) In advanced search, regular expression, such as 'Submitter' LIKE "B[o-r]%" is not supported.

Showing or hiding the advanced search bar

To show or hide the advanced search bar, click the Advanced Search button in a search window. When the search bar is visible, it appears at the bottom of the browser window.

Building an advanced search

  1. In a search window, click the Advanced Search button.
  2. In the advanced search bar, define a search statement.
    If you use multiple relational operators, understand the order in which the operators are executed. For information about relational operators, see Using relational operators in a search.
  3. Click Search.

The following topics provide information about how to work with the advanced search bar:

Action

Reference

Use field names as search criteria in the advanced search bar.

Use relational operator in non-text fields to define a numeric range for the search results.

Refer to a few sample search statements with different combinations of the search criteria.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*