From 44a7456a58bebd608ceb64b6e316bbdeefccc0f8 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 26 Oct 2017 12:24:33 -0400 Subject: [PATCH] LP#1727487 Display field seed data WIP Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/upgrade/XXXX.data.display-field-seed-data.sql | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.display-field-seed-data.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.display-field-seed-data.sql index 1c5c11bfdb..ea55482eb8 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.display-field-seed-data.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.display-field-seed-data.sql @@ -196,13 +196,15 @@ COMMIT; \qecho \qecho SELECT metabib.reingest_metabib_field_entries(id, TRUE, FALSE, TRUE, TRUE, \qecho (SELECT ARRAY_AGG(id)::INT[] FROM config.metabib_field WHERE display_field)) -\qecho FROM biblio.record_entry WHERE NOT deleted AND id > 0; +\qecho FROM biblio.record_entry WHERE id > 0; \qecho -- avoid displaying a row per entry by selecting the total count. +-- NOTE: extracting display data for deleted bibs because we occasionally +-- display deleted bib records. SELECT COUNT(*) AS bib_count FROM ( SELECT metabib.reingest_metabib_field_entries(id, TRUE, FALSE, TRUE, TRUE, (SELECT ARRAY_AGG(id)::INT[] FROM config.metabib_field WHERE display_field)) - FROM biblio.record_entry WHERE NOT deleted AND id > 0 + FROM biblio.record_entry WHERE id > 0 ) x; -- 2.11.0