Adjusting time clock entries with sql commands?

(0) Share

Report

Posted on by Community Member

Is it possible to send SQL commands to SO to adjust a cashier time clock entries? If so what table would I need to be able to access time clock entries? Any direction would be greatly appreciated. I am using RMS 2.0155 SO and HQ 7 stores. I am looking to be able to setup a template sql command that would change and correct the wrong entries instead of giving Managers access to do it.

*This post is locked for comments

All responses (3)

Answers (0)

Timesheet 10 on at

Like (0)

Report

Re: Adjusting time clock entries with sql commands?

BTW, which time clock are you talking about? Is it legal to edit the timesheet settings of a third party software without rights?

I wouldn't try doing it to any software, moreover the time clock that we use gives all facilities to the users atleast in the admin access.
Community Member on at

Like (0)

Report

Re: Adjusting time clock entries with sql commands?

update timeclock set TimeOut = '11/22/2008 4:04:47' where id = '16'

This updates the SO database. As I am finding out there would be a lot a queries to find the exact record you need to adjust and maybe use a method of loging in remotely to change might be the better option for time saving. updating Hq might be the missing component.
Community Member on at

Like (0)

Report

Re: Adjusting time clock entries with sql commands?

Ok Timeclock is the table.

select * from timeclock where cashierID = '5' and TimeIn = '11/17/2008 9:08:43 AM'

I was trying to use the command to select the record I needed and it returns 0 rows. Is there something wrong with the syntax? No errors when I run it.