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

pallavi.kulkarni
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!
December 8, 2024

 

Hi Everyone,

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

  1. The parent of the "Roadmap Item" is an "Initiative".
  2. 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!

3 answers

0 votes
Rahul_RVS_Support
Atlassian Partner
December 10, 2024

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)

Links Hierarchy - Additional Criteria - New.PNG

 

0 votes
Prosper Agwegiokhe December 8, 2024

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.

0 votes
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 8, 2024

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?

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events