I need some assistance writing a JQL query that needs to query the issues (i.e. Bugs, Stories) in my projects Active Sprints, Future Sprints and the backlogged items.
The issue I have encountered is getting the backlogged issues to show up in the query without have issues from closed sprints showing up.
the query I have right now (below) shows all issues in my project from all sprints, open, future and closed, as well as the backlogged issues.
"project = GLOB AND issuetype in (Bug, Story) ORDER BY created DESC"
Any suggestions for what I need to modify to get the query ti just display the issues from the active sprint, the future sprints, and the backlogged issue list?
Try this…
project = GLOB AND issuetype in (Bug, Story) and resolution is unresolved ORDER BY created DESC
that worked. I just had to switch the is to a '=' and it worked. Thank you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jack, upon further review this change does not get the results I need. It gets me the right sprints and backlog issues, however, if any of those issues have subtasks that are marked as done, then they are not captured by this Query.
Is there a different filter option that you could recommend I try?
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.