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

How can I get Sprints by using JQL? Edited

How can I import Sprints by using JQL?

5 answers

2 votes
Alana Fernando Community Leader May 28, 2018

@Ajay Kere,

you can not get a list of sprints. but you can get tickets included in a sprint. Also note that sprints are not belong to projects. it belongs to board. 

Refer : Sprint per Project -JQL filter

Doesn't seem like they belong to boards.

Source 

Hi @Ajay Kere,

JQL is a query-language, you can only get data out of Jira with that but can not get anything inside Jira.

Yes
I need sprints for a particular Project. How can I get this?

Like Li Xirui likes this

If you want to get all issues for sprints in a specific project, you can refer to this KB article

https://confluence.atlassian.com/jirakb/jira-software-how-to-search-for-a-sprint-using-jql-779159065.html

You can also search for open, closed or future sprints:

https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-functions-reference-764478342.html

 

If you want to add Sprints, you can try to use the Rest-API:

https://docs.atlassian.com/jira-software/REST/7.0.4/

0 votes
Ollie Guan Community Leader May 28, 2018

Hi @Ajay Kere

What do you want to import? All the issues involved in the sprint?

I want all sprints for a particular project

@Ajay Kere

JQL = Search for issue

- Select your project,

- Click "More" --> Click "Sprint", then Choose Sprints 

Capture 2018-05-01 at 10.00.25.png

- Then save your JQL as filter JIRA 

- Now you can Export/Import all the issues involved in the sprint.

@Ajay Kere

Sprints cant import, but you can try this:

 

Search on JQL:

project = "project name" AND Sprint is not EMPTY  (this show all issues with sprint)

add column Sprints

image.png

export CSV.

Suggest an answer

Log in or Sign up to answer
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