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

Georg Fountoulakis
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 4, 2024

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

Capture.PNG

1 answer

0 votes
Kalyan Sattaluri
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 4, 2024

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.
Georg Fountoulakis
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 5, 2024

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 6, 2024

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

 

Suggest an answer

Log in or Sign up to answer