I have multiple teams working under same project, using JQL i wan to get all the stories(issues) with subtasks which were added or deleted in the sprints, i want generate a report so it show how many stories for each team and each sprint from a project level
Hi @True Indian ,
Welcome to the community and thanks for posting in community.
Could you please try something like like this -
project = XXX and sprint in (sprint1, sprint2, sprint3,....)
Specify the project and all the sprints in the sprint details.
Please accept the answer if it helps else respond allow others to share input.
Stay safe and healthy.
Hi @True Indian ,
Thanks for your response.
I think it can be easily done with API. Call the API , get the json and convert it to csv(i.e. through any tool, code or online coverter - https://data.page/json/csv etc.).
e.g. - get all the boards - [jira-url]/rest/agile/1.0/board
get all the projects - [jira-url]/rest/agile/1.0/[board-id]/project
get all the sprint names - [jira-url]/rest/agile/1.0/[board-id]/sprint
For detailed documentation with REST API, please check here-
I hope that solves your query. If yes, please accept the answer else respond and please let me know.
Hi @True Indian
the easiest of all queries is for issues in a sprint like this:
sprint = "Sprint 1"
Where "Sprint 1" is the name of your sprint.
This is also described well in the documentation:
A handy feature is to search for issues in closed Sprints and open Sprints, alongside with future Sprints.
So for example you can find all issues that are assigned to a completed sprint:
sprint in closedSprints()
You can learn more about it here:
For querying issues which were added to a sprint after it started unfortunately an App is needed - often recommended is ScriptRunner and the query would be like:
issueFunction in addedAfterSprintStart("Sample Scrum Board", "Sample Sprint 3")
Also useful are the reports, like sprint report that are included in JIra.
You could have a look here to learn more about them:
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