how to find the issue with latest end date among those linked to current issue by Finish to Start

Question

I am trying to come up with a formula that checks if the current row in my structure has any dependencies that need to be completed before this issue, and if so add the effort for this issue to the latest among those.  I use a custom field "Code Complete Target Date" to store my date of interest. I am trying various versions of below, but get a syntax error

if (type == "Initiative" || type == "Epic") :
MAX#children{CodeCompleteTargetDate}
ELSE (IF JQL {issueFunction in hasLinkType("finish-start [GANTT]")} :
MAX{Need syntax to iterate among linkedIssues(issuekey, "finish-start [GANTT]") and return max of those values, or project start date if none has it set}
)

Wouldn't it be nice if the MAX could aggregate over links of a specific type?

David Niro · Answer

Hi @Surekha Gupta ,

You are very welcome!  Thank you for the additional detail!!  I'm starting to get a clearer picture of the goal.

I do have a few more questions.

What is used to indicate 552 has to be done after 551 (an issue link, its order in the structure, something else)?

Would you have multiple Code Complete dates under the same Epic, or just one?  And in the case there are multiple is the goal to have the projected CCTD populated based off of the preceding issue's CCTD + OE?

Best,
David

Surekha Gupta · Answer

David, Thank you for looking into my problem. The issues are in a structure, and they are more like siblings, say stories under an epic, where one must be finished before the other. I am trying to set the code complete date for dependent task to the dependency task + effort.

But more generally, I am trying to figure out how I can iterate over the results of a JQL query( in this case, issues that are current issues dependencies), accessing priperty of each result(in this case CCTD), and then apply an agreegate function to the property.

I realize that aggreegate functions can only agreegate over children or subtree, not over siblings or linkedissues, but what I am trying to do is essentially that.

Attaching a redacted snapshots of my config. Here, the story 552 has to be done after 551, so I want a custom field called 'projected CCTD' to be set to CCTD of 551 + 10d

David Niro · Answer

Hello @Surekha Gupta ,

Are the issues you are trying to reference in the structure?  and if so, are they considered "children" of the row you are trying to create the formula on?

Also, if you could explain the details of your use case and what the goal is, it may help me to determine what the best approach is.  I know you've described some of this, but I'm not sure I follow exactly and don't want to present a solution that isn't aligned with what you are trying to do.

Thank you!

Best,
David