Changeset 9460 for trunk/Open-ILS/src/sql/Pg/upgrade_simple_record.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/upgrade_simple_record.sql (modified) (1 diff)

trunk/Open-ILS/src/sql/Pg/upgrade_simple_record.sql

@@ -31 +31 @@
     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;