finding max due date for issuleLinks in structure formula

[Surekha Gupta]

I have added a column that displays all issues linked to the current row by a link "Tests" using this formula. It is successfully printing the URLs of the linked issues separated by comma. ( i sued "wiki markup" option in dialog box to print a clickable link)

WITH _format(issue) = """[${issue.key}|${issue.url}]""" : issueLinks.Filter($.type = 'Tests' AND $.destination = this) .MAP(_format($.source))

Now, I would like to add another column to calculate the max due date from among the links. I tried below formula but it only shows the date of the first element in the comma separated list, regardless of whether I use MAX or not. ( i used Date/Time option to get the due date display correctly)

Max{TestedBy.ProjectedFixDate}

How can I get the maximum of the due dates among the links?

[Surekha Gupta · Accepted solution]

Actually, this is working, I did not have due date set correctly for the issue with latest date in the row that I was using to test.

[Tehmina Aslam]

is this work for the issues grouped by assignee?

[Surekha Gupta]

I cannot arrange my structure by assignee, but since this formula operates only on the current row, I think it will work regardless of how the rows are sorted.