Worklog

[Adam Wojak]

Hi,

I'm using filter "project = XYZ AND worklogDate >= startOfMonth() AND worklogDate <= endOfMonth()" and jira pdf view plugin. When i'm trying to export timesheet raport in PDF it collects all worklogs in the issue, even if worklog was reported in previous months. Is it possible to get only worklog from certain month? preferably without any add-ons.

[Javi · Accepted solution]

Hi Adam,

From the Jira UI, there is currently not a way to export worklog data from a specific month without getting previous worklog months included.

However, you can pull the worklog data from the Jira database. All worklog data is stored in the "worklog" table and you can run a query similar to the following:

select * from worklog where startdate >= '2018-04-01' AND startdate <= '2018-04-30'

See: Worklog Table

You will have to associate the id to the jirasissue.id in order to determine the relation to the issue. 

If you do not wish to run queries on your database, you might be interested in checking out the Timesheet Reports and Gadgets as the plugin allows you to extract work log information. The following documentation provides steps on how to achieve this with the plugin: Timesheet Reports and Gadgets Documentation

Regards,
Javier A.

[Catherine Chang]

Hi there! I'm the PM on Jira Cloud for Google Sheets, and we're working to make this easy. Check out this post to see how you can import all of your worklog data into a spreadsheet with just a few clicks!