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; } } }

How to select not done Jira tickets for a sprint but exclude certain epic and label?

Sarfraz Aaron

Hi,

I am trying to write JQL that will allow me to select all those Jira tickets for the current active sprint that are not done and excludes certain epic (A-123) and label (XZY).

This is what I have and it is not working.

Project = ABC AND Status != Done AND 'Epic Link' != A-123 OR Labels != XZY

Please help.

Accepted answers

All comments

Ismael Jimoh

Hi @Sarfraz Aaron

Is the Or operation checking if the issues are a part of the epic or are matching the epic.

Use brackets to combine and order operations in the order you want the search to be performed.

Ismael Jimoh

Another option would be building your query and validating you have the write list of issues first and then adding the next operator and conditions to filter down further

Marta Woźniak-Semeniuk_m044pw

Hey, try this:

Project = ABC AND Status != Done AND (('Epic Link' != A-123) OR (Labels != XZY)) AND sprint in openSprints () ORDER by Rank DESC

You had the OR part not but in brackets so it could give weird results - you specify you want issues from active sprints by telling JQL - get me issues in openSprints only

Let me know if it works.

Sarfraz Aaron

Thanks Marta. It did not work as my example had:

12 issues in current active sprint
- 1 issue with epic=A-123
- 1 issue with label=XZY
- 1 issue done

So the outcome should have been:

9 issues (out of 12) left to do (12 - 3 = 9) , instead, I got 6 issues left to do....

Sarfraz Aaron

Hey @Ismael Jimoh the epic and the label are used together to isolate this particular vendor, as an example, where I have issues for the vendor epic or sometimes the issue belongs to another epic but has the vendor label to distinguish it.

Ismael Jimoh

(project = ABC and status != Done and sprint = '<your sprint id>' AND (('Epic Link' != 'A-123') OR (Labels != 'XZY')))

I am surprised that the suggestion from @Marta Woźniak-Semeniuk above didn't work. Looking at your request, I would then search with the above structure.

If you still do not get what you want, then my suspicion is either, you have tickets that you believe match a specific parameter but do not and in this case, searching phase by phase (adding the next set of parameters after validating the prior returns the list of issues expected first) would be the way to go.

Regards.

Sarfraz Aaron

Thank you @Ismael Jimoh

Jira version I am using, a free version online, converts the query to this and gives the wrong result as mentioned above. It removes the brackets.

I don't add project as it is a quick filter on a Jira board.

status != Done AND sprint in openSprints() AND ("Epic Link" != HTS-5 OR Labels != Client)

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud