How to filter all issues in 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

[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! :) 

[Nikunj Savaliya]

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

[Marc - Devoteam]

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

This will help other community members as well.

[Valerie Knapp]

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