Re: [Koha] Change due date to all loans

Hi Katrin and all, thank you for the answer. I miss the new tool !! Cheers Zeno Tajoli Il 05/05/2021 12:48, Katrin Fischer ha scritto: 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

Re: [Koha] Change due date to all loans

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

[Koha] Change due date to all loans

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