[Koha] Change due date to all loans

[Katrin Fischer]

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