1 -- Evergreen DB patch 0565.schema.action-trigger.event_definition.hold-cancel-no-target-notification.sql
3 -- New action trigger event definition: Hold Cancelled (No Target) Email Notification
7 -- check whether patch can be applied
8 SELECT evergreen.upgrade_deps_block_check('0565', :eg_version);
10 INSERT INTO action_trigger.event_definition (id, active, owner, name, hook, validator, reactor, delay, delay_field, group_field, template)
12 'Hold Cancelled (No Target) Email Notification',
13 'hold_request.cancel.expire_no_target',
14 'HoldIsCancelled', 'SendEmail', '30 minutes', 'cancel_time', 'usr',
17 [%- user = target.0.usr -%]
18 To: [%- params.recipient_email || user.email %]
19 From: [%- params.sender_email || default_sender %]
20 Subject: Hold Request Cancelled
22 Dear [% user.family_name %], [% user.first_given_name %]
23 The following holds were cancelled because no items were found to fullfil the hold.
25 [% FOR hold IN target %]
26 Title: [% hold.bib_rec.bib_record.simple_record.title %]
27 Author: [% hold.bib_rec.bib_record.simple_record.author %]
28 Library: [% hold.pickup_lib.name %]
29 Request Date: [% date.format(helpers.format_date(hold.rrequest_time), '%Y-%m-%d') %]
34 INSERT INTO action_trigger.environment (event_def, path) VALUES
37 (38, 'bib_rec.bib_record.simple_record');