Thank you for your feedback.
Form temporarily unavailable. Please try again or contact docfeedback@servicenow.com to submit your comments.
Versions
  • London
  • Kingston
  • Jakarta
  • Istanbul
  • Helsinki
  • Geneva
  • Store
Close
Home Kingston Platform User Interface Now Platform User Interface Common UI elements Lists Filters and breadcrumbs Filters Filter on multiple string values
  • Versions
  • Products

Contents

Filter on multiple string values

SAVE AS PDF
Other

Filter on multiple string values

For a string field, you can create a filter that searches for multiple values by creating a comma-delimited list.

About this task

This feature enables administrators to copy and paste search criteria from a Microsoft Excel spreadsheet into a filter, for example.

Note: Do not use the [is one of] operator on fields that contain commas, as the query does not return the expected set of records. Instead, create a filter using multiple [or] statements.

Procedure

  1. Create the filter with the [is one of] or [is not one of] operator.
    Depending on the selected field, a choice list or a text box appears.
  2. Select one or more of the options by using multiple selection key commands.

    The choice list remains visible.

    Comma-delimited filter

    Alternatively, for text or number fields, type your search options. Separate the options by commas or put each option on a separate line, and do not enclose the selections in brackets.

    Incident field is one of list of incidents separated by next line
  3. Click Run to filter the list.
    The filter conditions appear as a comma-delimited string at the top of the results list.
    Figure 1. Comma-delimited filter string
    Comma-delimited filter string

Changes to site functionality will be made starting around 6am on January 21st (Pacific Time) and lasting approximately 6 hours.  The site may be intermittently unavailable.