What filter or set of filters can I use to automate a weekly contract report using the work log?

[Daniel Moler]

I need to determine how to automate a contract Weekly report. Found out that I can pull stories and tasks per sprint then pull the sub-tasks associated to each story/task. What about pulling the work log comments per user on a weekly basis?

[Javi]

Hi Daniel,

Natively in Jira, there is not a great way of extracting this information. However, you could pull all issues that have a work log entry from the beginning of the week.

Ex:

worklogDate >= startOfWeek() 

When exporting the results, you can see who made the work log comment and the timestamp under the Log Work field. 

If you want a more structured view, I recommend querying the database and using a query such as the following:

select author, created, worklogbody FROM worklog WHERE created >= '2018-05-14' ORDER BY author ASC 

This will pull all work logs after the specified date, which in my example I use May 14, 2018. Additionally, it will order by the author that made the work log comment. 

See: JRASERVER-7553

Regards,
Javier A.