Query for In Progress Epics with Deliverables that are Ready for Dev?

Sofie Palacios March 13, 2024

I think... I'm losing my mind. I don't even know where to begin with this, but like the title says... I'm having trouble querying for Deliverables that are in the Ready for Dev status with Epics that are currently the In Progress status. 

Any help would be very appreciated!

1 answer

0 votes
Kalyan Sattaluri
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 13, 2024

Hello @Sofie Palacios 

You have tagged this as Data center, can you tell if you have script runner or similar add-on available? Also is Deliverable issue type considered a parent of Epic?

Sofie Palacios March 13, 2024

I do have scriptrunner available! And yes, it is a parent of an Epic, apologies for the confusion! 

Kalyan Sattaluri
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 13, 2024

If your set up is like ours, A simple query would be like below:

issueFunction in portfolioParentsOf('project = XXXX and status = "In Progress and issuetype = Epic"') and issuetype = "Deliverable" and status = "Ready for Dev"

Where Project = XXXX is project where your epics exist.

 

Now if you dont know which projects the Epics exist, then you can try below:

issueFunction in portfolioParentsOf('issueFunction in portfolioChildrenOf("project = XXXXXX") and status = "3 - Started"') and issuetype = "Deliverable" and status = "Ready for Dev"

Where project = XXXXXX is where your Deliverables exist..

Please modify according to your set up and hopefully it works.

 

 

Suggest an answer

Log in or Sign up to answer