How can I fetch automated weekly Worklog Reports for my Team ?

[Rohan Singh]

At the end of every week, I would like to pull out a work log report for everyone working in my team. If the total logged hours is say for example less than 40 hours, I would like to send them a reminder to update work log.

Can I automate this process?

[Martin Bayer [MoroSystems, s.r.o.]]

Hi @Rohan Singh do you use any 3rd party App on you Jira instance to log work or you use only built-in Log work function?

[Rohan Singh]

I am using the app Timetracking for Jira @Martin Bayer [MoroSystems, s.r.o.] 

[Martin Bayer [MoroSystems, s.r.o.]]

CAn you send me the link to the App on marketplace? There are so many apps with similar name...

[Rohan Singh]

https://marketplace.atlassian.com/apps/1216988/timesheet-tracking-for-jira?hosting=cloud&tab=overview

[Rohan Singh]

@Martin Bayer [MoroSystems, s.r.o.] 

[Martin Bayer [MoroSystems, s.r.o.]]

Hi @Rohan Singh I just checked the documentation and it does not have REST API documented. Can you ask vendor of the App if they have any public REST API available to load the data? You can contact the vendor on email touchdownatlassian@gmail.com (https://marketplace.atlassian.com/apps/1216988/timesheet-tracking-for-jira?hosting=cloud&tab=support).

[Milan Chheda]

Hi @Rohan Singh ,

I am in a similar boat and would like to know if you were able to achieve this.

Thanks,
Milan

[Martin Bayer [MoroSystems, s.r.o.]]

Hi @Rohan Singh @Milan Chheda are you technically skilled? ONe solution came to my mind but there is no "tutorial" or "boxed" solution for it.

But in case you are technically skilled, I can provide you one hint. Apps for Jira are quite often reactive apps which use REST API for getting data. So when you are on the dashboard with the timesheets and press "Search" button, you can see, in the dev console, that request is sent to the server

https://jira-timesheets-cloud.herokuapp.com/search

it also send some Json as the body, for example

{"jql":"worklogAuthor = 557058:91762449-f0d5-4494-9dbd-9369931e419f AND worklogDate >= 2022-09-01 AND worklogDate <= 2022-09-30 order by created DESC","fields":["parent","resolution","priority","labels","assignee","status","reporter","progress","worklog","issuetype","timespent","project","summary","customfield_10014","customfield_10020"],"sprintCustomFieldId":"customfield_10020","groupEpics":true}

You can see that "jql" contains "worklogAuthor" so you can get the data for any user if you have permission to view this worklogs.