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

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

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

1 answer

0 votes

Hello @Bhargavi Vasa

You can use following JQL:

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

Regards,
Mindaugas

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

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.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Can u suggest if there is any other alternate solution?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Reply

Suggest an answer

Log in or Sign up to answer

Was this helpful?

Thanks!

TAGS

Community showcase