Complex Filter Query for Scrum Board

[Drew Haid]

I am attempting to set up a scrum board in the following way:

project = "Project 1" AND reporter != User, user OR project = "Project 2" AND labels = SprintA OR labels = SprintB

I keep getting a message telling me this is too complex and I need to have manage sprint access in order to start or edit sprints (which I have been unable to solve for within JIRA).  I am an admin on both projects.

Anything I am missing here?

[Trudy Claspill · Accepted solution]

Hello @Drew Haid 

Welcome to the community.

First I think there is a syntax error in what you posted. This is not valid syntax.

AND reporter != User, user

Can you explain in words what you are trying to do, or tell me it this is correct.

You want

- all issues in Project 1 that are not reported by two users, plus

- all issues in Project 2 where the labels field contains either SprintA or SprintB

(On this second criteria, do you want issues where the labels field is empty?)

If I have interpreted your criteria correctly than the JQL you need is

project="Project 1" and report not in (user, user) or project="Project 2" and labels in (SprintA, SprintB)

[Drew Haid]

@Trudy Claspill this was exactly what I needed, thanks for the assistance!!

[Chris Buzon]

OR labels = SprintB   <- this is  looking at the entire Jira instance regardless of Project, and has nothing to do with the rest of the query.   You can narrow it down by including Project = "Project 2" AND labels = SprintB

[Chris Buzon]

So...

OR project = "Project 2" AND labels = Sprint OR Project = "Project 2" AND labels = SprintB


OR clauses can be formed in several ways, and you can use parenthesis' as well.

project = Project AND (labels =SprintA OR labels= SprintB).