How to get weekly work log hours datewise?

Muskan Shaikh

I want report or JQL which gives the list of subtasks having work log updated in between particular date span. so once date span is defined in jql then only work log updated in date span will be listed down,

i get everything which is updated in particular date span...but i just want work logs updated for particular date span

Earl McCutcheon

Hello @Muskan Shaikh ,

To get a list of subtasks where the worklog was updated during a speciffic date range you could look at the " worklogDate" using either a "startOfWeek()" and "endOfWeek()" for a single week or specify a date range function like the following:

project = example and issuetype = subtask and worklogDate >= startOfWeek() and worklogdate <= endOfWeek()

 OR

project = example and issuetype = subtask and worklogDate >= "YYYY/MM/DD" and worklogdate <= "YYYY/MM/DD"

Note on the documentation for this JQL:

Details in the Cloud version documentation on the worklogDate were recently overwritten  by mistake, and we are working on updating the docs to get the info added back in correctly via This Documentation BUG Report , In the mean time while the Cloud docs are being fixed the details on this field referance can be seen in the Server Version of the documentation at the following link and in this case the Cloud functionality will be the same for this JQL in Cloud and Server:

• https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-fields-reference-939938743.html#Advancedsearching-fieldsreference-WorkLogDateworklogDateWorklogdate

Regards,
Earl