Display custom field value from a jql result in jira cloud

[AbrahamA]

Hello

Do you have a script sample to display custom field value from each issue of jql search result.

Can you please give some pointers.

Thanks

Abe

[Nic Brough -Adaptavist- · Accepted solution]

This script does most of what you need - https://library.adaptavist.com/entity/calculate-sum-of-fields?tab=cloud

You will need to replace the "find issues from their parent issues" with your JQL search, but the rest of it should work find for you.

[Jack Brickey]

Hi @AbrahamA , I'm guessing that you want something different than simply a JQL statement that presents a list of issues and that list includes a column for your custom field? I'm not quite sure what you're asking for here. Maybe you could elaborate?

[AbrahamA]

Helo Jack

Thanks for the response

I need to sum values in a particular custom field for all issues that match a condition. This is my requirement.

Thanks

Abe

[Jack Brickey]

I would export to Excel and sum. The official extension for excel would make it easy to do this too. In case you prefer Google apps - jira-cloud-for-google-sheets-official 

[AbrahamA]

I have scriptrunner, so I am looking for script route

[Jack Brickey]

I see. I have added "Scriptrunner" tag to your post.