Need to get Max value of field from linked issues

[Sanjivani Wayal]

Hi,

I have and EPIC it has more than 4 issues (consider childisuses) linked to it with particular link name , all these child issues have different value in target pi's , i want the EPIC should take the max value from these values, i wanted to write the automation for the same.Not sure how to use MAX function for extracting value from linked issues

[Stefan Salzl]

Hi @Sanjivani Wayal 

Did you already try some solutions by your own? could you show how far you´ve come so far?

If you just starting with automation I reccomend to read through the basics and functionalities:
https://www.atlassian.com/software/jira/guides/automation/overview#what-is-automation

Further question:
Are you using structure or are those connections between epic and other issues casual epic-link (parent) connections?

When should the rule be triggered? (We only know about what should but not when and under which conditions)

Best
Stefan

[Sanjivani Wayal]

@Stefan Salzl  I havent tried for this one , however in past i have created and automation to get max value in a field which was in same issue , but here  i need to get the max value from other linked issue for which i didnt find condition which can pick values from related issues.

[Bill Sheboy]

Hi @Sanjivani Wayal 

Adding to Stefan's answer:

If you can write a JQL expression to find the issues, you can use the Lookup Issues action in an automation rule...and then easily find the maximum value for a field:

{{lookupIssues.someField.max}}

Please note this only works for numeric and date values.  To get the last alphanumeric value for a sort order, instead try adding an ORDER BY to your JQL, and then use last on the results:

{{lookupIssues.last.someField}}

Kind regards,
Bill