unclear specification for worklogDate JQL field

[Tyler C]

The worklogDate JQL field specification here is slightly unclear. does it query the worklog 'started' property, or the worklog 'created' property? If it is the former, is there some other JQL query we can use to search for the latter? 

[Bill Sheboy · Accepted solution]

Hi @Tyler C -- Welcome to the Atlassian Community!

With the built-in JQL, I believe that is the "started" date / time.  That is, when the work was logged as "happening".

To search by more criteria, I believe you will need either a marketplace addon / app or to call the REST API function, providing UNIX Timestamps for the search date / time values: https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-worklogs/#api-rest-api-3-issue-issueidorkey-worklog-get  If you want to experiment, try calling that function with a browser and use an online converter to get the timestamp values.

Kind regards,
Bill

[Tyler C]

Thanks Bill, do you know if that would have any performance impact versus the JQL query? we are using the python jira-api client at the moment.

[Bill Sheboy]

I do not know, and it would probably depend upon your usage scenario.  How do you plan to query for worklog data?

I suspect calling it for a single / few issues is no problem.  You can call it from a browser or Postman if you want to try it and gather data on performance.