How may I create a simple report/list of all Logged Issues, whether open, closed, in progress, etc..

[Gary Wells]

Good Day

How may I create a simple, downloadable report/list of all Logged Issues, whether open, closed, in progress, etc..

This used to be simple and straightforward. 

What are we doing wrong?

Many Thanks, with Regards

[Valerie Knapp]

Hi @Gary Wells , welcome to the Atlassian Community and thanks for your post.

When you say 'logged issues', do you mean with hours worked? or do you just want a list of all of the work items in your site?

To see all work items, you should be able to do this 

Then you just switch off this filter to see all of the work items in your site

If you want to see work items where there is time logged, you can use this JQL

timespent IS NOT EMPTY

I hope this helps you but if it doesn't or you have more questions, please write and let us know.

Cheers

[Jack Brickey]

Hi @Gary Wells , you can create a JQL filter and save it. You can also set up a subscription to send the report results out regularly to desired users.

here is an example JQL...

project = xxx

the above will return all issues for project "xxx". Replace "xxx" with you desired project key.

if you want you can export the results to Excel/Sheets/CSV. You can also use the official Excel/Sheets extension to accomplish this. Check the Atlassian marketplace for the free extension.

[Mario GELES]

Hi @Gary Wells ,

I think the best thing to do is creating a filter with the right JQL request and saving it then you will able to export it in CSV via the export button on top of the filter page. 

If you are struggling with the JQL request let me know what your request is and what you exactly want it to list and I'll try to help you with this.

Best Regards 

Mario

[Mary from Planyway]

Hi @Gary Wells 

Here is a quick interactive demo. Hope it'll help

[Hannes Obweger - JXL for Jira]

Hi @Gary Wells,

welcome to the community! 

Just to add to the great answers above: If you're open to solutions from the Atlassian Marketplace, you have a few options available that really push the bar in terms of simplicity and user-friendliness.

E.g., you may want to have a look at the app that my team and I are working on: JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your work items (issues) that allows viewing, inline-editing, sorting, and filtering by all your work item fields, much like you’d do in e.g. Excel, Google Sheets, Smartsheet, or Airtable. Of course, you can export your table to Excel or CSV in just two clicks.

This is how it looks in action:

I should add that JXL can do much more than the above: From support for configurable issue hierarchies, to issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes