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 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
-- Zeno Tajoli System Librarian