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 -- Zeno Tajoli System Librarian _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
