nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

Gor Greyan

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")

Tudor Tofan

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.

All comments

Gor Greyan

Tudor Tofan

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.

Bisi Ade

That works! Thank you so much @Gor Greyan

Gor Greyan

Dear @Bisi Ade

Glad to help.

Evie Z.

@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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

unknown-hosting-type

jira-unknown-hosting-type