From: Rogan Hamby Date: Tue, 14 Jan 2020 14:27:42 +0000 (-0500) Subject: remove outdated reports X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=2fefcf603c66dc442489e554a4b72733a1f1803f remove outdated reports --- 2fefcf603c66dc442489e554a4b72733a1f1803f diff --cc mig-xml/evergreen_staged_report.xml index a796a67,eb40428..e42125a --- a/mig-xml/evergreen_staged_report.xml +++ b/mig-xml/evergreen_staged_report.xml @@@ -282,9 -282,37 +282,9 @@@ 0 Depth of Unfilled Holds Count.Depth - SELECT COUNT(ahr.id), ahr.selection_depth FROM action.hold_request ahr WHERE ahr.id IN (SELECT id FROM action_hold_request) AND ahr.cancel_time IS NULL AND ahr.capture_time IS NULL AND ahr.fulfillment_time IS NULL GROUP BY 2 ORDER BY 2 + SELECT COUNT(ahr.id), ahr.selection_depth FROM action.hold_request ahr WHERE ahr.id IN (SELECT id FROM m_action_hold_request) AND ahr.cancel_time IS NULL AND ahr.capture_time IS NULL AND ahr.fulfillment_time IS NULL GROUP BY 2 ORDER BY 2 - - - duplicate_title_matching_holds - holds - 0 - Holds by Title Matchs - Count.Number of Matches - SELECT COUNT(*), x_title_matches FROM m_action_hold_request_legacy WHERE TO_DATE(l_expire_date,'MM/DD/YYYY') > NOW() GROUP BY 2 ORDER BY 2 - - - - duplicate_title_matching_holds_w_zero - holds - 0 - Sample of Holds with No Matches - Borrower Barcode.Title.Request Date - SELECT l_borrower_id, l_title, l_request_date FROM m_action_hold_request_legacy WHERE TO_DATE(l_expire_date,'MM/DD/YYYY') > NOW() AND x_title_matches = 0 AND x_migrate LIMIT 20 - - - - duplicate_title_matching_holds_w_greater_than_1 - holds - 0 - Sample of Holds with More Than One Title Match - Borrower Barcode.Title.Request Date - SELECT l_borrower_id, l_title, l_request_date FROM m_action_hold_request_legacy WHERE TO_DATE(l_expire_date,'MM/DD/YYYY') > NOW() AND x_title_matches > 1 AND x_migrate LIMIT 20 - - @@@ -315,7 -343,16 +315,7 @@@ - asset_circ_mod_copies_count - m_asset_precat - Precats (AKA Copies Without Bibs) - assets - 0 - Copy Count.Migating - SELECT COUNT(ac.id), ac.x_migrate::TEXT FROM m_asset_copy_legacy ac WHERE ac.x_bre_id = -1 GROUP BY 2 - - - + m_asset_circ_mod_copies_count Copies by Circulation Modifier assets 0 @@@ -356,20 -393,20 +356,11 @@@ assets 1 Volume Count.Library - SELECT COUNT(acn.id), aou.name FROM asset_call_number acn JOIN actor.org_unit aou ON aou.id = acn.owning_lib GROUP BY 2 ORDER BY 2 + SELECT COUNT(acn.id), aou.name FROM m_asset_call_number acn JOIN actor.org_unit aou ON aou.id = acn.owning_lib GROUP BY 2 ORDER BY 2 -- - m_asset_cops_by_loc - Copies by Location - assets - 0 - Copy Count.Library.Migrated - SELECT COUNT(ac.id), acl.name, ac.x_migrate::TEXT FROM m_asset_copy_legacy ac JOIN asset.copy_location acl ON acl.id = ac.location GROUP BY 2, 3 ORDER BY 2, 3 - - --> ++ - asset_cops_by_loc_and_org + m_asset_cops_by_loc_and_org Copies by Location assets 0 @@@ -383,20 -420,20 +374,11 @@@ assets 0 Barcode - SELECT barcode FROM asset_copy_legacy WHERE location = 1 AND x_migrate + SELECT barcode FROM m_asset_copy_legacy WHERE location = 1 AND x_migrate -- - - m_asset_barcode_lengths - Barcode Lengths by Library - assets - 0 - Count of Barcode.Barcode Length.Library - SELECT COUNT(ac.id), LENGTH(ac.barcode), aou.name FROM m_asset_copy_legacy ac JOIN actor.org_unit aou ON aou.id = ac.circ_lib WHERE ac.x_migrate = TRUE GROUP BY 2, 3 ORDER BY 3, 2 - - - asset_no_barcode + m_asset_no_barcode Items Without Barcodes assets 0 @@@ -830,27 -870,27 +792,9 @@@ id = ac_sc.owner GROUP BY 2,3 ORDER BY actors 1 Count of Barcodes.Active - SELECT COUNT(id), active::TEXT FROM actor_card GROUP BY 2 + SELECT COUNT(id), active::TEXT FROM m_actor_card GROUP BY 2 -- - - - - SELECT COUNT(acard.id), LENGTH(acard.barcode), aou.name FROM m_actor_card_legacy acard JOIN m_actor_usr_legacy au ON au.id = acard.usr JOIN actor.org_unit aou ON aou.id = au.home_ou WHERE acard.x_migrate = TRUE GROUP BY 2, 3 ORDER BY 3, 2 - - - - usr_barcode_patterns Common Barcode Starting Patterns