Structure: Highlight delayed dependencies

Question

I currently use Structure DC and would like to use a Formula to highlight any issue Dependencies that have a Fix Version with a date beyond the primary issue's Fix Version date.

I already show my Dependencies using this formula:

with issuelinks_filter = issuelinks .FILTER( $.type = 'depends on' AND $.source = this ): IF issuelinks_filter: concat( "{panel:borderStyle=none}", issuelinks_filter.destination,issuelinks_filter.destination.key.unique, "{panel}" )

This works well in showing me the list of Dependencies.  However, I'd like to highlight (maybe change the text Red or background Red) to highlight any Dependency item with a Fix Version that has a date beyond the current Fix Version.

I have not tried to do a nested formula within linked issues, so any guidance would be appreciated.

Stepan Kholodov · Answer

Hello @Bradley Davidson

For showing issue keys of linked issues that have versions with Release date later than the parent issue's own version's Release date, you can use a formula like this:

if issuelinks.filter($.type = "depends on" and $.source = this and $.destination.versions.releasedate.flatten()>versions.releasedate):concat( "{panel:bgColor=#ff0000}",issuelinks.filter($.type = "depends on" and $.source = this and $.destination.versions.releasedate.flatten()>versions.releasedate).map($.destination.key), "{panel}" )

If any of linked issues match to the condition, their issuekeys will be returned on the red background.

I hope this helps. If you need further assistance with the formula or if you have other questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)