From fc9be0650aa7d801c6d3fe72461993e45ab1e619 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Mon, 28 Aug 2017 13:11:29 -0400 Subject: [PATCH] LP#1668734: set max_delay, similar to stock courtesy email notice Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 4 ++-- ...XXX.data.action-trigger.event_definition.sms_preminder.sql | 4 ++-- 2 files changed, 4 insertions(+), 4 deletions(-) diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql index a3fa96eaef..a5e32fe582 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -14724,11 +14724,11 @@ SELECT SETVAL('vandelay.merge_profile_id_seq'::TEXT, 100); -- 3 Day Courtesy Notice by SMS INSERT INTO action_trigger.event_definition (id, active, owner, name, hook, - validator, reactor, delay, delay_field, group_field, template) + validator, reactor, delay, max_delay, delay_field, group_field, template) VALUES (54, FALSE, 1, '3 Day Courtesy Notice by SMS', 'checkout.due', - 'CircIsOpen', 'SendSMS', '-3 days', 'due_date', 'usr', + 'CircIsOpen', 'SendSMS', '-3 days', '-2 days', 'due_date', 'usr', $$ [%- USE date -%] [%- user = target.0.usr -%] diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.action-trigger.event_definition.sms_preminder.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.action-trigger.event_definition.sms_preminder.sql index f404f1e7c5..d897452f16 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.action-trigger.event_definition.sms_preminder.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.action-trigger.event_definition.sms_preminder.sql @@ -8,11 +8,11 @@ BEGIN; SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); INSERT INTO action_trigger.event_definition (id, active, owner, name, hook, - validator, reactor, delay, delay_field, group_field, template) + validator, reactor, delay, max_delay, delay_field, group_field, template) VALUES (54, FALSE, 1, '3 Day Courtesy Notice by SMS', 'checkout.due', - 'CircIsOpen', 'SendSMS', '-3 days', 'due_date', 'usr', + 'CircIsOpen', 'SendSMS', '-3 days', '-2 days', 'due_date', 'usr', $$ [%- USE date -%] [%- user = target.0.usr -%] -- 2.43.2