we want to use Tempo for Time Tracking which will be used for each employee as a covenant time table for our payroll accounting.
We are bond to keep tracks of time like
08:00-10:30 Installed tempo Plugin
10:30-12:00 Tested Configuration.
At least it should state something like
But it is possible for me to enter something like this:
08:00 worked 8h
13:00 worked 5h
A similar request is in our tracker https://studio.plugins.atlassian.com/browse/JTMPO-511
I ve commented a link to this post in the issue so please feel free to vote/comment on the issue.
Maybe a helpfull SQL for MySQL-DB
select w.AUTHOR, i.pkey, w.STARTDATE, ADDDATE(w.STARTDATE, INTERVAL w.timeworked/60 MINUTE) as ENDDATE , w.timeworked/60 as WORKED_IN_MIN, w.worklogbody , case when w.startdate = ww.startdate and w.timeworked= ww.timeworked and w.worklogbody = ww.worklogbody then 'duplicate entry' when w.startdate = ww.startdate and w.timeworked= ww.timeworked then 'duplicate time entry' when ww.startdate = w.startdate then 'duplicate STARTDATE' when ww.startdate > w.startdate and ww.startdate < w.startdate then 'second time completely included' else 'overlap' end as INFO , ii.pkey, ww.STARTDATE, ADDDATE(ww.STARTDATE, INTERVAL ww.timeworked/60 MINUTE) as ENDDATE , ww.timeworked/60 as WORKED_IN_MIN, ww.worklogbody from worklog w inner join jiraissue i on i.id = w.issueid inner join worklog ww on w.id <> ww.id and w.AUTHOR = ww.AUTHOR and ww.STARTDATE >= w.STARTDATE and ww.STARTDATE < ADDDATE(w.STARTDATE, INTERVAL w.timeworked/60 MINUTE) inner join jiraissue ii on ii.id = ww.issueid order by w.AUTHOR, w.STARTDATE, i.pkey, ww.STARTDATE
Hey Atlassian community, I help lead engineering at Sentry, an open-source error-tracking and monitoring tool that integrates with Jira. We started using Jira Software Cloud internally last year, a...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG