How to query the Stories with not closed sub-tasks?

Question

Guys, I'd like to build a query that gives me all the stories that have not closed Sub-Tasks tied to it, and also all the Epics that have no stories underneath or are all closed. Does anyone have done this before?

I don't seem to find a way.

Thanks!

Stibally Guardado · Answer

Hi @Thomas Schlage  I don't have the Scriptrunner app, but I'll give it a try.

Thanks!

Thomas Schlegel · Answer

Do you have the Scriptrunner app? If so, you can use the following query for your first problem:

issuetype = story and issueFunction in parentsOf("status = Closed")