Script Runner add-on for JIRA provides experimental feature Aggregate Expression - https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_aggregateexpression
I am curious if those results can be somehow embedded on a JIRA dashboard.
There is a REST Endpoint (
rest/scriptrunner-jira/latest/jqlfunctions/aggregateResult ) built into ScriptRunner that returns the results of the aggregateExpression function. You could send a GET request to it by fetching the a URL like the following, where the jql query parameter is a URL encoded JQL statment using aggregateExpression:
The above is equivalent to this JQL:
project=PROJ and issueFunction in aggregateExpression("Expr", "timespent.sum()")
Getting that content into a Dasbhoard is a little trickier.
Of note, we have a request in our backlog (SRJIRA-2104) to add Scripted Dashboard gadgets to ScriptRunner, which would constitute a third way. That said, it's not on the immediate roadmap for SR for JIRA.
If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...
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
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot