Hi Zeno, did you see that there is a new tool available for batch extending due dates within Koha?
The tool will also update items.onloan and issues.date_due, so your SQL should be ok. I'd only be careful updating overdue items with fines on them. If you update those, you'd probably have to make changes to the fines as well (F vs. FU etc.). Hope this helps, Katrin On 04.05.21 00:45, Zeno Tajoli wrote:
Hi to all, I want to check an SQL instrution to change due date of all loan. The idea is to set all due dato to 04 Nov 2021. SQL: UPDATE issues a INNER JOIN items b ON (a.itemnumber = b.itemnumber) INNER JOIN borrowers c ON (a.borrowernumber = c.borrowernumber) SET a.date_due='2021-11-04 23:59:59', b.onloan ='2021-11-04' In fact it changes only values into issues.date_due and items.onloan I don't have records inside reserves Do you think it is enough ? I don't want to send email to borrowers for late loans. I take the code from ChangeDueDate.kpz of inLibro Bye Zeno Tajoli Ps: I take SQL from
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
