I want to find child issues Across Multiple level with specific linktypes

Question

Hello,

I want to find all children (Stories and Epic´s) under an defined Theme. The cascade is Theme realized in => initiative - realized in => Epic - issue in Epic => Story.

Until to Epic I have got code:   issueFunction in linkedIssuesOf("issue in linkedIssues('SYSE-42022', 'realized in')", "realized in")

the problem is know to find the stories under the epic.

kind regards George

Kalyan Sattaluri_iinm1n · Answer

Hello @Georg Fountoulakis

Usually Themes & Initiatives dont have hierarchy like Initiatives -> Epics -> Stories.

And Themes and Initiatives are at the same "level". That is my understanding.

So to test, Imagine you have a theme called "new enhacements".

Can you check if below gives you list of epics under this theme:

issuefunction in portfoliochildrenof('Project = ABCD and Theme = "new enhancements"'))

If above gives you a list of Epics, you find stories similarily by chaining:

issueFunction in issuesInEpics("issuefunction in portfoliochildrenof('Project = ABCD and Theme = \"new enhancements\"'))")

Hope it helps

Georg Fountoulakis · Answer

Hello Kalyan,

yes the scriptrunner ist installed and works well :)

Thank you for your code. This works for the initiatives or an list of initiatives very good :)

But I want to search under an "theme", to find out all stories. Do you have for an theme also an solution?

kind regards Georg

Kalyan Sattaluri_iinm1n · Answer

Hello @Georg Fountoulakis  Welcome.

Seems like you have scriptrunner installed.

If you need to find all Epics under Initiative, you can use issuefunction in portfoliochildrenof(query)

If you need find all stories then, you need to chain above with issuefunction in issuesinEpics(query)

So, all together, your final query will look like

issueFunction in issuesInEpics("issueFunction in portfolioChildrenOf('key= ABCD-123')")
Where ABCD-123 is your initiative key. Instead of Key, you can give a different crtieria to give you list of initiatives as well.
Hope it helps.