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