What is the way to ask in JQL to count the issues, but only count once issue with the same value?

George Edward Yong García January 31, 2022

Hello,

I would like to know if there is a way to ask in JQL to count the issues, but only count once issue with the same value in a field.

 

jql-2.png

2 answers

0 votes
Ronald Khoo
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 17, 2024

In the bottom of the results list, you may see the total count of issues returned by your JQL:

image.png

0 votes
Tim Perrault
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 31, 2022

Hi @George Edward Yong García 

 

There isn't really any JQL that will help you count. You could write a filter and then use a dashboard gadget that might be able to give you a count. You could also export the search and use Excel to filter on the field.

 

Thanks,

Tim

George Edward Yong García January 31, 2022

is not there "GROUP BY" instruction ?

Tim Perrault
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 31, 2022

You could use ORDER BY Resumen but it won't give you a number count it would just order them by that field.

George Edward Yong García January 31, 2022

Sorry, I could not express what i want correctly. What I really want is that if several issues have the same value in a field, then only one issue of them appears.

jql-3.png

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 31, 2022

Hi @George Edward Yong García 

To add to what @Tim Perrault is describing, JQL is not a SQL, and so does not have many SQL common features, like GROUP BY, COUNT, etc.

Your work-around options are influenced by how often you need this capability:

  • infrequently: export your issue data for analysis in another tool, such as a spreadsheet, for analysis
  • frequently: investigate the marketplace for JQL addon apps

Kind regards,
Bill

George Edward Yong García February 1, 2022

Thanks a lot for your answers @Tim Perrault and @Bill Sheboy .

 

Regards

Like Bill Sheboy likes this
John Rocha June 28, 2023

The idea for exporting to excel doesn't work. JIRA stops after 1,001 entries, even when there are many, many more.....

Tim Perrault
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 28, 2023

@John Rocha 

 

It is possible to get more than 1000 entries, but it does require a bit more work than just hitting the export to csv button.

 

https://confluence.atlassian.com/jirakb/export-over-1000-results-to-excel-from-jira-cloud-779160833.html

Like John Rocha likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
TAGS
AUG Leaders

Atlassian Community Events