nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

Trudy P Claspill

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)

All comments

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).

Trudy P Claspill

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!!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server