How can I get Sprints by using JQL?

[Ajay Kere]

How can I import Sprints by using JQL?

[Alana Fernando]

@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

[dmoron]

Doesn't seem like they belong to boards.

Source 

[RNV]

@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

export CSV.

[Mariem Bayoudh]

@Ajay Kere

JQL = Search for issue

- Select your project,

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

- Then save your JQL as filter JIRA 

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

[Ollie Guan]

Hi @Ajay Kere，

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

[Ajay Kere]

I want all sprints for a particular project

[Bastian Stehmann]

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.

[Ajay Kere]

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

[Bastian Stehmann]

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/