How to create a report in Jira of all the hours I've worked in a week

Question

We use Jira ( plain jira, no greenhopper ) for project/task management and a separate system for time tracking.

How can I run a report to extract all the hours I have worked in the last week?

Answer 1

You can create a custom filter with a custom search query:

project = "My project" and timeSpent is not null and updated > startOfWeek("-1") and assignee was CurrentUser()

More information on JQL is here - https://confluence.atlassian.com/display/JIRA/Advanced+Searching#AdvancedSearching-Updated

Answer 2

Work already completed

One way would be to install the timesheet plugin which generates a tablular breakdown of time logged against projects, tasks and lets you export the information in Excel.

I've install the plugin quickly to get an idea of how well it works;

I think this is what you're looking for when producing retrospective time data.

Remaining Work

You can make use of the User Workload report which..

displays useful time tracking information on issues assigned to a particular user. It shows the number of unresolved issues assigned to the specified user, and the workload remaining, on a per-project basis.

To create a report, you need to view (any) Project page, then select "User Workload Report" from the "Reports" link on the top right of the Summary screen. The JIRA Documentation has more instructions.

As an example, the report generated for myself is as follows;

Answer 3

You can also try our plugin Intelligent Reports. It lets you design the output format you want in Microsoft Word, and fill in the data using simple point and click rules, which allow you to filter, sort, etc. on all attributes of logged time.

It even comes with two timesheet example reports, a project timesheet and a cross-project timesheet. These should be easily adaptable to what you need.

As a quick note, JQL alone cannot filter logged time data completely, as it only returns issues. For instance, in the query given in the other answer, it will miss any work you may have logged against an issue that is assigned to someone else. Intelligent Reports lets you start with a JQL query, but further refine it using the attributes of the logged time directly.

Answer 4

You can use "JIRA Timesheet Reports and Gadget" for that, it generates beautifully structured report with wide range of configuration options. It costs money, BUT it's only for extra functionality like "Working Days" or "Subscriptions". Main timesheet report functionality is free. It's preinstalled for OnDemand or you can install it for your hosted instance. You can use it without a licence as I described.