How can I search using JQL to find all the tasks associated with an initiative?

[Tracy B]

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. 

[John Funk · Accepted solution]

Hi Tracy,

Try using this: issuekey in portfolioChildIssuesOf("INIT-001") 

Substitute the key of your initiative for INIT-001

[Trudy Claspill]

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/

[Cristiano Alves -Appfire-]

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,

[Vitalii Rybka]

Hi Tracy!

You're right - parent only shows direct children. For all hierarchical tasks under an initiative, try:

"Epic Link" in (EPIC-123, EPIC-124, EPIC-125)

Or combine both levels:

parent = INIT-123 OR "Epic Link" in (EPIC-123, EPIC-124, EPIC-125)

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!

[John Funk]

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.