Re: [Koha] Template toolkit puzzle 1.

Hi Raymund, I think Tomas is right, you are using SQL, but we need something more TT/Perl. I found a nice example on the wiki that could do the trick: https://wiki.koha-community.org/wiki/Notices_and_Slips_Library#Manipulating_Dates_in_Notices_using_Template_Toolkit [%- USE date -%] [%- manip

Re: [Koha] Batch update of bib records - non-public note

Hi, Ravi-- > I would like to add unique note (note would be different to many records) > to all the bibliographic records of Koha in non-public note field - 952x. Would the Batch Item Modification tool be easier for what you have in mind? Since the 952x is an item record field, I usually use th

Re: [Koha] Template toolkit puzzle 1.

Are you sure the MySQL syntax for dates works on Template::Toolkit? El mié, 7 dic 2022 5:59, Raymund Delahunty escribió: > I had one last crack at this, as I realised I should be looking for users > whose datexpiry is **yesterday**, when preparing the ODUE email at 1am > after the account expire

Re: [Koha] Template toolkit puzzle 1.

I had one last crack at this, as I realised I should be looking for users whose datexpiry is **yesterday**, when preparing the ODUE email at 1am after the account expires the previous day: [% IF borrower.dateexpiry = DATE_SUB(CURDATE(), INTERVAL 1 DAY) %] That didn't work either- no ODUE sent at