Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

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

📅 Partner Webinar & Events Opportunities: July 2022

Hi community 👋, Here is another monthly roundup of the partner-organized events in July 2022. If there is any event missing please let me know in the comments below 🙏 If you're looking for Atla...

29 views 0 2
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