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

[suruchi ablish]

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

[Kristopher Perez]

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]

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]

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]

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

[suruchi ablish]

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]

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]

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/