Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Ways to display outputs of ScriptRunner functions - aggregateExpression()

Delighted to uncover some of the functions that ScriptRunner provides - especially the aggregateExpression() function which will be an absolute godsend for reporting!

I'm trying to work out better ways of displaying the calculated key/value pairs that aggregateExpression() outputs.  Are these calculated values only able to to be viewed in the Advanced Search for Issues screen in Jira or are there ways of being able to extract the calculated values (not the resulting list of issues) and perhaps display them on a dashboard gadget, Confluence page or maybe email their outputs to somewhere.  We have Jira Automation too if throwing that into the mix helps..?


1 answer

Hi John,

Thank you for your question.

I can confirm that if you are using ScriptRunner for Jira Cloud then we do not provide the aggregrateExpression() search method as this is currently only available in the Server version of ScriptRunner.

As for the server version, I can confirm this output can only be displayed in the query and cannot be displayed in dashboard gadgets as it is calculated when the JQL search is run.

If you have further questions around the server version then I would ask you to raise a support ticket with our server support team here so that a member of this could advise if there is another way to achieve your requirement. 

I hope this helps.


Hi Kristian,

do you know if it is possible to show the aggregateExpression() results on a confluence page?




Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Apps & Integrations

🍻🍂Apptoberfest Update: Upcoming Virtual Events 🎉

Hello Community! I hope you've been enjoying the 🍂Apptoberfestivities🍂 (I know I have!) The event is heating up next week with a series of virtual events that we're calling the 🍻🍂Partner App ...

110 views 1 8
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you