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 to get Epics where all Stories are done

AndréW_202mlf

Hello,

i need a query to get all epics having all linked stories done. I need it to correct the status of an epic if it is not done. In the same maner i have to get all stories, where the sub-tasks are allready done to set the status for such stories to the correct value.

I use the script runner add on. In SQL i could use the "not exists" clause to solve my problem. Maybe someone has an idea to how to solve it with jql.

Thanks.

Accepted answers

All comments

Pedro Felgueiras

Hy @AndréW

You can try something like these

issuetype = Epic and issueFunction not in linkedIssuesOf("resolution is Empty and issuetype = Story")

Best regards,

Pedro Felgueiras

AndréW_202mlf

Hi Pedro,

your suggestion doesn't work for me. I can use resolution is not empty or issuecategory = done, in all these cases i get epics that have stories which are done and not done. I only want to get epics where all stories are done.

Best regards from Germany.

Merle Fischer

Hi @AndréW ,

this thread should be what you are looking for, no?

https://community.atlassian.com/t5/Jira-questions/Filter-all-Epics-that-are-incomplete-but-only-have-Stories-that/qaq-p/233701

I believe what @Jamie Echlin _ScriptRunner - The Adaptavist Group_posted should be what you need.

Cheers

Merle

AndréW_202mlf

Thank you @Merle Fischer

the solution in the linked page works for me.

Bye.

AndréW_202mlf

For all with the same problem here are the working queries:

issuetype = epic AND issueFunction in linkedIssuesOf("status = Done", "has epic") AND NOT issueFunction in linkedIssuesOf("status != Done", "has epic") AND status != Closed

issuetype = story AND issueFunction in parentsof("status = done") AND NOT issueFunction in parentsof("status != done") AND status != done

Have a nice day.

Ansar Thennaden

Thanks a lot Andrew

Karla Bernal

hi, for that query in the "has epic" part... if I need to write has Feature Epic what would be the instruction? because I tried "has 'Feature Epic' ", "has [Feature Epic]", "has "Feature Epic" ", "has (Feature Epic)"... and nothing worked

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-server

jql