Sorting using Lookupissues

[Tony Georgiadis]

Hey community, 

I'm creating an automation that will be manually triggered on each Epic, and which will then loop through children issues of this Epic, sort them by a custom field (ASC) - in our case 'Start Date', return the top value of the custom field (the oldest date), and then edit the Epic field to that value. 

I've managed to loop through children issues correctly, but the sorting lookupissues code returns null.

Trying to do this by creating a variable
oldestDate = {{#lookupIssues.sortBy("customfield_18559")}}{{first.customfield_18559}}{{/}}

Do people have any thoughts or ideas why this is not working, and what could pontetially be the fix?

Thanks in advance.

Tony

[Tony Georgiadis · Accepted solution]

Found a fix - 

{{lookupIssues.customfield_18559.min}}

This returns the correct result!

[Mohamed Benziane]

Hi,

In the JQL try to add the order by keyword