Want to write a JQL query to return a summary of issue types within a fixedversion

Question

I am trying to write JQL query to return a summary list of storries or bugs within an unreleased fixedversions within a project associated with a particular product, so I want. The returned columns

Product = DEF, Stories = 3, Bugs = 4

Product = GHI, Stories = 2, Bugs = 1

Nic Brough -Adaptavist- · Answer

JQL is for finding issues, not reporting on them.  You'll need a JQL query to get the list of issues you want to report on (So something like "Product in (DEF, GHI)") and then use that in a gadget or report.

The most simple and intuitive report is the issue navigator, where you get the results of a search by default.  Run your JQL, save it as a filter, then (optionally) set the columns to include at least issue type and product.  That will show you the raw data you want to aggregate.

Then go to your dashboard (or add a new one) and add a gadget.  For the case you've got, I would suggest the "2 dimensional filter" gadget, as you can tell that to use your saved filter, and report on maybe an X axis of "issue type" and a Y axis of "product" to get a grid telling you the things in your question.

DPKJ · Answer

@Michael LeakJQL is not SQL, it only return list of issues in Jira, it doesn't have projections and aggregation like SQL.

https://www.atlassian.com/blog/jira-software/jql-the-most-flexible-way-to-search-jira-14