I'd like to get a total sum of original estimate for issues (by filter condition) in a project that would do something like this:
SELECT SUM(originalEstimate) FROM ... WHERE project="Project Name" AND status IN("Resolved", "Closed");
Is something like this in any way possible from Jira? I managed to write a real SQL query to my MySQL database that gives me the result, but it's a bit clumsy compared to doing it from Jira.
If you have ScriptRunner, this JQL query should show you the overall remaining workload for the current user:
project = PROJECT and assignee = currentuser() and issueFunction in aggregateExpression("Total Estimate for all Issues", "originalEstimate.sum()", "Remaining work", "remainingEstimate.sum()")
The documentation is here:
JQL is not SQL. It is exclusively designed for finding issues, it has nothing to say about the output (the line blurs slightly with the "order by" but that's actually still separate from what JQL does)
Think of it as two separate parts. You do the search in JQL, and that gives you a list of matching issues. That's all it does.
If you want to see that output, you have to hand that filter to a display mechanism. Jira has loads of these - broadly the issue navigator, gadgets, reports. The display mechanism then reads and formats the data on the issues in whatever way you want.
So, there's no way to do this in a JQL query, because JQL tells Jira nothing about the output. You need to find a reporting mechanism. Have a look at the issue navigator and the "sum" fields (prefixed with sigmas in the "add column" drop down list). The project reports might tell you something, as well as some gadgets. I suspect none of them will do quite what you want, as they're all generalised, and you may need to write something.
I just added a Chrome extension to the Chrome webstore that shows the summary of remaining estimates in Jira scrum boards, if you show the remaining estimates per issue: https://chrome.google.com/webstore/detail/estimations-sum-for-jira/mmbocjepfajlidapdnikdjebbdfjgbki
I can see this on the main dashboard as a option for adding a field, yet I can't write a filter showing the Sum of values. I'd love to say where sum(timeoriginalestimate) is 0, highlight these issues in my filter. I'm using with sub-tasks where the hours are actually estimated.
Any thoughts on how to fix would be ideal!
I have the same problem. How can I add these values and keep them "available" to make some calculations that I want to put in some reports?
Besides, the info I want to add is the total time spent by the issue, since its beginning until its closure.
As I have seen so far, the sumUp add-on adds only numeric fields.
Any help, please?
This approach requires you to have the JIRA administrative rights. The main aim of this article is to help you achieve an organized, easy-to-maintain workflows in your JIRA instance thereby, reducin...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs