how to advance edit a search filter

Carl Berry May 7, 2021

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)

1 answer

1 accepted

1 vote
Answer accepted
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 7, 2021

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

Carl Berry May 7, 2021

awesome, I got it to work.  Thanks

Like Bill Sheboy likes this

Suggest an answer

Log in or Sign up to answer