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

[Sofie Palacios]

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!

[Kalyan Sattaluri]

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]

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

[Kalyan Sattaluri]

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.