[Koha] Change due date to all loans

[Zeno Tajoli]

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 at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Zeno Tajoli
System Librarian