Hi Everyone,
I'm trying to create a JQL query to pull all "Roadmap Item" issues where:
The result set should include only "Roadmap Item" issues where:
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!
Welcome to the community !!
If you would be interested to try out a mktplace app for this requirement, do take a look at
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)
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.