From d959c593d3e776a408ea0765a7e9b1a13393b533 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Fri, 25 May 2018 08:44:51 -0400 Subject: [PATCH] adding samples of notes to items tab for tlc reports --- mig-xml/excel_mapping_reports.xml | 9 ++++++--- 1 files changed, 6 insertions(+), 3 deletions(-) diff --git a/mig-xml/excel_mapping_reports.xml b/mig-xml/excel_mapping_reports.xml index e6ebac0..bcabbdf 100644 --- a/mig-xml/excel_mapping_reports.xml +++ b/mig-xml/excel_mapping_reports.xml @@ -67,9 +67,12 @@ tlc 0 Count.Note Type.Notes - SELECT COUNT(l_itemcomment), 'Item Comments' FROM ititeminformation_tsv_clean WHERE l_itemcomment IS NOT NULL GROUP BY 2 - UNION ALL SELECT COUNT(l_physicalcondition), 'Condition Notes' FROM ctlocitem_tsv_clean WHERE l_physicalcondition IS NOT NULL GROUP BY 2 - UNION ALL SELECT COUNT(l_checkinoutnote), 'Circ Notes' FROM ctlocitem_tsv_clean WHERE l_checkinoutnote IS NOT NULL GROUP BY 2 + SELECT COUNT(l_itemcomment)::TEXT, 'Item Comments' FROM ititeminformation_tsv_clean WHERE l_itemcomment IS NOT NULL GROUP BY 2 + UNION ALL SELECT COUNT(l_physicalcondition)::TEXT, 'Condition Notes' FROM ctlocitem_tsv_clean WHERE l_physicalcondition IS NOT NULL GROUP BY 2 + UNION ALL SELECT COUNT(l_checkinoutnote)::TEXT, 'Circ Notes' FROM ctlocitem_tsv_clean WHERE l_checkinoutnote IS NOT NULL GROUP BY 2 + UNION ALL (SELECT DISTINCT 'Sample Item Comment', l_itemcomment FROM ititeminformation_tsv_clean WHERE l_itemcomment IS NOT NULL LIMIT 20) + UNION ALL (SELECT DISTINCT 'Sample Physical Condition', l_physicalcondition FROM ctlocitem_tsv_clean WHERE l_physicalcondition IS NOT NULL LIMIT 20) + UNION ALL (SELECT DISTINCT 'Sample Circ Note', l_checkinoutnote FROM ctlocitem_tsv_clean WHERE l_checkinoutnote IS NOT NULL LIMIT 20) -- 1.7.2.5