Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Looking for additional syntax on the issuelinks.filter function in a structure formula column

Michael P_ Caputo July 18, 2023

I am trying to add a column to a structure to show all linked issues of a certain type but then filter that list by another parameter such as SprintID.  Currently I am using: 

WITH _format(issue) = """[${issue.key}|${issue.url}]""" :
issuelinks
.FILTER(($.type = 'Tests' or $.type = 'Tested by') AND $.destination = this)
.MAP(_format($.source))

This works to get all the linked issues of that type but now I want to filter that list down for only items that belong to a specific sprint.  How do you add a filter parameter for the destination item?

1 answer

1 accepted

2 votes
Answer accepted
Stepan Kholodov _Tempo_
Community Champion
July 18, 2023

Hello @Michael P_ Caputo 

If you need to additionally filter out linked items that don't match a specific Sprint, you can add this condition to the formula like this:

WITH _format(issue) = """[${issue.key}|${issue.url}]""" :
issuelinks
.FILTER(($.type = 'Tests' or $.type = 'Tested by') AND $.destination = this)
.FILTER($.source.sprint.contains("sprint name"))

.MAP(_format($.source))

I hope this helps. If you have more questions, please feel free to reach out to us directly at our support portal.

Best regards,
Stepan Kholodov
Tempo

Michael P_ Caputo July 18, 2023

Perfect,  that is what I was looking for.  My head couldn't get around the fact that the filter is on teh 'source' not destination.  To me it's backwards.

Like # people like this

Suggest an answer

Log in or Sign up to answer