how to retrieve total numbers of issues?

[Ger Bakker]

The Jira cloud version does not show the exact total number of issues retrieved by running a filter on the Issue Navigator page. Shown is "1,000+" instead of the total number.

I want to retrieve total numbers by issue type and overall to monitor changes in these numbers over time. I like to receive advice as to how to create filters to obtain those total numbers.

Thanks in advance.

Ger Bakker

[Eswar · Accepted solution]

You can also use the following API call to get the count of issues:

https://<domain>/rest/api/2/search?jql=

Then, search for "total" and you can find the count of issues in your instance.

[Louange HIRWA]

@Eswar I think this should be easily voted as the best answer! You just add the JQL to the URL and run it in the browser.


It worked!!

[Tim Kopperud]

You might also add &maxResults=0 to speed this up.

When executing this by REST while e.g. looping through many projects in a script, and the only thing we need is "total" for each project the property maxReslts=0 will return a short instant result instead of fetching a lot of issue data not used when we only looks for issue total. 

The URL will be e.g (using IT as a project name in this example):

https://<domain>/rest/api/2/search?jql=IT&maxResults=0

The return will only be like this: 

{
"startAt"=0,
"maxResults": 0,
"total": 9301,
"issues": []
}

We might also use this for counting total in all projects, like this:

https://<domain>/rest/api/2/search?jql=&maxResults=0

TimK

[Michiel Schuijer]

Nice solution from @Eswar and @Tim Kopperud!

Too bad it does not work for archived projects :(

It would make it easier for sys admins to determine if archived projects with < %amount% issues can be permanently deleted.

I wonder why it is needed to restore an archived project before it can be deleted, but that's for another post/suggestion...

[Charlie Misonne · Accepted solution]

Hi @Ger Bakker ,

I'm afraid there is no ideal solution. Here is a post where some users discuss workarounds: 

You can also vote on the related feature request: JRACLOUD-45639 

[Ger Bakker]

Hi @Charlie Misonne, thank you very much for your reply. I hope I can use the advice described in the related feature request to get me the total numbers I want to see.

[Ger Bakker]

Hi @Charlie Misonne, Thank your for your advice. See also Solved: JQL no longer displaying total number of issues if... (atlassian.com) the advice by Mr Amir Katz_Outseer that I like very much.

[Deepika Sunil]

@Ger Bakker how did you finally get the full count? Mr Amir's way, I do not have the option to Export --> Print list.

[Ger Bakker]

Hi @Deepika Sunil , I think you'd better ask assistance from your system administrator about Atlassian functionality or else Atlassian. The advice given by @Charlie Misonne works for me. Good luck in solving your problem.

[Deepika Sunil]

@Ger Bakker I have tried the 2-dimensional filter statistics and it works. Thank you!

[Mehmet A _Bloompeak_ · Accepted solution]

Hi @Ger Bakker ,

As an alternative, you can try Reports - Charts and Graphs for Jira app developed by our team to get reports on the number issues by project, sprint, status, etc.

Below you can see an article about creating custom reports, charts and graphs in Jira with our app.

How to Create Custom and Flexible Reports, Charts and Graphs in Jira

Here is our live demo dashboard where you can see and modify sample reports and play with them.

Hope it helps.

[Ger Bakker]

Hi @Mehmet A _Bloompeak_, Bloompeak Thank your for your advice. See also Solved: JQL no longer displaying total number of issues if... (atlassian.com) the advice by Mr Amir Katz_Outseer that I like very much.