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