Hi Community,
In my Jira cloud, I have set up my issue type hierarchy as: Initiative --> Epic --> Story
I have make one initiative as parent of several Epics and the Epics have stories as their child issues. And I have create a plan to include initiative, Epic and story. Right now, I'm using JQL as ' issuetype in (Initiative, Epic, story) OR parent in (Epic-1, Epic-2, Epic-3). This works now since I don't have to many Epics yet. But it would be hard to maintain if we have more Epics in the future.
I don't have apps like scriptrunner installed in my Jira. So I can't use the advance search provided by scriptrunner.
Is it possible to get all the child issues and grandchild issues for an Initiative using JQL? I think the function childIssuesOf() is no longer available now.
Thanks
Hi @Yi Meng
This should work:
issue in portfolioChildIssuesOf("ABC-123")
ABC-123 is the issue key for your Initiative.
Ste
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Not in Cloud.
You need a Premium plan - as you need Plans (formerly known as Advanced Roadmaps, or Portfolio for Jira).
Then you get access to this function.
Ste
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.
How would I do this if I am pulling the imitative from Jira Align? I have used issuekey in childIssuesOf("") for my standard Jira's, but I am on a new team who uses Jira Align for initiatives and I cannot pull data down on my SQL statements
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Just wanted to add that I have Premium at work, and this function is awesome and does exactly what I needed it to do here.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Yi Meng
I’m Charlotte, a support engineer at Appfire and I’m here to help you.
Unfortunately, natively, you’ll not be able to do it dynamically.
In the app where my team works, JQL Search Extensions for Jira, you can use this query to get all initiatives and their children:
issue in childrenOfIssuesInQueryRecursive("type=Initiative") OR issue in parentsOfIssuesInQuery("type=Epic")
Please contact our support if you have any other questions about this query.
We’ll be happy to help you! 😁
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Unfortunately, JQL Search Extensions for Jira doesn't work well.
e.g.
issue in childrenOfIssuesInQuery("Team[Team] = 05a58275-92dd-48fc-ac3c-a2105545f9af")
returns No Results
while the JQL itself
Team[Team] = 05a58275-92dd-48fc-ac3c-a2105545f9af
finds all of the parent items
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Have your checked the status of the app? If the status of the app is not Ready to Use, the issues were not indexed yet by the app and that's why you're not getting the correct results.
I just tested and the function works for me:
To check if the status of the app is ready to use, select Get Started from the side navigation bar, and you should see it in the top right corner of the screen:
If the status is anything other than "Ready to Use", it indicates that a full index hasn't been performed, and it could be due to permission issues. Please follow the steps in this documentation to rectify it.
Feel free to contact our support if you have any other questions about this issue.
We’ll be happy to help you! 😁
All the best,
Charlotte S. | Support Engineer
Appfire Support Team
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Charlotte. Our system shows Ready to Use. It now produces some results. I've saved my query as a filter to be able to run it in the Jira JQL window.
I now notice that it doesn't return sub-tasks of parent issues (e.g. stories, tasks) where the epic team is specified. Only goes one level deep.
Thoughts?
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.
You're right. JQL doesn't support recursive query. But I think this function can solve my problem.
portfolioChildIssuesOf("ABC-123")
I can use linedIssues and parent together but it's a little bit tedious if I have many Epics. In general initiatives are less than Epics. :)
Thank you for your help.
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.