How can I create a Scriptrunner JQL to list all open tickets (Epics) linked to closed deliverables

[Bisi Ade]

Hi all, I need a JQL query that returns all open tickets which are linked to closed deliverables.

I'm new to Jira and Scriptrunner, and the queries I've tried so far are returning errors. My goal is to identify any open epics where the parent(objectives) has a status of done.

Could anyone please help with the correct JQL or example for this?

Thanks so much for your help.

[Tudor Tofan · Accepted solution]

Hi @Bisi Ade !

The JQL query should be something like this:

issuetype = epic and statusCategory != done and issueFunction in portfolioChildrenOf("issuetype = objectives and status = done")

For this, you definitely need Scriptrunner as the "portfolioChildrenOf" function is not standard JQL and only comes with the addon.

Also, you haven't mentioned the hosting type for your Jira installation. I can confirm this is working on DC. I will come back with a confirmation for Cloud as well.

[Gor Greyan · Accepted solution]

Hi @Bisi Ade ,

Welcome to the Atlassian Community!

Try this one, it works on my side.

issuetype = Epic AND statusCategory != Done AND issueFunction in linkedIssuesOf(
"issuetype = deliverable AND statusCategory = Done")

[Bisi Ade]

That works! Thank you so much @Gor Greyan 

[Gor Greyan]

Dear @Bisi Ade

Glad to help.

[Evania Zhang]

@Bisi Ade Thank you for your post!

In order to stop receiving notifications for this post, please click on the Watch/Unwatch feature (looks like an eye) below your post.