Can we get all open sprints created before 1 year in JIRA using JQL?
Hello @Bhargavi Vasa
You can use following JQL:
sprint in openSprints() and created <= -365d order by created DESC
Regards,
Mindaugas
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.
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.