how to advance edit a search filter

Carl Berry

In the below string, you can see I am looking at multiple "change locations(s)".  I want to be able to look at all of these locations, but for DC2-PHL1_Phila-AMER, I only want to look at it IF the "Summary" has the words "LUF" or TUS" in it.

 

project = CHANGE AND issuetype = Change AND status in (Implementing) AND "Change Focus" = "Critical Infrastructure" AND "Change Location(s)" in (DC2-us-hungley-1, DC2-us-duke-1, DC2Backbone-ruu, DC3-us-civ-ashland-1, DC3-us-civ-chicago-1, DC3-us-civ-phila-1, DC2-PHL1_Phila-AMER)

Bill Sheboy

Hi @Carl Berry  -- Welcome to the Atlassian Community!

You may do that by splitting up your query to match what you describe, using OR clauses and parentheses to focus the query.  I reformatted a bit to make it easier to see.

project = CHANGE
 AND issuetype = Change
 AND status IN (Implementing)
 AND "Change Focus" = "Critical Infrastructure"
 AND
(
  ( "Change Location(s)" IN (DC2-us-hungley-1
                             , DC2-us-duke-1
                             , DC2Backbone-ruu
                             , DC3-us-civ-ashland-1
                             , DC3-us-civ-chicago-1
                             , DC3-us-civ-phila-1)
  )
OR
 ( "Change Location(s)" IN (DC2-PHL1_Phila-AMER)
   AND (summary ~ "LUF" OR summary ~ "TUS")
 )
)

Best regards,

Bill