X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-xml%2Fevergreen_staged_report.xml;fp=mig-xml%2Fevergreen_staged_report.xml;h=a796a67fd4c9135a359965ab492e180e909df679;hp=123ccd547c9713de4c326f96df2a3f8baff03968;hb=5b3e8ef51110574c502303ea6f7070458022c1f2;hpb=d246dbafba2d42d698f0bc57f0bf023bcfa34306
diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml
index 123ccd5..a796a67 100644
--- a/mig-xml/evergreen_staged_report.xml
+++ b/mig-xml/evergreen_staged_report.xml
@@ -285,34 +285,6 @@
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
-
-
- duplicate_title_matching_holds
- holds
- 0
- Holds by Title Matchs
- Count.Number of Matches
- SELECT COUNT(*), x_title_matches FROM 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 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 action_hold_request_legacy WHERE TO_DATE(l_expire_date,'MM/DD/YYYY') > NOW() AND x_title_matches > 1 AND x_migrate LIMIT 20
-
-
@@ -343,15 +315,6 @@
- asset_precat
- Precats (AKA Copies Without Bibs)
- assets
- 0
- Copy Count.Migating
- SELECT COUNT(ac.id), ac.x_migrate::TEXT FROM asset_copy_legacy ac WHERE ac.x_bre_id = -1 GROUP BY 2
-
-
-
asset_circ_mod_copies_count
Copies by Circulation Modifier
assets
@@ -814,29 +777,6 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
SELECT SUM(array_length(records,1)), COUNT(*) FROM groups
-
- bib_merges_searchformat
- Bibliographic Merges By Search Format
- bibs
- 0
- Count.Item Type
- DROP TABLE IF EXISTS temp_unnest; CREATE TABLE temp_unnest AS (SELECT UNNEST(records) FROM groups); SELECT COUNT(record), search_format_str FROM dedupe_batch WHERE record IN (SELECT * FROM temp_unnest) GROUP BY 2 ORDER BY 2
-
-
-
- bibs_not_loaded
- Bibliographic Records That Failed to Load
- bibs
- 0
- Title.Author.Control Number
- SELECT LEFT(ARRAY_TO_STRING(oils_xpath( '//*[@tag="245"]/*[@code="a"]/text()', a.marc),''),50) AS "Title",
- LEFT(ARRAY_TO_STRING(oils_xpath( '//*[@tag="100"]/*[@code="a"]/text()', a.marc),''),50) AS "Author",
- ARRAY_TO_STRING(oils_xpath( '//*[@tag="001"]/text()', a.marc),'') AS "001"
- FROM biblio_record_entry a LEFT JOIN biblio.record_entry b ON b.id = a.id WHERE b.id IS NULL AND a.x_migrate
-
-
-
-