X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-xml%2Fevergreen_staged_report.xml;h=92c723684a30c12a08904ab6022f6492c44c44cb;hp=7e9fce312e105b3cb1b46962c1f8bb5c5262a570;hb=73d5fd17efb5b98b42e37325cbcfafe5de3190ca;hpb=d658005feeb916a45ca199abc17839de9bfa8d96
diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml
index 7e9fce3..92c7236 100644
--- a/mig-xml/evergreen_staged_report.xml
+++ b/mig-xml/evergreen_staged_report.xml
@@ -838,23 +838,23 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
SELECT COUNT(id), active::TEXT FROM actor_card GROUP BY 2
-
+
-
+
usr_barcode_patterns
@@ -875,8 +875,8 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
- usr_barcode_collisions
- Patron Barcode Collisions
+ usr_barcode_incoming_collisions
+ Incoming Patron Barcode Collisions
actors
0
Collision Count
@@ -884,21 +884,39 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
- usr_barcode_collisions
- Patron Barcode Collisions
+ usr_barcode_incoming_collisions
+ Incoming Patron Barcode Collisions
actors
1
Collision Count
SELECT COUNT(acard.id) FROM actor_card acard WHERE barcode ~* 'collision'
+
+ usr_barcode_incumbent_collisions
+ Incumbent Patron Barcode Collisions
+ actors
+ 0
+ Collision Count
+ SELECT COUNT(acard.id) FROM actor_card_legacy acard WHERE barcode ~* '^x_' AND x_migrate = TRUE
+
+
+
+ usr_barcode_incumbent_collisions
+ Incumbent Patron Barcode Collisions
+ actors
+ 1
+ Collision Count
+ SELECT COUNT(acard.id) FROM actor_card acard WHERE barcode ~* '^x_'
+
+
usr_barcode_collision_shortlist
Patron Barcode Collisions (first 20)
actors
0
Collision List
- SELECT acard.barcode FROM actor_card_legacy acard WHERE acard.barcode ~* 'collision' AND acard.x_migrate = TRUE ORDER BY 1 LIMIT 20
+ SELECT acard.barcode FROM actor_card_legacy acard WHERE (acard.barcode ~* 'collision' OR acard.barcode ~* '^x_') AND acard.x_migrate = TRUE ORDER BY 1 LIMIT 20
This is a shortlist of patron barcode collisions that maxes out at 20. If there are more collisions we will need to run a custom report. In some cases we may flag individual accounts to not migrate.
@@ -908,7 +926,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
actors
1
Collision List
- SELECT acard.barcode FROM actor_card acard WHERE acard.barcode ~* 'collision' ORDER BY 1 LIMIT 20
+ SELECT acard.barcode FROM actor_card acard WHERE (acard.barcode ~* 'collision' OR acard.barcode ~* '^x_') ORDER BY 1 LIMIT 20
This is a shortlist of patron barcode collisions that maxes out at 20. If there are more collisions we will need to run a custom report. In some cases we may flag individual accounts to not migrate.
@@ -918,7 +936,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
actors
0
Number of Barcodes Matching Pattern Greater than 10.Left 60% of Characters
- SELECT COUNT(acard.id), LEFT(acard.barcode,(ROUND(LENGTH(acard.barcode)*.6))::INT) FROM actor_card_legacy acard WHERE acard.barcode ~* 'collision' AND acard.x_migrate = TRUE GROUP BY 2 HAVING COUNT(acard.id) > 10 ORDER BY 2
+ SELECT COUNT(acard.id), LEFT(acard.barcode,(ROUND(LENGTH(acard.barcode)*.6))::INT) FROM actor_card_legacy acard WHERE (acard.barcode ~* 'collision' OR acard.barcode ~* '^x_') AND acard.x_migrate = TRUE GROUP BY 2 HAVING COUNT(acard.id) > 10 ORDER BY 2
@@ -927,7 +945,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
actors
1
Number of Barcodes Matching Pattern Greater than 10.Left 60% of Characters
- SELECT COUNT(acard.id), LEFT(acard.barcode,(ROUND(LENGTH(acard.barcode)*.6))::INT) FROM actor_card acard WHERE acard.barcode ~* 'collision' GROUP BY 2 HAVING COUNT(acard.id) > 10 ORDER BY 2
+ SELECT COUNT(acard.id), LEFT(acard.barcode,(ROUND(LENGTH(acard.barcode)*.6))::INT) FROM actor_card acard WHERE (acard.barcode ~* 'collision' OR acard.barcode ~* '^x_') GROUP BY 2 HAVING COUNT(acard.id) > 10 ORDER BY 2