Nest a query for linked issues with a query for issues in an epic - possible?

[AB]

Hi,

I have this hirarchy:

1: initiative (with links to epics)

2: epic (with assigned stories)

3: story

I get all linked epics by this query: issue in linkedIssues(abc-123)

Of this result I want to get all stories which are assigned to the epics, like "epic link ="

Can I nest the two queries?

Thanks,

Alexander

[Trudy Claspill · Accepted solution]

Scriptrunner has a function called issuesInEpics. Try adding your filter to that:

issueFunction in issuesInEpics("issue in linkedIssues(abc-123)")

[AB]

Hi Trudy,

many thanks - this is exactly what I needed!

Alexander

[Jack Nolddor _Sweet Bananas_]

Hi ya! How are you doing?
This is Nolddor speaking from SweetBananas marketplace vendor.

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) Find all Epics linked to given Initiative (i.e. ABC-123)

type = Epic AND issue in linkedIssuesOf('key = ABC-123')

2) Find all Stories linked to above Epics

issue in issuesInEpics(' type = Epic AND issue in linkedIssuesOf("key = ABC-123") ')

3) All together (Initiative, Epics & Stories)

key = ABC-123 OR (type = Epic AND issue in linkedIssuesOf('key = ABC-123')) OR (issue in issuesInEpics(' type = Epic AND issue in linkedIssuesOf("key = ABC-123") '))

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

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

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

Regards

[AB]

Thanks for your answer, Jack!