From 86d451a1427b866c526373036a84d99cccc06c98 Mon Sep 17 00:00:00 2001 From: Bradley Bonner Date: Mon, 15 Aug 2016 12:20:49 -0700 Subject: [PATCH] JBAS-1543, add Lucky Day to list of item circ modifiers and shelving locations that should not show in BC --- KCLS/utility-scripts/bc_missing/bc_missing.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/KCLS/utility-scripts/bc_missing/bc_missing.sql b/KCLS/utility-scripts/bc_missing/bc_missing.sql index 14a31f09f5..d09b597ae3 100644 --- a/KCLS/utility-scripts/bc_missing/bc_missing.sql +++ b/KCLS/utility-scripts/bc_missing/bc_missing.sql @@ -35,7 +35,7 @@ UPDATE asset.copy 'Children''s Storytime' , 'Children''s Toys/Games' , 'Children''s Materials' , 'Children''s Easy Materials' , 'KidReach' , 'Tech Lab' , 'Storage' , 'Teen Materials' , - 'Generic' , 'Normandy Park' , 'Choice Reads' + 'Generic' , 'Normandy Park' , 'Choice Reads', 'Lucky Day' ) ); @@ -57,14 +57,14 @@ UPDATE asset.copy AND asset.copy.call_number <> '-1' AND asset.copy.circ_modifier NOT IN ( '40', '41', '45', '46', '52', '1', '20', '23', - '24', '27', '33', '44', '56', '58', '66', '7') + '24', '27', '33', '44', '56', '58', '66', '7', '71') AND asset.copy_location.opac_visible = 't' AND string NOT IN ( 'Equipment' , 'Adult Paperbacks' , 'Adult Toys/Games' , 'Children''s Storytime' , 'Children''s Toys/Games' , 'Children''s Materials' , 'Children''s Easy Materials' , 'KidReach' , 'Tech Lab' , 'Storage' , 'Teen Materials' , - 'Generic' , 'Normandy Park' , 'Choice Reads' ) + 'Generic' , 'Normandy Park' , 'Choice Reads', 'Lucky Day' ) AND floating IS NULL ); -- 2.11.0