array to string search format values

diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml
index 643af69..609e5c3 100644 (file)
--- 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>