JQL get all added stories after start of Sprints

Question

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

Daniel Turczanski - JQL Search Extensions · Answer

Hi @True Indian

Some good answers here already. You can also consider using our professional indexing service

* JQL Search Extensions

After you install the app you can find out what issues were added after the sprint started:

issue in addedToSprintAfterStart("My board", "Sprint 5")

Make sure to check out the documentation.

I hope it helps!

Daniel Ebers · Answer

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:

* Advanced search reference - JQL fields
https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-fields/

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:

* Advanced search reference - JQL functions
https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/

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")

Source: https://docs.adaptavist.com/sr4jc/current/scriptrunner-enhanced-search/enhanced-search-included-functions#id-.EnhancedSearchIncludedFunctionsvCurrent-addedAfterSprintStart

Also useful are the reports, like sprint report that are included in JIra.
You could have a look here to learn more about them:

* View and understand the sprint report
https://support.atlassian.com/jira-software-cloud/docs/view-and-understand-the-sprint-report/

Regards,
Daniel

True Indian · Answer

i am not familiar with REST API  i just want to use JQL in jira to fetch the Board names and sprint names in project