From 48e0d13bbcb664805dbc76eeb3ac7eab380c1099 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Wed, 29 May 2019 08:29:05 -0400 Subject: [PATCH] adding user setting report --- mig-xml/evergreen_staged_report.xml | 11 +++++++++++ 1 files changed, 11 insertions(+), 0 deletions(-) diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml index ecdc30a..564b741 100644 --- a/mig-xml/evergreen_staged_report.xml +++ b/mig-xml/evergreen_staged_report.xml @@ -1049,6 +1049,17 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 ORDER BY 2, 1, 3 + + usr_settings + Patron Settings + actors + 0 + Count.Setting.Value + SELECT COUNT(*), name, 'User''s Phone' FROM actor_usr_setting WHERE name IN ('opac.default_phone') GROUP BY 2, 3 + UNION ALL SELECT COUNT(*), name, value FROM actor_usr_setting WHERE name IN ('opac.hold_notify') GROUP BY 2, 3 + UNION ALL SELECT COUNT(*), a.name, aou.shortname FROM actor_usr_setting a JOIN actor.org_unit aou ON aou.id = REPLACE(a.value,'"','')::INTEGER + WHERE a.name IN ('opac.default_pickup_location','opac.default_search_location') GROUP BY 2, 3 ORDER BY 2, 3; + -- 1.7.2.5