Hi, there are several ways to achieve this without using SQL directly. Here are some links that might be helpful: https://bywatersolutions.com/education/set-items-to-quarantine-status-upon-r... https://www.ptfs-europe.com/whats-on-our-mind-cart-to-shelf/ Hope this helps, Katrin On 07.06.21 15:28, Admire Mutsikiwa wrote:
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, _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha