From e7f5dd1ea74ad61ed4435c8cc201d497dd580c0d Mon Sep 17 00:00:00 2001
From: Rogan Hamby <rhamby@esilibrary.com>
Date: Tue, 10 Sep 2019 11:55:22 -0400
Subject: [PATCH] array to string search format values

---
 mig-xml/evergreen_staged_report.xml |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml
index 643af69..609e5c3 100644
--- a/mig-xml/evergreen_staged_report.xml
+++ b/mig-xml/evergreen_staged_report.xml
@@ -739,7 +739,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3</query>
 		<tag>bibs</tag>
 		<iteration>0</iteration>
 		<heading>Count.Original Search Format.New Search Format</heading>
-		<query>SELECT COUNT(*), x_search_format, x_after_search_format FROM biblio_record_entry_legacy WHERE x_migrate AND x_after_search_format IS NOT NULL GROUP BY 2, 3 ORDER BY 3,2</query>
+		<query>SELECT COUNT(*), ARRAY_TO_STRING(x_search_format,','), ARRAY_TO_STRING(x_after_search_format,',') FROM biblio_record_entry_legacy WHERE x_migrate AND x_after_search_format IS NOT NULL GROUP BY 2, 3 ORDER BY 3,2</query>
 	</report>
 
     <report>
-- 
1.7.2.5