How to get all the Open sprints having the Sprint start date with a particular date using JQL

[Bhargavi Vasa]

Can we get all open sprints created before 1 year in JIRA using JQL?

[Mindaugas Dūda]

Hello @Bhargavi Vasa 

You can use following JQL:

sprint in openSprints() and created <= -365d order by created DESC

Regards,
Mindaugas

[Bhargavi Vasa]

Will "created" fetch the sprint start date? or it's the issue creation date?

[Mindaugas Dūda]

It's the issue creation date. Currently sprint start and end dates can not be searched by JQL. If you need these functions you might want to check app ScriptRunner for Jira by 
Adaptavist.

[Bhargavi Vasa]

Can u help us with one thing , How can we close sprints which are more than an year old i.e created before 2022 , I need to close issues in that as well as the Sprint.

Can you suggest me the solution for this scenario using groovy

[Mindaugas Dūda]

I'm sorry, not able to help you with groovy

[Bhargavi Vasa]

Can u suggest if there is any other alternate solution?