From 7a8c638023b67d5289332c52aab6a85630c804f0 Mon Sep 17 00:00:00 2001 From: miker Date: Sat, 26 Apr 2008 18:05:58 +0000 Subject: [PATCH] allow deleted records to be visible git-svn-id: svn://svn.open-ils.org/ILS/trunk@9460 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/reporter-schema.sql | 2 -- Open-ILS/src/sql/Pg/upgrade_simple_record.sql | 1 - 2 files changed, 3 deletions(-) diff --git a/Open-ILS/src/sql/Pg/reporter-schema.sql b/Open-ILS/src/sql/Pg/reporter-schema.sql index d7f63326a2..79e2eeeef8 100644 --- a/Open-ILS/src/sql/Pg/reporter-schema.sql +++ b/Open-ILS/src/sql/Pg/reporter-schema.sql @@ -129,7 +129,6 @@ SELECT r.id, LEFT JOIN metabib.full_rec series_title ON (r.id = series_title.record AND series_title.tag IN ('830','440') AND series_title.subfield = 'a') LEFT JOIN metabib.full_rec series_statement ON (r.id = series_statement.record AND series_statement.tag = '490' AND series_statement.subfield = 'a') LEFT JOIN metabib.full_rec summary ON (r.id = summary.record AND summary.tag = '520' AND summary.subfield = 'a') - WHERE r.deleted IS FALSE GROUP BY 1,2,3,4,5,6,7,8,9,10,11,12,13,14; CREATE OR REPLACE VIEW reporter.old_super_simple_record AS @@ -151,7 +150,6 @@ SELECT r.id, LEFT JOIN metabib.full_rec pubdate ON (r.id = pubdate.record AND pubdate.tag = '260' AND pubdate.subfield = 'c') LEFT JOIN metabib.full_rec isbn ON (r.id = isbn.record AND isbn.tag IN ('024', '020') AND isbn.subfield IN ('a','z')) LEFT JOIN metabib.full_rec issn ON (r.id = issn.record AND issn.tag = '022' AND issn.subfield = 'a') - WHERE r.deleted IS FALSE GROUP BY 1,2,3,4,5,6,8,9; CREATE TABLE reporter.materialized_simple_record AS SELECT * FROM reporter.old_super_simple_record WHERE 1=0; diff --git a/Open-ILS/src/sql/Pg/upgrade_simple_record.sql b/Open-ILS/src/sql/Pg/upgrade_simple_record.sql index b0ceb3c7b4..8588929d1d 100644 --- a/Open-ILS/src/sql/Pg/upgrade_simple_record.sql +++ b/Open-ILS/src/sql/Pg/upgrade_simple_record.sql @@ -30,7 +30,6 @@ SELECT r.id, LEFT JOIN metabib.full_rec pubdate ON (r.id = pubdate.record AND pubdate.tag = '260' AND pubdate.subfield = 'c') LEFT JOIN metabib.full_rec isbn ON (r.id = isbn.record AND isbn.tag IN ('024', '020') AND isbn.subfield IN ('a','z')) LEFT JOIN metabib.full_rec issn ON (r.id = issn.record AND issn.tag = '022' AND issn.subfield = 'a') - WHERE r.deleted IS FALSE GROUP BY 1,2,3,4,5,6,8,9; CREATE OR REPLACE FUNCTION reporter.simple_rec_sync () RETURNS TRIGGER AS $$ -- 2.43.2