nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to subtotal JQL queries

Sandra Monk

Hi, I'm managing defects with Jira. I want to list all the defects I have yet to complete Triage on, and get a total by priority

We have an existing board that subtotals by priority (the Kanban board) but it does not allow me to filter

I have another board that lets me filter but has no totals (Issues board), here is my filter:

project = XXXX AND issuetype = Defect AND (status = New OR Assignee = currentUser() AND status not in (resolved, released, closed)) ORDER BY priority DESC, created ASC

I have a third board that will let me enter filters, and has subtotals (by sprint) so I know it is possible to combine the two. I have read though the help text looking for Group By, Count or Total, and also looked for other Questions asking about this

I am not a board owner or administrator.

Please give me some tips on how to do this. How can I add a filter to the board that totals correctly, or a total to the board that filters, or change what is being filtered by on the third board?

Accepted answers

Nguyen Tran

Hi Sandra,

I'd recommend creating a dashboard instead. You can use the "Issue Statistics" gadget. Put your filter in and set the Statistic Type to "Priority". Then you can see the total very quickly and dynamically.

Nguyen

All comments

Nguyen Tran

Hi Sandra,

Nguyen

Sandra Monk

Thanks for your help.

Piotr Bojko

Using the addon https://marketplace.atlassian.com/1218767 you would use SQL like language to have bacic queries and computations

SELECT
J.Priority,
SUM(J.Key)
FROM TABLE(JQL('Priority, Key', 'project = XXXX AND issuetype = Defect AND (status = New OR Assignee = currentUser() AND status not in (resolved, released, closed))')) AS J
GROUP BY J.Priority

With the addon you can merge the JQL queries with SQL

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira