Can I add OR in below formula to add the different type of issue links and put more AND
Original formula:
WITH _format(issue) = """[${issue.key}|${issue.url}]""" :
issuelinks
.FILTER($.type = 'Blocks' AND $.destination = this)
.MAP(_format($.source))
Modified Formula: (Its not working though as it does not take show OR Type and also it does not check if the source issue type is 'Risk' or not. Also it pulls all statuses even though I tried to filter like not contain "Resolved").
Can someone please help me to provide correct formula?
WITH _format(issue) = """[${issue.key}|${issue.url}]""" :
issuelinks
.FILTER($.type = 'Impact' OR $.type = 'is depended on by' AND $.destination = this AND $.source.issueType = 'Risk' and !CONTAINS(ARRAY("Accepted", "Rejected", "Resolved", "Mitigated", "Done"),$.source.status) )
.MAP($.source.key CONCAT ' → ' CONCAT $.type CONCAT ' → ' CONCAT $.destination.key)
Hello @Yatiraj Sharma
Please note:
- $.type = 'Impact' OR $.type = 'is depended on by' can't work as expected because you need to specify the Link Type here; 'Impact' is the link type, but 'is depended on by' is a link direction of a particular link. You can find the link type to which it belongs at Administration | Issues | Issue linking, and then update the reference in the formula.
- the condition for multiple link types should be enclosed in brackets for clarity: issuelinks
.FILTER(($.type = 'Impact' OR $.type = 'another link type name') AND...
I hope this helps. If you have more questions about Structure, please reach out to us directly at our support portal.
Best regards,
Stepan
Tempo (the Structure app vendor)
HI @Yatiraj Sharma ,
Not super familiar with the structure formula. However, the way it's written, the OR might to be written as "||" with double pipes. Hopefully this helps. Although, I would recommend testing with a basic formula with the double pipes.
All the best.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.