How to filter all issues in Backlog

Soraia Luís July 28, 2023

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

 

2 answers

0 votes
Marc - Devoteam
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 28, 2023

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 July 28, 2023

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 28, 2023

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

Like # people like this
Soraia Luís July 28, 2023

@Marc - Devoteam 

It worked! Thank you very much! :) 

Like Marc - Devoteam likes this
Nikunj Savaliya
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 7, 2024

Great soluation by @Marc - Devoteam for (.....etc OR etc ) Like JQL Expirence nice

Marc - Devoteam
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 9, 2024

Please accept my answer as a solution, if my answer helped to solve your request.

This will help other community members as well.

Like Valerie Knapp likes this
0 votes
Valerie Knapp
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 28, 2023

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 July 28, 2023

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events