Need to get Max value of field from linked issues

Sanjivani Wayal
Contributor
August 28, 2023

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

1 answer

0 votes
Stefan Salzl
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 28, 2023

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
Contributor
August 28, 2023

@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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 28, 2023

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

Like # people like this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events