Forums

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

How do I write a query that displays stories and the defects that are BLOCKING that story

Trish Hindmarsh September 14, 2023

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

0 answers

Suggest an answer

Log in or Sign up to answer