I want to pull all the issues from initiatives where summary of initiative contains 'Onboarding'

suruchi ablish April 6, 2023

I have 4 initiatives with Summary contains 'Onboarding' and I just need to pull all those Stories/Epics/Features to be pulled in my Jira pla which belong to these 4 initiatives

1 answer

0 votes
Kristopher Perez
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.
April 6, 2023

So finding the all children (across all the levels; epic, standard, and sub-task) of an Initative can be found with the following JQL

issuekey in portfolioChildIssuesOf(MYKEY-1)

In order to get the 4 you would need to do this with OR statements, so it would look something like this:

issuekey in portfolioChildIssuesOf(MYKEY-1) Or issuekey in portfolioChildIssuesOf(MYKEY-2)

Because of the way Advanced Roadmaps is structured, the Initiatives must be explicitly stated in the JQL.

suruchi ablish April 8, 2023

How this will work in Data center? And second thing is can I have a JQL filter that pulls everything from all the Initiatives where label = onboarding ? 

Kristopher Perez
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.
April 8, 2023

Yes, this will work in Data Center as well, and no you cannot reference Initiatives with any other attribute other than explicit issue key. This is why I have the JQL structure as an OR statement with each key listed.

suruchi ablish April 11, 2023

So how do I get all the children from all the initiatives where the Summary of initiative contain 'Onboarding'? 

suruchi ablish April 11, 2023

I was actually expecting that I can have a nested jql that will help with this request. 

For example ->

Project = Abcd-101 AND potfoliochildissue of Initiative where Summary ~ 'onboarding'

Kristopher Perez
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.
April 11, 2023

The portfolio JQL is not capable of doing what you are asking. You will need to include each Initiative, by key, in the format I provided above.

That answer could change based on additional addons you may have with enchanted search capabilities, but the native Jira JQL doesn’t allow for this kind of referencing.

Kristopher Perez
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.
April 12, 2023

For a little more context - here is the documentation around Advamced Roadmaps JQL with examples - https://support.atlassian.com/jira-software-cloud/docs/search-for-advanced-roadmaps-custom-fields-in-jql/

Suggest an answer

Log in or Sign up to answer