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)
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.