I need to bulk change all the issues that are still in the backlog.
But I cannot find the right query.
Hi Jo - why can't you just do Project = ABC and status = Backlog
Hi @Jo
How about your board's filter query + and sprint is empty ?
I mean that is to get the ones in the backlog and not added to future sprints also..
If you want to include future sprints items in the backlog section, you can also use + or sprint in futureSprints()
Refer to functions in https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-functions-reference-939938746.html#Advancedsearchingfunctionsreference-fsfutureSprints()
Not all tickets in the backlog are in the "Backlog" status. Many are in OPEN or TODO.
Then Project = ABC and status in (Backlog, Open, "To Do")
Following. I'm looking to do the same. In the Sprint Planning Board items that don't have a Sprint associated with them are found in Backlog. (note: Backlog isn't a status in this case.) Yet, in the Advanced Filter, you can't search for <none> in the Sprint category. Grrrr
It does not work as there is nothing with Status = backlog
Below query will give you all the items which are listed under Backlog
project is '{xxxx}' and Sprint is EMPTY
You can filter the issues that are in the backlog using openSprints(). For example:
project = ABC AND Sprint not in openSprints()
'Sprint is Empty' only includes items that have never been in a sprint. The sprint field stays populated if an item is returned to the backlog (currently no sprint) with all of the sprint history, so anything that is currently not in a sprint, but was in a sprint, will not have the Sprint field empty. How do I include these items in my query?
I think this can work
project = "XYZ" AND statusCategory != Done AND (sprint is EMPTY OR Sprint != SpirntNumber)
Where SprintNumber is the number of the current sprint.
The JQL that works for me is
project = *project* AND (sprint is EMPTY OR Sprint not in (openSprints(), futureSprints())) AND resolution = Unresolved and status != Closed
I'm pretty sure this will miss tickets that were in any currently open or future sprints that were then moved back to the backlog. To be fair, though, I'm going off past experience. I did not test it again today.
Just tested by moving an issue from the backlog into the current sprint and back into the backlog, then filtering the backlog by product. The moved issue still shows in the filtered backlog. Seems to work as expected.
Perhaps the behavior you recall seeing was a Jira Cloud bug that has since been fixed?
Aha! The real genius here is in this piece: "AND resolution = Unresolved". All of the tickets in our closed sprints are (naturally) resolved so this is taking the place of trying to filter out the closed sprints without, at the same time, filtering out issues that used to be in the closed sprints.I'm also a little surprised that "not in" is working differently with closedSprints() than with openSprints() and futureSprints() but the inconsistency works in my favor so, play on.I have the occasional issue that went through status changes that prematurely left it with a Resolution that would fail this search but I can live with that.Thanks so much for your post!
Next to my Backlog, there is an icon of four little lines and a square that is 'view in issue navigator' - when clicked that takes me to the issue navigator with the query at the top being:
project = [MYPROJECT] AND status in ("10000", "10001", "3") AND issuetype != "10000" AND status not in ("10001") AND (cf[10014] is EMPTY OR cf[10014] not in futureSprints() AND cf[10014] not in openSprints()) ORDER BY Rank ASC
So maybe try putting your project name in there and see if that works?
It looks like you're new here. Sign in or register to get started.
