How can I use a combinatorial search in JQL?

Question

I want to list stories under specific epics.

I have issues which are type=Epic and issues which are type=Story. Each Story belongs in an Epic, so has an Epic link. Epics are marked with a release e.g. "Drop 1" in the Keywords field. Stories are not marked in the Keywords field.

I want a filter to list all Stories which are in Epics which have a Keyword of "Drop 1"

Is there a filter syntax to do that?

Simon Tavanyar · Answer

Thanks for both answers. That helps! (Keywords is a custom field.)

Alexey Matveev · Answer

Hello,

What is the Keword field? Is it a custom field?

You can not do it out of the box. You can use the ScriptRunner plugin:

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_issuesinepics

Chander Inguva · Answer

Hey Simon,

If you have Script runner plugin installed, you can try this

issueFunction in issuesInEpics("issuetype = Epic AND labels = Development")

which gives all issues (Stories/sub-tasks etc) linked to Epics for labels Development tied to Epic. You can update the field name instead of labels for your case accordingly.

If you would like only Story type try this

(issueFunction in issuesInEpics("issuetype = Epic AND labels = Development")) AND issuetype = Story

Thanks

Chander Inguva