nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Create a calculated custom field in an epic that sums the value of a custom field of linked issues?

gayane.khayiguian

Hi Everyone,

We have the Addon JIRA MISC CUSTOM FIELD

https://innovalog.atlassian.net/wiki/spaces/JMCF/overview?homepageId=141891457

I would like to create a calculated field in an epic that would sum the values of a number custom field filtered on the current linked issues of the epic.

I am pretty sure this is possible to do it with the addon but i am struggling to write the right script, as I have too few knowledge on Groovy script. Could anyone help me with a code ?

Here is what i would like :

Epic

Calculated custom field = Sum of values of linked issues Custom field 1

Epic Linked issues

Issue 1

Value Custom field 1

Issue 2

Value Custom field 1

Issue 3

Value Custom field 1

Thank you so much for your help!

Accepted answers

All comments

David Fischer

Hi,

what is the link between the Epic and the issues from which to sum the custom field? Are they the issues that belong to the Epic? If so, you can use this:

issue.stories.sum {it.get("customfield_12345")?:0}

If they are issues linked to the Epic through issue links, you can do something like:

issue.getLinkedIssues("link type direction").sum {it.get("customfield_12345")?:0}

gayane.khayiguian

Hi David, Thanks for your answer!

I tried and the script returns no error but even though my fields have values it still returns "null"

I created 3 tasks and completed values in the custom number field i want to sum + have added the epic link but it doesn't seem to sum the value in the calculated field in the epic...

Could it be because of the "link type direction"?

Thanks again for your precious help!

David Fischer

If you have added the Epic Link on the tasks, that means the task belong to the Epic. You therefore need to use the first script I provided.

Gunti_Reddy_noba3o

HI,

Please provide script to add sum of one or more custom fields from Stories to EPic.

Here is what i would like :

Epic

Calculated custom field = Sum of values of linked issues Custom field 1 and Custom field 2

Epic Linked issues

Issue 1

Value Custom field 1

Value Custom field 2

Issue 2

Value Custom field 1

Value Custom field 2

Thanks,

Gunti

Arne Becher

Hi Like,

I have a basic question about the examples shown here.

Is there somewhere a general description of all possible programming commands for automations, preferably with examples?

Thanks
Arne

David Fischer

Hi @Arne Becher ,

you mean beyond the JMCF documentation? The documentation already provides information about the Groovy language, with a tutorial and a lot of examples.

Arne Becher

Hi Like,

thank you very much.

However, I meant commands for Jira Automations to be used in general.

Also I oversaw that the thread above is related to jira server and an add-on for that. Unfortunately I use jira cloud

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server

groovy

jira-misc-custom-fields