This is a Jira/ Confluence question I believe.
I want to end up with a list of stories, and the Defects key of those that are blocking it. I am struggling because the only way I seem to be able to connect the story with the defect is via the linkedissues field, but this lists ALL links, not just BLOCKED.
Anyone got any suggestions, I am using table transformer in confluence to try and piece the queries together.
List of Defects blocking: project = "Delivery" AND issuetype = Bug AND issue in linkedIssuesFromFilter(TH-E2EStoriesOpen, "is blocked by") AND statusCategory not in (Done)
List of stories blocked: issueFunction in linkedIssuesOf("filter = \"TH-E2ELinkedDefectsBlocking\"", blocks)
But there is a many to many in the middle!!
I want to end up with Story Key, Status, Blocking Defect Key, Status