We have Jira Premium and are using Initiatives. Is there an easy way using JQL to search and find all the hierarchical tasks? Simply using "parent" only gives me the epics directly attached to the initiative.
Hi Tracy,
Try using this: issuekey in portfolioChildIssuesOf("INIT-001")
Substitute the key of your initiative for INIT-001
Hi Tracy!
You're right - parent only shows direct children. For all hierarchical tasks under an initiative, try:
parent
<span>"Epic Link" in (EPIC-123, EPIC-124, EPIC-125)</span>
Or combine both levels:
<span>parent = INIT-123 OR "Epic Link" in (EPIC-123, EPIC-124, EPIC-125)</span>
JQL doesn't have native multi-level hierarchy search, so you might need ScriptRunner for more complex queries.
Best, Vitaliy
DM me if you have questions!
Epic Link has been deprecated. And parent = INIT-123 will only give you one level of depth which is exactly what Tracy said in her post.
And here is the documentation that describes that and other JQL functions specifically for the relationships built through Plans.
https://support.atlassian.com/jira-software-cloud/docs/search-for-advanced-roadmaps-custom-fields-in-jql/
Hello @Tracy B,
Cristiano from the AppFire team here.
While the portfolioChildIssuesOf("") will probably work on your case, if you're interested in a more extended version of it, the app our team works, well, JQL Search Extension, would give you this availability:
I.E:
issues in childrenOfIssuesInQueryRecursive("Project='Dressrosa' and Type = Initiative")
Would return all epics, stories and subtasks for all initiatives in a specific project, not only the key inquired.
Or you could go even further and:
issues in childrenOfIssuesInQueryRecursive("assignee='DonQuixote' and type=Initiative", 2)
Would query for all epics and stories, while excluding subtasks (the second parameter is a depth limiter for the recursiveness function) from all the indexed projects from a specific user.
If you have any questions or would like further assistance in setting this up, reach out to our support team.
Hope this helps,
Regards,
worth bearing in mind that the key is case-sensitive in this (unlike most other searches in JQL) - weird little anomaly
It looks like you're new here. Sign in or register to get started.
