1 -- add missing behind_desk column
3 \qecho *** This ALTER TABLE might fail depending on your DB vintage. ***
4 \qecho *** It should be harmless. ***
5 ALTER TABLE action.aged_hold_request ADD COLUMN behind_desk BOOLEAN;
9 SELECT evergreen.upgrade_deps_block_check('0868', :eg_version);
11 CREATE OR REPLACE VIEW action.all_hold_request AS
13 COALESCE(a.post_code, b.post_code) AS usr_post_code,
14 p.home_ou AS usr_home_ou,
15 p.profile AS usr_profile,
16 EXTRACT(YEAR FROM p.dob)::INT AS usr_birth_year,
17 CAST(ahr.requestor <> ahr.usr AS BOOLEAN) AS staff_placed,
31 ahr.fulfillment_staff,
40 WHEN ahr.phone_notify IS NULL THEN FALSE
41 WHEN ahr.phone_notify = '' THEN FALSE
46 WHEN ahr.sms_notify IS NULL THEN FALSE
47 WHEN ahr.sms_notify = '' THEN FALSE
55 ahr.shelf_expire_time,
56 ahr.current_shelf_lib,
58 FROM action.hold_request ahr
59 JOIN actor.usr p ON (ahr.usr = p.id)
60 LEFT JOIN actor.usr_address a ON (p.mailing_address = a.id)
61 LEFT JOIN actor.usr_address b ON (p.billing_address = b.id)
101 FROM action.aged_hold_request;
105 CREATE OR REPLACE FUNCTION action.age_hold_on_delete () RETURNS TRIGGER AS $$
108 -- Archive a copy of the old row to action.aged_hold_request
110 INSERT INTO action.aged_hold_request
186 FROM action.all_hold_request WHERE id = OLD.id;
190 $$ LANGUAGE 'plpgsql';