finding max due date for issuleLinks in structure formula

Surekha Gupta
Contributor
September 20, 2023

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?

1 answer

1 accepted

0 votes
Answer accepted
Surekha Gupta
Contributor
September 20, 2023

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
Contributor
July 10, 2024

is this work for the issues grouped by assignee?

Surekha Gupta
Contributor
July 10, 2024

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.

Suggest an answer

Log in or Sign up to answer