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)
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.