How to write JQL to return a total number not a list of all issues

Question

I am trying to make a table with numbers only- broken down by status/subtrack/type I am attaching my current JQL but need Jira to return only a number not the list of issues.

project = **** AND issuetype = "User Story" AND status = Done AND Sprint = 296 AND "Sub Track[Dropdown]" in (RTR-GL) AND "Subtype[Dropdown]" = Report

Carla Ann Rowland · Answer

This is a "long" way solution; I have tested it with tasks and subtasks but if you have sub-task filter functionality with Scriptrunner you can try this basic concept:

* Create a filter for specific set of issues 
* Display that filter result in Confluence using the display option to display the total only
* In my example my filter is basic in JIRA Cloud (all issues unassigned) and I call it in confluence cloud and display the total only:

Katerina Kovriga {Stiltsoft} · Answer

Hi @Anna Comer ,

We can suggest trying the Table Filter and Charts for Confluence app and its Table Filter macro - you'll be able to show all the issues via the Jira Issues macro and filter the result table from the page view by one or several fields. The number of the filtered entries will be shown near the table as well.

Nic Brough -Adaptavist- · Answer

No, JQL is for finding issues, nothing else.  The only possible result from JQL is a list of matching issues, that's what it is built for.

That said, there are plenty of reports that take a filter and do things like count results.  Might be worth a look at the 2d filter statistics gadget for a starter.