Filter Out Done Linked Issues

[Kate W.]

I limited my linked issues to only return ones that are has to be done after and that are blocked. I need to export this to excel. Since Excel can't handle "~" rather than use the markdown logic I have put in X's. However, what I really want is to entirely exclude any returned results that are Done rather than just kind of flag them. Everything I've tried hasn't done anything. Any ideas?

Formula below:

WITH exclude(issue) = CONCAT(

  IF issue.status.category == "Done": "X", issue.key,

  IF issue.status.category == "Done": "X"

):

issueLinks

.FILTER(($.type = "Gantt End to Start" OR $.type = "blocks") and $.key.statusCategory != "Done")

.GROUP(IF $.source.key = key: $.type.inward)

.MAP(CONCAT(" ", $.elements.

MAP(IF $.source.key != key :exclude($.source))))

[Kate W. · Accepted solution]

Nevermind, got it:

WITH exclude(issue) = CONCAT(

  IF issue.status.category == "Done": "X", issue.key,

  IF issue.status.category == "Done": "X"

):

issueLinks

.FILTER(($.type = "Gantt End to Start" OR $.type = "blocks") and $.statuscategory != "Done")

.GROUP(IF $.source.key = key AND $.source.status != "Done" : $.type.inward)

.MAP(CONCAT(" ", $.elements.

MAP(IF $.source.key != key AND $.source.status != "Done" :exclude($.source))))