JQL : How to see tasks in my epics

[Nicolas Rigaill]

Hi everyone,

I'm looking for query that shows only issues that are in Epics that are assigned to me. Does anyone have an idea ? 

I was thinking about something like : 

issueType in (Task, Story) AND parentEpic in (issueType = Epic AND assignee = currentUser())

Thank you,

Nicolas

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @Nicolas Rigaill 

welcome to the community!

Unfortunately, "plain" Jira isn't too great with searching and filtering across issue hierarchies, so to the best of my knowledge, you'll need extra tooling to solve your use case. A few directions forward:

• This should be possible in Advanced Roadmaps, since it has great support for issue hierarchies. If you create a plan that contains all the relevant epics, plus any potential stories, AR should show the stories under your epics, and all other stories in a special "other issues" "basket" that you can ignore.
• There's different apps from the Atlassian Marketplace that can help with that. On the one hand, there's a number of apps that extend JQL by additional functions, including hierarchy-related functions. I've used JQL Search Extensions a few times and it works great. The disadvantage is that you'll always only see your issues as a flat list, rather than in their hierarchy.
• Alternatively, you could try one of the more hierarchy-focused apps from the Marketplace. These apps typically have their own ways of figuring out parent/child relationships between issues, and provide more powerful ways to define and navigate through issue hierarchies. I myself work on such an app, in which your use case would be easy to solve; I'll provide more details below.

Hope this helps,

Best,

Hannes

[Hannes Obweger - JXL for Jira]

Just to expand on the last point, this is how this would look in the app that my team is working on, JXL for Jira; TLDR: You can simply load your relevant issues into a sheet, enable the default issue hierarchy (that's just one click), and then filter down to the epics that are assigned to you:

Once you've narrowed down your list of issues, you can work on these directly in JXL (much like you'd do in e.g. Excel or Google Sheets), trigger various operations in Jira, or export them for further processing.

As said above, there may be other apps that help with this, too. You may already know that you can trial any app for free for 1 month, and depending on the size of your size, it may be free forever. So if an app is an option for your, perhaps try a few and see which works best for you.

Any questions just let me know!

[Nicolas Rigaill]

Hi @Hannes Obweger - JXL for Jira ,

Thank you for this very complete feedback. I will take a look at your suggestions.
The ideal would be to be able to create a filter usable in a board.

Thank you,

Nicolas

[Hannes Obweger - JXL for Jira]

That would need one of the JQL extension apps. In JQL Search Extensions, you can save your query as a filter, which you can then use to power a board.

Best,

Hannes

[mauricio.groth]

Hi @Nicolas Rigaill

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 epic whose assignee is you.

issue in childrenOfEpicsInQuery("assignee = currentUser()") and type in (Task, Story)

After run this query, you can save it as a filter and then use it in your board.

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

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