How to find which Sprints have auto-start and auto-complete defined in Jira
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles for non-Data Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
As a Jira admin, you may want to find which Sprints on your instance are configured with auto-start and auto-complete. This configuration is defined for each Sprint by editing or when creating the Sprint (reference: Configuring a sprint to auto-start and auto-complete).
- To be able to configure auto-start and auto-complete you must have Parallel Sprints enabled.
Solution
Since it's not possible to find this for the whole instance through the UI, the method suggested is through the database.
The query was tested on PostgreSQL. You may need to modify the syntax by adding the schema or removing the quotes depending on the database product.
SELECT * FROM "AO_60DB71_SPRINT" where "AUTO_START_STOP"=true and "CLOSED"=false;- You can remove the "CLOSED"=false condition if you'd like to get completed Sprints as well.
Alternatively you can join with the RAPIDVIEW table to get the origin board and limit the output to just get the name of the Sprint and the Board:
SELECT s."NAME",rv."NAME" FROM "AO_60DB71_SPRINT"s left join "AO_60DB71_RAPIDVIEW" rv on s."RAPID_VIEW_ID"=rv."ID" where s."AUTO_START_STOP"=true and s."CLOSED"=false;