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 = date.manip -%]
[%- date_prev = manip.DateCalc( hold.expirationdate, '1 day ago' ) -%]
[%- formatted_date_prev = manip.UnixDate(date_prev,"%m/%d/%Y") -%]
Pick up hold on or before: [% formatted_date_prev %]
Hope this helps,
Katrin
On 07.12.22 12:06, Tomas Cohen Arazi wrote:
Are you sure the MySQL syntax for dates works on Template::Toolkit?
El mié, 7 dic 2022 5:59, Raymund Delahunty<r.delahu...@arts.ac.uk>
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 expires the previous day:
[% IF borrower.dateexpiry = DATE_SUB(CURDATE(), INTERVAL 1 DAY) %]
That didn't work either- no ODUE sent at all, so I am giving up on the TT
for now.
-----Original Message-----
From: Koha<koha-boun...@lists.katipo.co.nz> On Behalf Of Raymund
Delahunty
Sent: 06 December 2022 08:07
To: Thomas Klausner<d...@plix.at>;koha@lists.katipo.co.nz
Subject: Re: [Koha] Template toolkit puzzle 1.
Thanks Domm, for pointing out the typo, but that typo was only in the
email sent to the list. I have rerun two tests using two ‘bracketed’
versions and have received different results.
[% IF borrower.dateexpiry == CURDATE() %] [% IF (borrower.dateexpiry =
CURDATE() ) %] The first version triggered the use of the second optional
wording wrongly, while the second version triggered the use of the first
wording wrongly. I have no idea what’s going on and might as well give up
on the TT code testing, which is very disappointing as I had high hopes for
improving our notices with the TT. (And especially if I could make it stop
sending notices in specific defined situations).
Ray Delahunty
University of the Arts London
.
-----Original Message-----
From: Koha<koha-boun...@lists.katipo.co.nz> On Behalf Of Thomas Klausner
Sent: 02 December 2022 06:57
To:koha@lists.katipo.co.nz
Subject: Re: [Koha] Template toolkit puzzle 1.
Hi!
On Fri, Dec 02, 2022 at 06:31:31AM +0000, Raymund Delahunty wrote:
But when I try to use a TT rule in the ODUE message, no email is sent at
all- there appears to be an error:
[% IF (borrower.dateexpiry == CURDATE() %]
Hot sure how much pseudocode this is, but you're missing a closing
parenthesis after CURDATE():
[% IF (borrower.dateexpiry == CURDATE() ** ) ** %]
Greetings,
domm
--
#!/usr/bin/perlhttps://domm.plix.at
for(ref bless{},just'another'perl'hacker){s-:+-$"-g&&print$_.$/}
_______________________________________________
Koha mailing listhttp://koha-community.org Koha@lists.katipo.co.nz
Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
This email and any attachments are intended solely for the addressee and
may contain confidential information. If you are not the intended recipient
of this email and/or its attachments you must not take any action based
upon them and you must not copy or show them to anyone. Please send the
email back to us and immediately and permanently delete it and its
attachments. Where this email is unrelated to the business of University of
the Arts London or of any of its group companies the opinions expressed in
it are the opinions of the sender and do not necessarily constitute those
of University of the Arts London (or the relevant group company). Where the
sender's signature indicates that the email is sent on behalf of UAL Short
Courses Limited the following also applies: UAL Short Courses Limited is a
company registered in England and Wales under company number 02361261.
Registered Office: University of the Arts London, 272 High Holborn, London
WC1V 7EY _______________________________________________
Koha mailing listhttp://koha-community.org Koha@lists.katipo.co.nz
Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
This email and any attachments are intended solely for the addressee and
may contain confidential information. If you are not the intended recipient
of this email and/or its attachments you must not take any action based
upon them and you must not copy or show them to anyone. Please send the
email back to us and immediately and permanently delete it and its
attachments. Where this email is unrelated to the business of University of
the Arts London or of any of its group companies the opinions expressed in
it are the opinions of the sender and do not necessarily constitute those
of University of the Arts London (or the relevant group company). Where the
sender's signature indicates that the email is sent on behalf of UAL Short
Courses Limited the following also applies: UAL Short Courses Limited is a
company registered in England and Wales under company number 02361261.
Registered Office: University of the Arts London, 272 High Holborn, London
WC1V 7EY
_______________________________________________
Koha mailing listhttp://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing listhttp://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
