Is there a definitive 'complete sprint' JQL query?

Question

Our engineering team are running into an issue with a project where, upon completion of the sprint, some issues are listed as incomplete despite no incomplete issues appearing on their board.

I believe that their board is not correctly filtering for issues which are marked 'Done' per their workflow but do not have a resolution set.

They've asked if there's a defined 'Complete Sprint' JQL query available to test against. I can't find one; it's a built-in Jira function, so functionality seems pretty much hidden under the hood.
Does anyone know if there is a definition of what runs when Complete Sprint is initiated?

Hana Kučerová · Accepted Answer

Hi @Ed Hirst ,

I believe you can use this JQL, see here for documentation:

Find all issues that are assigned to a completed sprint:

sprint in closedSprints()

Would you please provide use more information?

How does the board's filter look like? Is there a sub-filter? Is this classic or next-gen project?

Thank you!

Trudy P Claspill · Accepted Answer

Hello @Ed Hirst

Be advised that JIRA does not lock down what can be added to a sprint. There is nothing programmatically that will restrict the sprint to containing issues only that are within scope of the board where the sprint exists.

So, you may be getting the message about incomplete issues because some issue has been assigned to the sprint and that issue is NOT within scope of your board filter.

You should execute this query to see what is in the sprint that is not complete:

Sprint = 986 and (resolution is EMPTY or statuscategory != done)

Look for issues that are not in your specified project or where the Assignee is not among your list of assignees or the field where you specify "Team Name" is empty or has some other value.