Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL that returns two complex searches if either are 'true'

Adam Taylor
Contributor
February 24, 2023

Hi,

Here's a simplified explanation of my Use Case:

I have a Kanban Board where I want a Filter that returns Issues that either are assigned to Team X OR are (assigned to Team Y AND are RISK AND are assigned to Jim OR Jane).

I think I'm trying to have two bracketed (?) queries that returns results from either or both on the same search, if that make sense?

 

1 answer

0 votes
Jack Brickey
Community Champion
February 24, 2023

Hi @Adam Taylor , how to you identify issues assigned to a team? Are you using the "Team" feature in Jira or maybe a group? Also what field defines "at risk".

for example if you are using groups then maybe the following gets us started...

assignee in membersof(group1) OR ("At risk" = yes and assignee in (Jane, Jim))

note, given your use-case above I don't think you need the group2 assignee if you're going to further restrict that to Gene and Jim. Hence my structure in the OR statement.

more information will allow me to get closer to your actual goal. If you have already attempted a JQL and it isn't quite there. Please post it here as that might help.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events