I've seen bits and pieces but not a complete solution. I'm looking for a query that shows issues that were in a closed sprint but do not show up in the backlog - issues in "No man's land" I suppose. Also I noticed that our "official" board backlog count differs from the issue navigator version. Has anyone else seen this?
The following query works for me:resolution = Unresolved and (sprint is EMPTY or sprint not in (openSprints(), futureSprints()))
This query shows all open issues that are not scheduled yet.
Hi Brian!
I think I don't completely understand what you want. If issues do not show up in the backlog should be because they're already done. Could you give me an example so I see if I think a way of filtering them?
Regards, Aylin.
OK,
There is a particular issue that is In Progress that was assigned to a now closed sprint. So it has sprint records but the issue itself is still open. I assigned it to the backlog via API and it shows in the backlog board display along with others for a count of 170. However, if I click the Issue Navigator icon next to the backlog I only see 157 with the default JQL "project = XYZ and sprint is empty ORDER BY Rank ASC". My question is where are the 13 records and how can I find them via JQL?
Ok! the thing is that "project = XYZ and sprint is empty ORDER BY Rank ASC" excludes issues with a recorded sprint. Maybe you can use "project = XYZ and (sprint is empty or sprint in closedSprints() and status not in ("your_done_statuses")) ORDER BY Rank ASC"
This way you'll include the issues in closed sprints AND not in a done_status.
Hope this helps.
Helps a bit, but still does not match the number as reported in the backlog board.
There's a difference between 2 jqls.
Just to check, the filter of your board is "project = XYZ and sprint is empty ORDER BY Rank ASC", correct? and it returns 170 issues
Can you attach a screenshot of the Issue Navigator icon next to the backlog?
So again, when you are on the official backlog page, I click the (kinda) circled icon and I'm brought to the page where the jql is.
Ok, we need to know the board filter then.
Please go to ... -> board settings
and then search for "Filter Query".
Let's see what it's filtering!
Hmm - either I don't have access for that or the server version is slightly different. I see a Configure Board option but not anything specific to the backlog JQL. I'm reaching out internally to the admin here for assistance. Thanks for your help!
This works perfectly! Thanks so much
how can same filter applicable/visible for all available users and boards ??
See "Share a filter" in https://support.atlassian.com/jira-software-cloud/docs/save-your-search-as-a-filter/: Save it and share it with a group, project or individual users.
It looks like you're new here. Sign in or register to get started.
