JQL get all added stories after start of Sprints

[True Indian]

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]

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]

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

[Suvradip Paul]

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.

Cheers

Suvradip

[True Indian]

JQL first get all the board names in project?

JQL get all the sprint names in project?

[Suvradip Paul]

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-

https://developer.atlassian.com/cloud/jira/software/rest/intro/

I hope that solves your query. If yes, please accept the answer else respond and please let me know.

Cheers

Suvradip

[True Indian]

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