Free Search Syntax Rules

These rules apply to Free Search:

  • The length of the search query string cannot exceed 4,000 characters including spaces.
  • When no field name is specified, search phrases are searched for throughout the content of the predefined fields and of all fields configured in workflows.
  • When you click in the Free Search field, you can select from the list of predefined fields.
  • To search for a field value with multiple words, separated by a space character, use quotation marks. The search results will return all tickets that containing the search terms, regardless of the order in which they appear, For example:

    assignee:"Steve Smith"

    will return tickets with:

    Steve Smith, Steve Samuel Smith, Samuel Steve Smith, and Smith Samuel Steve.

  • Use logical operators OR and AND.

    • Operators must be uppercase.

    • You can only use one logical operator when searching for a user-defined field.

  • Use * as a wildcard. For example, to find all network addresses in the 192.168.0.0 network, search for:

    192.168.*

  • Use - to negate or exclude or NOT include. For example, to find all tickets except those with low priority:

    priority:(* -low)

  • To search for a single date, enter the date in the format YYYYMMDD

    For example:

    createdate:20100120

  • To search for values in a range. The range limits should be bracketed, with TO between them. For example:

    createdate:[20080120 TO 20090120]

    In an API, the brackets and space should be replaced with URL encoding, for example:

    https://<IP>/securechangeworkflow/api/securechange/tickets/free_text_search/?parameter=createDate%3A%5B20201123%20TO%2020201125%5D

To search for text in a predefined field:

  • Enter the field name and the search phrase separated by a colon.

    For example, to find tickets with a priority of high or critical:

    priority:(high OR critical)

To search for text in a user-defined text field:

  • Enter fieldname:fieldvalue, with the actual name of the user-defined field and value of the user-defined field. If the field name includes spaces, special characters, or uppercase letters, replace these characters with an underscore (_) or lowercase letters. For example, replace Some field Name with some_field_name.

    For example, to find tickets that have a text field named Department with the value Marketing:

    department:marketing

To search for a date in a user-defined date field:

  • Enter fieldname:fieldvalue, with the actual name of the user-defined field and value of the user-defined field. If the field name includes spaces, special characters, or uppercase letters, replace these characters with an underscore (_) or lowercase letters. For example, replace My field Name with my_field_name.

    For example, to find tickets that have a date field named Service Date with the value Fri, Oct 20, 2011:

    service_date:20111020