Finding the largest number using Automation

[Dominic Mercorelli]

All, 

I am in need of run an automation task, that uses a JQL that returns all my epic within the last six months. Then I want to be able to increment through those epics, in order to find the largest number that is contained in a specific field.

FYI, this field is a short text field, as I don't want the commas to be shown. 

What would be the best way to go about doing this?

[Bill Sheboy · Accepted solution]

Hi @Dominic Mercorelli 

Please try using the Lookup Issues action with JQL to access your issues, and the max function on your field: {{lookupIssues.myCustomField.max}}

To possible limits of this technique are Lookup Issues can only access up to 100 issues, and you note using a short text field (rather than a numeric field)...so there could be sort-related impacts.

Kind regards,
Bill