From e17591dbeecd9d2edec570420a726706ec2a94ce Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Wed, 22 Jan 2020 12:37:45 -0500 Subject: [PATCH] fixed column issue with a report --- mig-xml/evergreen_staged_report.xml | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml index 9eadb3a..38c2ef2 100644 --- a/mig-xml/evergreen_staged_report.xml +++ b/mig-xml/evergreen_staged_report.xml @@ -649,7 +649,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 Bibliographic Records Without Volumes And Recognized URI bibs 0 - Service, Domain, Count + Service.Domain.Count SELECT '3M','ebook.3m.com', COUNT(*) FROM subfield_u WHERE value ~* 'ebook.3m.com' GROUP BY 1, 2 UNION ALL SELECT 'Axis 360','axis360.baker-taylor.com', COUNT(*) FROM subfield_u WHERE value ~* 'axis360.baker-taylor.com' GROUP BY 1, 2 UNION ALL SELECT 'Book Flix','bookflix.digital.scholastic.com', COUNT(*) FROM subfield_u WHERE value ~* 'bookflix.digital.scholastic.com' GROUP BY 1, 2 UNION ALL @@ -666,7 +666,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 SELECT 'Overdrive','overdrive.com', COUNT(*) FROM subfield_u WHERE value ~* 'overdrive.com' GROUP BY 1, 2 UNION ALL SELECT 'ProQuest','ebookcentral.proquest.com', COUNT(*) FROM subfield_u WHERE value ~* 'ebookcentral.proquest.com' GROUP BY 1, 2 UNION ALL SELECT 'RB Digital','rbdigital.com', COUNT(*) FROM subfield_u WHERE value ~* 'rbdigital.com' GROUP BY 1, 2 UNION ALL - SELECT 'U.S. Government Sites','\.gov', COUNT(*) FROM subfield_u WHERE value ~* '\.gov' GROUP BY 1,2;; + SELECT 'U.S. Government Sites','.gov', COUNT(*) FROM subfield_u WHERE value ~* '\.gov' GROUP BY 1,2;; This list is built from known services and domains. If you have records for electronic resources that are not here please let us know. -- 1.7.2.5