Search issues from a list of issuekeys generated by a previous JQL search

[Mathieu Lapeyre]

Hello,

I am trying to create a JIRA dashboard that lists the user-stories which belong to a list of EPICs. I don't know the EPIC issuekeys in advance so I need to do a JQL search before.

How can I include this JQL query within the second JQL query?

e.g:

"Epic Link" in (project in (PROJECTA, PROJECTB, PROJECTC) AND "Current Quarter" in cascadeOption(2020, Q3))

 This ☝️would list all the user-stories that belong to the EPICs which are in our Q3 2020 roadmap.

Thank you!

[Jack Nolddor _Sweet Bananas_ · Accepted solution]

Hi,

Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack (if you are on Server / DataCenter) you can type the following:

1) A bunch of Epics....

type = Epic AND project in (PROJECTA, PROJECTB) AND "Current Quarter" IN cascadeOption(2020, Q3))

2) Stories of above Epics

type = Story AND issue IN issuesInEpics(' type = Epic AND project in (PROJECTA, PROJECTB) AND "Current Quarter" IN cascadeOption(2020, Q3))')

(*) Note that this is just an example, you must tune above query to fit your needs.

Using this app you can also query other issues relations, check:

• epicsOf()
• hasSubtasks()
• issuesInEpics()
• linkedIssuesOf()
• parentsOf()
• portfolioChildOf()
• portfolioParentOf()
• subtasksOf()

[Mathieu Lapeyre]

😭 Thanks @Jack Nolddor _Sweet Bananas_

We will look for an alternative then ✅