From 7dedc7896ff65385723093e72aeca144a9ae4f6e Mon Sep 17 00:00:00 2001 From: Thomas Berezansky Date: Fri, 15 Jul 2011 15:54:35 -0400 Subject: [PATCH] Fix part holds in reporter.hold_request_record Specifically, make them show a bib id, instead of null. Signed-off-by: Thomas Berezansky Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/reporter-schema.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/Open-ILS/src/sql/Pg/reporter-schema.sql b/Open-ILS/src/sql/Pg/reporter-schema.sql index 85b5c54457..25532b6e03 100644 --- a/Open-ILS/src/sql/Pg/reporter-schema.sql +++ b/Open-ILS/src/sql/Pg/reporter-schema.sql @@ -266,6 +266,8 @@ SELECT id, THEN (SELECT cn.record FROM asset.call_number cn JOIN asset.copy cp ON (cn.id = cp.call_number) WHERE cp.id = ahr.target) WHEN hold_type = 'M' THEN (SELECT mr.master_record FROM metabib.metarecord mr WHERE mr.id = ahr.target) + WHEN hold_type = 'P' + THEN (SELECT bmp.record FROM biblio.monograph_part bmp WHERE bmp.id = ahr.target) END AS bib_record FROM action.hold_request ahr; -- 2.11.0