Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JQL get all added stories after start of Sprints

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

 

2 answers

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

JQL first get all the board names in project?

JQL get all the sprint names in project?

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

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 

0 votes
Daniel Ebers Community Leader Jul 16, 2021

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

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:

Regards,
Daniel

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS

Community Events

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

Events near you