LP1071505 - Add 264 RDA tag to reporter views
authorBen Shum <bshum@biblio.org>
Thu, 31 Jan 2013 17:20:20 +0000 (12:20 -0500)
committerLebbeous Fogle-Weekley <lebbeous@esilibrary.com>
Thu, 16 May 2013 15:24:08 +0000 (11:24 -0400)
commit1b7a2d1d14838f2a196d09cb1fa2bbcdbc044b03
treee6ae2b593d0f104e2cecf54056b1f51c9bb2b297
parentb610f9ab1ae0b14c2927a27e5537a8ce9eecb755
LP1071505 - Add 264 RDA tag to reporter views

Some reports draw from reporter.materialized_simple_record table and these
were not made aware of the new 264 tag which contains publisher related
information.

Change the view for reporter.old_super_simple_record, which feeds into the
other reporter table.

The included upgrade SQL will update this view and then update the table using
the new view.

Signed-off-by: Ben Shum <bshum@biblio.org>
Signed-off-by: Dan Wells <dbw2@calvin.edu>
Signed-off-by: Lebbeous Fogle-Weekley <lebbeous@esilibrary.com>
Open-ILS/src/sql/Pg/reporter-schema.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.reporter_264_pubinfo.sql [new file with mode: 0644]