Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,367,377
Community Members
 
Community Events
168
Community Groups

How to count the issue that equal a fixed value by JQL

Edited
cao_qy I'm New Here Aug 07, 2022

Question :

I need count the numbers about " issues that include  2+ sprints",but i don't know how to realize the function by JQL

 

any answer ,you can also reply to the Email :564169154@qq.com

 

Thanks

3 answers

1 vote
Bharathi Rising Star Aug 08, 2022

Hi @cao_qy,

As others have mentioned, fetching the count of issues is not possible out-of-the-box with Jira's functionality. If you don't have any plug-ins, the best bet would be to individually list the sprint names/IDs and find the issue count that matches those, like below.

project = abc AND sprint in (100, 101)

Other than this, you can use the options provided by plug-ins like Scriptrunner using the scripted field option available.

Hope this helps!

Thanks!

Hi @cao_qy ,

welcome to the community.

If you're open to solutions from the Atlassian Marketplace, this is trivial to solve using the app that my team is working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing and inline-editing all your issue fields, plus a number of "special fields" that aren't natively available. One of these special fields is the number of sprints. You can then simply filter down your list of issues using Excel-like column filtering, and see the number of issues in the app's status bar:

number-of-sprints.gif

(It's worth noting that JXL can do much more than that: From inline issue creation to support for issue hierarchy, issue grouping, sum-ups, and conditional formatting.)

Hope this helps,

Best,

Hannes

Hi @cao_qy ,

Pls refer to this kb.

https://community.atlassian.com/t5/Jira-questions/How-can-I-find-an-issue-that-is-in-multiple-sprints/qaq-p/586873

If you're just looking for any issues which are or were in more than one sprint, I'd advise using a scripting app - such as Scriptrunner - to created a scripted field, to count the number of sprints an issue has listed against it.

You could then use JQL to search against the counter, to see issues in >1 sprints.

Suggest an answer

Log in or Sign up to answer