From 071ca406ba4806b9be9abf3565b685e6c17efbc1 Mon Sep 17 00:00:00 2001
From: Bill Erickson <berickxx@gmail.com>
Date: Thu, 11 May 2017 12:14:10 -0400
Subject: [PATCH] LP#1251394 flat_display_entry gets 'field' col

Signed-off-by: Bill Erickson <berickxx@gmail.com>
Signed-off-by: Mike Rylander <mrylander@gmail.com>
---
 Open-ILS/examples/fm_IDL.xml                                  | 4 +++-
 .../src/sql/Pg/upgrade/XXXX.schema.metabib-display-field.sql  | 3 ++-
 2 files changed, 5 insertions(+), 2 deletions(-)

diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml
index dc283f0aa9..3a09f05da6 100644
--- a/Open-ILS/examples/fm_IDL.xml
+++ b/Open-ILS/examples/fm_IDL.xml
@@ -3748,11 +3748,13 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA
 		oils_persist:readonly="true">
 		<fields>
 			<field name="source" reporter:datatype="id" />
-			<field name="value" reporter:datatype="text"/>
 			<field name="name" reporter:datatype="text"/>
+			<field name="field" reporter:datatype="link"/>
+			<field name="value" reporter:datatype="text"/>
 		</fields>
 		<links>
 			<link field="source" reltype="has_a" key="id" map="" class="bre"/>
+			<link field="field" reltype="has_a" key="id" map="" class="cmf"/>
 			<link field="name" reltype="has_a" key="name" map="" class="cdfm"/>
 		</links>
     <permacrud xmlns="http://open-ils.org/spec/opensrf/IDL/permacrud/v1">
diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.metabib-display-field.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.metabib-display-field.sql
index 6066bbad71..2d69e817ad 100644
--- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.metabib-display-field.sql
+++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.metabib-display-field.sql
@@ -22,6 +22,7 @@ CREATE VIEW metabib.flat_display_entry AS
     SELECT
         mde.source,
         cdfm.name,
+        mde.field,
         CASE WHEN cdfm.multi THEN
             TO_JSON(ARRAY_AGG(value))
         ELSE
@@ -29,7 +30,7 @@ CREATE VIEW metabib.flat_display_entry AS
         END AS value
     FROM metabib.display_entry mde
     JOIN config.display_field_map cdfm ON (cdfm.field = mde.field)
-    GROUP BY 1, 2;
+    GROUP BY 1, 2, 3;
 
 CREATE INDEX metabib_display_entry_field_idx 
     ON metabib.display_entry (field);
-- 
2.43.2