How to get a list of users in a project and the tasks that the user is working on

Question

I'm trying to see a view for the current sprint:

User 1

User Story 1

Task

User Story 2

Task

User Story 3

Bug 1

User 2

User Story 4

User Story 5

Bug 2

Bug 3

User 3

User Story 6

User Story 7

User 4

User Story 8

User Story 9

Unassigned User Stories
   User Story 10

Is possible? I have been trying to create but without success.

Hannes Obweger - JXL for Jira · Answer

Hi @thiago.medeiros,

welcome to the community!

If you're open to solutions from the Atlassian Marketplace, you can achieve this very easily with JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing and inline-editing all your issue fields. It also allows your issues to be presented hierarchically, as well as to be grouped by any issue field.

This is how this would look in action:

Note that the above is just an example - you can easily configure your JXL sheet to match your exact needs, just like in Excel or Google Sheets.

Disclaimer: I work on JXL :)

Hope this helps,

Best,

Hannes | https://jxl.app

Trudy P Claspill · Answer

Jira does not natively support presenting search results in that type of ordering, where subtasks are grouped under their parent.

You can set the ordering for your filter thus:

ORDER BY Assignee DESC, key DESC

...to get the results order by Assigned user and then numerically by the issue key. Unassigned items would be at the bottom of the list. Subtasks will not be grouped under their parent issues, though. Jira just doesn't support that.

Alternately you could set up an agile board based on a saved filter for the scope of issues you want to view, then set the Swimlanes on the board to Assignee.