Conditional Display in Structure

[Hadassa]

Hello everyone! 😊

I need assistance displaying a restriction in my Structure based on two conditions:

1. a custom field of type Date Picker is past the current date.
2. There are linked issues of a specific type associated with an Epic (inserted as issues for the Epic type), and all of these linked issues must be in either Done or Canceled status.

If one of the condition do not meet the above criteria, I want to display the restriction.

here what I wort already:

if (fieldDate <= TODAY() and

(issuelink.filter(issueType == "test" and status != "Done" and status!="Canceled").size>0)): "🔴" 

Could you please help me validate or improve this?

Thanks!

Hadassa.

[Stepan Kholodov _Tempo_]

Hello @Hadassa 

for linked issues of the Epic, i.e. for issues that appear in the Linked issues section in the Issue Page, you can use a formula like this:

if fielddate <= today() and issuelinks.filter($.destination.issuetype = "test" and $.destination.status != "done" and $.destination.status != "cancelled").size()>0: "(!)"

you might need to change destination to source, depending on the direction of the link from the Epic to its linked issues.

and with this part of the formula, you can check for issues of Epics, i.e. those that appear in the Issues in epic section:

stories.filter($.issuetype = "test" and $.status != "done" and $.status != "cancelled").size()

Alternatively, you can add both types of issues in the structure underneath the Epic using Extend generators, and use a much simpler formula:

if fielddate <= today() and sum#children{if issuetype = "test" and status != "done" and status != "cancelled": 1) > 0: "(!)"

the format of the column should be set as Wiki Markup - then the yellow triangle emoji will be displayed.

I hope this helps. If you need further assistance with the formula, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)