Is it possible to post multiple pieces of information into the filter field at once? | Community
Skip to main content

Is it possible to post multiple pieces of information into the filter field at once?

  • June 30, 2021
  • 1 reply
  • 0 views
B

As an example, if I am looking to create a query looking at only 50 specific tickets, is it possible to paste all 50 ticket IDs into the ticket ID filter field at once without having to search each one individually?

    This topic has been closed for replies.

    1 reply

    C
    • Chandra13
    • July 3, 2021

    397720838033 I'm afraid not. That said, if you already have the 50 ticket IDs in a spreadsheet, one thing you could consider would be to create a Standard Calculated Attribute where the formula looks something like the below to filter your report off of:

    IF ([Ticket ID] = 123
    OR [Ticket ID] = 456
    OR [Ticket ID] = 789)
    THEN TRUE
    ELSE FALSE
    ENDIF

    I then did something like the following to automatically populate the formula based on the analysis I had completed in Google Sheets. Here's an example of what that looked like:

    Of course, if the Ticket IDs aren't already in a spreadsheet, this workaround may not be a great option for you, but I wanted to share it as it has definitely saved me some time when running deeper analysis on tickets.

    Terms & ConditionsCookie settingsAccessibility statement