Changeset 9460 for trunk/Open-ILS/src/sql/Pg/reporter-schema.sql

Timestamp:

04/26/08 14:05:58 (2 months ago)

Author:

miker

Message:

allow deleted records to be visible

Files:

• trunk/Open-ILS/src/sql/Pg/reporter-schema.sql (modified) (2 diffs)

trunk/Open-ILS/src/sql/Pg/reporter-schema.sql

@@ -130 +130 @@
         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;
 
@@ -152 +151 @@
         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;