Re: [Koha] Adding Quarantined Status to subfield 7

2021-06-12 Thread Katrin Fischer
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-return https://www.ptfs-europe.com/whats-on-our-mind-cart-to-shelf/ Hope this helps, Katrin On

[Koha] Adding Quarantined Status to subfield 7

2021-06-07 Thread Admire Mutsikiwa
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