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
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.
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()
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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())
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Great soluation by @Marc - Devoteam for (.....etc OR etc ) Like JQL Expirence nice
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please accept my answer as a solution, if my answer helped to solve your request.
This will help other community members as well.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.