Hey folks, I’m trying to figure out how to see which tasks were wrapped up in our current sprint. It’s not about stuff that got done before but is still in testing. I want to focus on what the team actually finished this time around.
I’m thinking it should include both resolved and closed issues. But I can’t seem to find the right JQL for it. I’ve tried playing around with some date functions, but there’s nothing specific for sprint start dates.
We’re using JIRA cloud, so no fancy add-ons for us. Any ideas on how to pull this off? It’d be super helpful for our sprint reviews. Thanks!
I’ve found a reliable method for tracking completed issues in our ongoing sprints. Here’s what I do:
Create a new JQL filter with this query:
project = [YourProject] AND sprint in openSprints() AND status changed to (Done, Closed) during (startOfSprint(), now())
This captures all issues moved to Done or Closed within the current sprint timeframe. It’s been quite accurate for our team’s needs.
One caveat: if your workflow includes a ‘Testing’ or ‘QA’ step after ‘Done’, you might need to adjust the statuses in the query. Also, consider saving this as a shared filter for easy access during sprint reviews.
Remember to update your board columns to match these statuses for visual consistency.
hey there! i’ve got a trick that might help. try this JQL:
project = YourProject AND sprint in openSprints() AND resolutiondate >= startOfSprint()
it’ll show issues resolved in the current sprint. just tweak ‘YourProject’ to match yours. hope this helps with ur sprint reviews!
I’ve faced this exact challenge before, and here’s what worked for me:
Try using this JQL query:
project = YourProjectKey AND sprint in openSprints() AND status changed to (Resolved, Closed) DURING (startOfSprint(), endOfSprint())
This should catch all issues that were moved to Resolved or Closed status during the current sprint. It’s not perfect, as it might miss some edge cases, but it’s been reliable for our team’s sprint reviews.
One thing to keep in mind: if your team has a habit of resolving issues and then reopening them, you might want to tweak the query a bit. You could add something like ‘AND status in (Resolved, Closed)’ at the end to ensure you’re only seeing currently resolved/closed issues.
Hope this helps! Let me know if you need any clarification on setting it up.