After a sprint has closed, I would like to be able to see the issues that were committed at the start of the sprint (not including anything that was added or removed). EazyBI has these filters but it will be time consuming to drill into every team. My thought was if I could query this then I can get one result and export the data.
I don't quite understand your question - you can generally look for things like that using JQL, but I don't understand what you mean by navigator. Do you just mean the the page you get when you're searching for tickets?
Try this query, you'll need to modify it to include the projects you're looking to check:
project in (project1, project2, project3) AND Sprint in (openSprints())
This will return tickets in open sprints (ie, committed), and the project clause is where you specify the team (assuming your teams use separate projects). You can change this to be "Team in (team1, team2, team3) AND Sprint in (openSprints())" if you're using a custom field called team instead.
Sorry I wasn't clear - After a sprint has closed, I would like to be able to see the issues that were committed at the start of the sprint (not including anything that was added or removed). EazyBI has these filters but it will be time consuming to drill into every team. My thought was if I could query this then I can get one result and export the data.
I do not know of a way to query that with out-of-the-box JQL. The closest thing to it is the built-in sprint report information.
There are marketplace scripting addons which might support this with extensions of JQL. Another option would be to use a custom field and an Automation for Jira rule to mark each issue when the sprint starts. You may then query them using built-in JQL later.
You can combine the eazyBI Sprint Issues committed measure with the Sprint dimension to get issues assigned to a selected sprint when the sprint was started. See example report (from all used measures, you can select only the measures you are interested in): https://eazybi.com/accounts/1000/cubes/Issues/reports/243468-sprint-issue-balance?
You can add any other dimension to drill further into the measure, e.g., Team (what kind of field is the team?).
Lauma / firstname.lastname@example.org
Thanks, I do not want to use EazyBI. I was looking for a way to do this in Issue Navigator. I want the list of issues and it is too difficult to drill into EazyBI for the number of teams that I am working with. Each team has their own sprint so this will become quite cumbersome in EazyBI.
@Christine Coenen I'm sorry for misunderstanding your question!
Still, I guess it depends on how you define the Team. For example, you could show the last closed Sprint from each board and see their commitment. And from eazyBI, you can navigate directly to the issue.
If you look back to using eazyBI for this but need assistance with building the report, please do not hesitate to contact email@example.com.
Lauma / firstname.lastname@example.org
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events