Query for Roadmap Items with Parent Initiative Having a Specific Field Value

Question

Hi Everyone,

I'm trying to create a JQL query to pull all "Roadmap Item" issues where:

* The parent of the "Roadmap Item" is an "Initiative".
* The parent "Initiative" has the custom field Initiative Source with the value set to "VCP".

The result set should include only "Roadmap Item" issues where:

* The "Parent Link" field is not null.
* The parent "Initiative" satisfies the above condition (Initiative Source = VCP).

I have already created a filter for Initiatives (Initiative_Source_VCP) that retrieves all Initiatives where "Initiative Source" = VCP. However, I am having trouble linking this filter to query the child "Roadmap Items".

issuetype = "Roadmap Item" AND Parent in (filter = "Initiative_Source_VCP")

This does not seem to work. Could anyone suggest the correct way to structure this query or confirm if JQL supports such parent-child hierarchical queries?

Thanks in advance for your help!

Rahul_RVS · Answer

Hi @pallavi.kulkarni

Welcome to the community !!

If you would be interested to try out a mktplace app for this requirement, do take a look at

Issue Hierarchy

The app allows to have a separate JQL for your child issues, which allows to narrow down your search. The app has multiple other useful features including Gantt view for project tracking. Do give it  a try.

(Disclaimer: I work for RVS, the vendor for this app)

Prosper Agwegiokhe_wkahkr · Answer

Hi @pallavi.kulkarni ,

Welcome to the Atlassian Community!

My name is Prosper, a support engineer at Appfire, and I’m here to help.

If you are open a plugging suggestion, I recommend trying our App JQL Search Extension for Jira.

You can use this query:

issue in childrenOfIssuesInQuery("filter = 'Initiative_Source_VCP'")

This query will return all child issues of the parent issues within the "Initiative_Source_VCP" filter. If you'd like to get the next child and all its descendants, you can use:

childrenOfIssuesInQueryRecursive.

For more details about these queries, feel free to refer to the documentation, and don't hesitate to reach out to our support team if you have any further questions.

We’d be happy to assist you!

Best regards,
Prosper.

Trudy P Claspill · Answer

Hello @pallavi.kulkarni

Welcome to the Atlassian community.

That sort of nested filtering is not supported natively by Jira.

It can be supported through use of some third party apps that extend JQL capabilities. Are you willing to consider such apps?