Filter by subtasks that belong to a specific epic and asignee - Team managed project

[chernandez]

Hello, I'm working on a team-managed project. I'm trying to create a specific filter, but I'm not having any luck. I'd like to be able to filter subtasks that belong to a specific epic, ideally by assigned user. Is this possible? 

The goal is to create a dashboard that allows you to visualize the time spent by each user in each subtask belonging to a specific epic.

Thanks a lot.

[Hannes Obweger - JXL for Jira]

Hi @chernandez

I'd probably start with a JQL query like: 

project = <project> AND parent = <parent-key> AND assignee = <assignee>

... where <parent-key> is the issue key of the epic that you're interested in.

Mind giving that a try? 

 Best,

Hannes

[Hannes Obweger - JXL for Jira]

Just to expand on the above: JQL is generally very powerful, so you should be able to perform most if not all of your searches.

If you're looking for a more intuitive way of searching and filtering, there's a number of apps available on the Atlassian Marketplace that can help with that. E.g., this is how your search (if I understand it correctly) would look like in the app that my team and I are working on, JXL for Jira:

For context, JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a long list of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know!

[chernandez]

Thanks for the response, the issue is that only epics are being displayed, not the subtasks. Users are loading time spent into the subtasks, so I need to see the time spent by epic and user, with each subtask associated and its time spent.