Determine the maximum due date of all the linked issues of a row in Jira Structure

[soumya_sikder]

I have a custom formula column that helps me determine all the dependent issue links for a given item in Jira Structure. Now I need to know what is the maximum due date of the linked issues. Currently I am able to access all the issue properties of the dependent links that are included in the ItemProperties-IssueLinkSource.

Unfortunately the property (i.e. Due Date) is not part of the available properties as defined in the list mentioned in the above link. Now I have the list of all dependent issue key. Can you please help me with a solution or preferably with a formula how I can extract the due date of the issue from its key value? I tried with JQL formula but it doesn't support variable values in its query string. 

Below is the Formula query I am trying to use but its returning no results.

MAX(issueLinks.FILTER($.type = "Dependency" AND $.destination = this).UNIQUE().MAP($.source.dueDate))

However, when I a using the following formula query I am getting all the dependent issue keys.

issueLinks.FILTER($.type = "Dependency" AND $.destination = this).UNIQUE().MAP($.source)

Is there any way how I can extract issue details from the issue key as derived from the IssueLink Source?

[Valerie Knapp]

Hi @soumya_sikder , welcome to the Atlassian Community and thanks for your question. 

My two recommendations for a question like yours are to check the product documentation, which you've already done or to open a ticket to the vendor. In my experience, the folks over at Structure are really helpful. If you don't get anyone who can help you here, I would try them https://marketplace.atlassian.com/apps/34717/structure-by-tempo-jira-portfolio-management-ppm?hosting=cloud&tab=support 

Best wishes