7 Jun
2021
7 Jun
'21
3:28 p.m.
Good day. In the COVID-19 environment, our checked-in items are to be quarantined for 3 days. I would like to have an SQL UPDATE statement that enables me to update subfied 7 on item check-in to quarantine (e.g number 4, for augment sake) on check-in and after three days, through a cronjob, change the status to 0 ( for available). Kind Regards,