Changeset 9459

Show
Ignore:
Timestamp:
04/26/08 14:05:50 (2 months ago)
Author:
miker
Message:

allow deleted records to be visible

Location:
branches/rel_1_2/Open-ILS/src/sql/Pg
Files:
2 modified

Legend:

Unmodified
Added
Removed

  • branches/rel_1_2/Open-ILS/src/sql/Pg/reporter-schema.sql

    r9457 r9459  
    130130        LEFT JOIN metabib.full_rec series_statement ON (r.id = series_statement.record AND series_statement.tag = '490' AND series_statement.subfield = 'a') 
    131131        LEFT JOIN metabib.full_rec summary ON (r.id = summary.record AND summary.tag = '520' AND summary.subfield = 'a') 
    132   WHERE r.deleted IS FALSE 
    133132  GROUP BY 1,2,3,4,5,6,7,8,9,10,11,12,13,14; 
    134133 
    … …  
    152151        LEFT JOIN metabib.full_rec isbn ON (r.id = isbn.record AND isbn.tag IN ('024', '020') AND isbn.subfield IN ('a','z')) 
    153152        LEFT JOIN metabib.full_rec issn ON (r.id = issn.record AND issn.tag = '022' AND issn.subfield = 'a') 
    154   WHERE r.deleted IS FALSE 
    155153  GROUP BY 1,2,3,4,5,6,8,9; 
    156154 

  • branches/rel_1_2/Open-ILS/src/sql/Pg/upgrade_simple_record.sql

    r9457 r9459  
    3131    LEFT JOIN metabib.full_rec isbn ON (r.id = isbn.record AND isbn.tag IN ('024', '020') AND isbn.subfield IN ('a','z')) 
    3232    LEFT JOIN metabib.full_rec issn ON (r.id = issn.record AND issn.tag = '022' AND issn.subfield = 'a') 
    33   WHERE r.deleted IS FALSE 
    3433  GROUP BY 1,2,3,4,5,6,8,9; 
    3534