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 can I filter for issues not in a past sprint while in the backlog?

Soraia Luís

Hello There,

I'm trying to filter all the issues that are in the backlog through the Syntax "sprint is EMPTY". But I'm not catching all the issues, because there are some that were associated with previous sprints and that returned to the backlog again. I am not able to join these two Syntax: Project in (XPTO) and Sprint is EMPTY AND Sprint not in openSprints()

If I filter only by this Syntax: Sprint not in openSprints(), the issues that were associated with previous sprints and that returned to the backlog already appear. But the other issues that were never allocated to sprints no longer appear. Only when using Syntax Sprint is EMPTY.

I need help to join these two searches in order to get all the issues that are in the backlog.

And i already tried: ... sprint not in opensprints() AND sprint is EMPTY

Could you help me?

Thanks

Accepted answers

Marc -Devoteam-

Hi @Soraia Luís

If you would use the following JQL.

Project in (XPTO) and (Sprint is EMPTY OR Sprint not in openSprints())

Added extra () on the OR option clauses.

All comments

Valerie Knapp_dpp5c6

Hi @Soraia Luís , thanks for your question. Would it work to search by the status instead? You could search by project where the status is Backlog.

Here, anyway, you should try with OR

Project in (XPTO) and Sprint is EMPTY OR Sprint not in openSprints()

because you want to check where the Sprint is Empty OR, if there is a value, that it is not in an openSprints().

Please give us your feedback and either I or someone else will try to help.

Cheers

Soraia Luís

Hi @Valerie Knapp , I already tried that way, what happens is that it filters all issues from all projects. I don't understand why it doesn't filter just the ones I indicated.

I tried these:

1. This one doesn't work because it returns all issues from all projects. It's not filtering for the ones I indicated.

project in (XPTO) AND issuetype in (RAD, Bug, Listagens, Tarefas) AND status in (OPEN, "In Progress", "Customer Acceptance") AND sprint not in opensprints() OR Sprint is EMPTY

2. Does not return anything:

project in (XPTO) AND issuetype in (RAD, Bug, Listagens, Tarefas) AND status in (OPEN, "In Progress", "Customer Acceptance") AND sprint not in opensprints() AND sprint is EMPTY

Thanks

Marc -Devoteam-

Hi @Soraia Luís

If you would use the following JQL.

Project in (XPTO) and (Sprint is EMPTY OR Sprint not in openSprints())

Added extra () on the OR option clauses.

Soraia Luís

Hi @Marc -Devoteam- ,

I already tried that way and doesn't work because it returns all issues from all projects... I do not know why... It's not filtering for the ones I indicated.

project in (XPTO) AND issuetype in (Bug, Listagens, RAD, Tarefas) AND status in ("Customer Acceptance", Feedback, "In Progress", OPEN) AND Sprint is EMPTY OR Sprint not in openSprints()

Marc -Devoteam-

Hi @Soraia Luís

Put this part of the JQL in extra brackets (see the bold brackets)

(Sprint is EMPTY OR Sprint not in openSprints())

Full JQL:

project in (XPTO) AND issuetype in (Bug, Listagens, RAD, Tarefas) AND status in ("Customer Acceptance", Feedback, "In Progress", OPEN) AND (Sprint is EMPTY OR Sprint not in openSprints())

Soraia Luís

@Marc -Devoteam-

It worked! Thank you very much!

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud

atl-bobross