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

Question

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.

chernandez_qw2lk9 · Answer

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.

Hannes Obweger - JXL for Jira · Answer

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!

Hannes Obweger - JXL for Jira · Answer

Hi @chernandez I'd probably start with a JQL query like: project = AND parent = AND assignee = ... where is the issue key of the epic that you're interested in. Mind giving that a try? Best, Hannes