Multiple values in Filter using Contains | Community
Skip to main content
N
NRYNR
Level 10
May 13, 2016
Question

Multiple values in Filter using Contains

  • May 13, 2016
  • 6 replies
  • 2307 views
I'm not sure if this is possible, but I would like to use the Contains qualifier and multiple values. For example, Show me all parameters where the name CONTAINS "admin" or "test". I've tried text mode with quotes, commas, tab space, and none seem to work. Suggestions?
    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    6 replies

    E
    EricLu2
    Level 10
    May 13, 2016

    I’d like that too. I’m weary of doing multiple blocks of:

    Condition 1

    And

    Contains “dog”

    OR

    Condition 2

    And

    Contains “cat”

    Or

    Condition 3

    And

    Contains “bird”

    I hope someone has an idea of how to do that…

      T
      TimGo1
      Level 2
      May 13, 2016
      Pretty sure the OR statements is your best bet, but remember that CONTAINS filters are much more performance hungry than other filters. As such, you may see slowness in report display. You might be also able to use IN instead of CONTAINS, depending on the content of the field.
      R
      RyanCa
      Level 4
      March 7, 2017

      Not sure if you resolved this, but here's what I did. i was looking to exclude based on multiple criteria, and this works for that purpose

      AND:1:project:name=OBM

      AND:1:project:name_Mod=cinotcontains

      AND:2:project:name=PASO

      AND:2:project:name_Mod=cinotcontains

      AND:3:project:name=Eventus

      AND:3:project:name_Mod=cinotcontains

      AND:4:project:name=Partner

      AND:4:project:name_Mod=cinotcontains

      AND:5:project:name=Partnership

      AND:5:project:name_Mod=cinotcontains

      project:name=FFS

      project:name_Mod=cinotcontains

      T
      tracy_fox
      Level 5
      March 28, 2017

      Ryan,

      Have you had any success with the same formulas but using Issue Queue Topic?

      I am trying to report on any issues that aren't "Change Request", but the following isn't liked by my report:

      opTask:queueTopic:name=Change Request

      opTask:queueTopic:name _Mod= cinotcontains

      Thanks

      J
      JohnO_
      Level 5
      June 17, 2019

      Has this been remedied because I'm falling right into the same need. I'd like to filter tasks which have the names "asset handoff" and "deployment handoff." Currently, I'm filtering by "Task > Name contains handoff," which is pulling in some unrelated tasks.

      Farzaneh
      Farzaneh
      Level 4
      April 2, 2024

      I am not sure if this has been addressed in any way. I am running into problems when I use AND statement to apply multiple Contains conditions through a filter. The report clears out all but keeps only one of the Contains conditions.

       

      Here is what Adobe is suggesting:

      https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/custom-view-samples/filter-refrence-the-same-field-multiple-times

      Terms & ConditionsAccessibility statement

      Loading footer...