How to write a JQL query for a quick filter showing all stories and tasks under all initiative?

[michelle.purcell]

I am looking to create a jql query for the following:

• All stories and tasks that could be under multiple initiatives where I consolidate based on the Initiative(s) assignee?
• Note:  Assignee at the Initiative is a single Assignee
• Note:  Expectation is that the stories and tasks will have multiple owners
• Looking for a solution that does not require listing all of the initiative keys as there could be additions to the list

[mauricio.groth · Accepted solution]

Hi @michelle.purcell 

I’m Maurício, a support engineer at Digital Toucan and I’m here to help you.

Unfortunately, using JQL of Jira, you’ll not be able to do it.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all your tasks and stories that are children of any Initiative.

issue in childrenOfIssuesInQuery("type = initiative") and type in (Story, Task)

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!
Best regards,
Maurício

[michelle.purcell]

Thanks Mauricio for your review and assistance.