nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL query to find issues in multiple closed sprints without using add-ons

meerm_ktdql6

I am looking for a JQL query to find issues that were in more than one sprint. I know we can use below query:

Sprint = openSprints() and Sprint = closedSprints()

this get me the current open issues which are in open and previously closed sprint. This is not going to solve my problem.

I need a query which finds issues which were in more one closed sprints. Basically I am looking for stories which spilled over to next sprints in last 6 months

Accepted answers

All comments

Bill Sheboy

Hi @meerm

Yes, this is possible. The how-to depends on how frequently you need to do this and what you want to do with the information...

Need this one time: Create a filter to find your issues, export them to a spreadsheet, and use formulas or pivots to count them. When issues are exported, a column is created for each sprint, so please take that into account.

Need this often: Discuss with your site admin about adding a custom field to count these occurrences and then add an automation rule triggered on Sprint Started to count the values and update the field. If your admin will not allow you to add the field, you can use an entity property instead, created/updated in the rule.

Kind regards,
Bill

meerm_ktdql6

Hi @Bill Sheboy

Thanks for the response. I need this often., can you give some examples on how and what to set entity property in this case.

Jehan Bhathena

Hi @meerm ,
Below was an attempt I took at your use case,

"T2CM Sprint 1" is closed, while "T2CM Sprint 2" is open. Are you looking for the issues like the one I have highlighted or is it some other scenario that you are looking for.

Bill Sheboy

An entity property can be set at various levels, including for the issue. And automation rules can set a property using an action: https://support.atlassian.com/cloud-automation/docs/jira-automation-actions/#Set-entity-property

So let's say you add a property named sprintcount to the issue, and in the rule the value is set based on the number of sprints with this:

That value would be the number of sprints noted in that field with a default of 0 when there are none.

You could later use JQL to query your entity property, as described here: https://developer.atlassian.com/cloud/jira/platform/jira-entity-properties/

meerm_ktdql6

Hi @Bill Sheboy

I have created an automation for assigning the entity value as "sprintcount".

Issu Entity Automation.png

Although the value is getting set and I am able to access the value in automation by populating it in comments or assigning through smart value, but when I am trying to access using JQL query as

issue.property[issuecount] > 1

I am not getting any value. Is there anything I am missing

meerm_ktdql6

Hi @Jehan Bhathena

Thanks for your response.

Yes I am getting the results using this query, but I also need to list issues having two closed sprints and not in open sprint.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud