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=d3a4cf6872256a359d3c5e7e423ef55a372fdd12;hp=123ccd547c9713de4c326f96df2a3f8baff03968;hb=c1e8deba30264664ee6e779444939e58d8cf217a;hpb=d5fe0a84164f894c1ce34fadd98fe377aaf33a79
diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml
index 123ccd5..d3a4cf6 100644
--- a/mig-xml/evergreen_staged_report.xml
+++ b/mig-xml/evergreen_staged_report.xml
@@ -451,52 +451,32 @@
- asset_barcode_incumbent_collisions
- Copy Barcode Incumbent Collisions
+ asset_barcode_collisions
+ Copy Barcode Collisions
assets
0
Collision Count
- SELECT COUNT(id) FROM asset_copy_legacy WHERE x_migrate = TRUE AND barcode ~* 'collision' and barcode ~* 'incumbent'
+ SELECT COUNT(id) FROM asset_copy_legacy WHERE x_migrate = TRUE AND barcode LIKE 'x_%'
Incumbent collisions are those where the migrated barcodes collide with existing barcodes in the database.
- asset_barcode_incumbent_collisions
- Copy Barcode Incumbent Collisions
+ asset_barcode_collisions
+ Copy Barcode Collisions
assets
1
Collision Count
- SELECT COUNT(id) FROM asset_copy WHERE barcode ~* 'collision' and barcode ~* 'incumbent'
+ SELECT COUNT(id) FROM asset_copy WHERE barcode LIKE 'x_%'
Incumbent collisions are those where the migrated barcodes collide with existing barcodes in the database.
- asset_barcode_internal_collisions
- Copy Barcode Internal Collisions
- assets
- 0
- Collision Count
- SELECT COUNT(id) FROM asset_copy_legacy WHERE x_migrate = TRUE AND barcode ~* 'collision' and barcode ~* 'internal'
- Internal collisions are those where the migrated barcodes have conflicts within their list of barcodes.
-
-
-
- asset_barcode_internal_collisions
- Copy Barcode Internal Collisions
- assets
- 1
- Collision Count
- SELECT COUNT(id) FROM asset_copy WHERE barcode ~* 'collision' and barcode ~* 'internal'
- Internal collisions are those where the migrated barcodes have conflicts within their list of barcodes.
-
-
-
asset_barcode_collisions_shortlist
Copy Barcode Collisions (first 20)
assets
0
Collision List
- SELECT ac.barcode FROM asset_copy_legacy ac WHERE ac.barcode ~* 'collision' ORDER BY 1 LIMIT 20
+ SELECT ac.barcode FROM asset_copy_legacy ac WHERE ac.barcode LIKE 'x_%' ORDER BY 1 LIMIT 20
This is a shortlist of copy barcode collisions that maxes out at 20. If there are more collisions we will need to run a custom report.
@@ -506,7 +486,7 @@
assets
1
Collision List
- SELECT ac.barcode FROM asset_copy ac WHERE ac.barcode ~* 'collision' ORDER BY 1 LIMIT 20
+ SELECT ac.barcode FROM asset_copy ac WHERE ac.barcode LIKE '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.
@@ -516,7 +496,7 @@
assets
0
Number of Barcodes Matching Pattern Greater than 10.Left 60% of Characters
- SELECT COUNT(ac.id), LEFT(ac.barcode,(ROUND(LENGTH(ac.barcode)*.6))::INT) FROM asset_copy_legacy ac WHERE barcode ~* 'collision' GROUP BY 2 HAVING COUNT(ac.id) > 10 ORDER BY 2
+ SELECT COUNT(ac.id), LEFT(ac.barcode,(ROUND(LENGTH(ac.barcode)*.6))::INT) FROM asset_copy_legacy ac WHERE barcode LIKE 'x_%' GROUP BY 2 HAVING COUNT(ac.id) > 10 ORDER BY 2
@@ -525,7 +505,7 @@
assets
1
Number of Barcodes Matching Pattern Greater than 10.Left 60% of Characters
- SELECT COUNT(ac.id), LEFT(ac.barcode,(ROUND(LENGTH(ac.barcode)*.6))::INT) FROM asset_copy ac WHERE barcode ~* 'collision' GROUP BY 2 HAVING COUNT(ac.id) > 10 ORDER BY 2
+ SELECT COUNT(ac.id), LEFT(ac.barcode,(ROUND(LENGTH(ac.barcode)*.6))::INT) FROM asset_copy ac WHERE barcode LIKE 'x_%' GROUP BY 2 HAVING COUNT(ac.id) > 10 ORDER BY 2
@@ -930,48 +910,30 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
- usr_barcode_incoming_collisions
- Incoming Patron Barcode Collisions
+ usr_barcode_collisions
+ Patron Barcode Collisions
actors
0
Collision Count
- SELECT COUNT(acard.id) FROM actor_card_legacy acard WHERE barcode ~* 'collision' AND x_migrate = TRUE
+ SELECT COUNT(acard.id) FROM actor_card_legacy acard WHERE barcode LIKE 'x_%' AND x_migrate = TRUE
- usr_barcode_incoming_collisions
- Incoming Patron Barcode Collisions
+ usr_barcode_collisions
+ Patron Barcode Collisions
actors
1
Collision Count
- SELECT COUNT(acard.id) FROM actor_card acard WHERE barcode ~* 'collision'
+ SELECT COUNT(acard.id) FROM actor_card acard WHERE barcode LIKE 'x_%'
-
- 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' OR acard.barcode ~* '^x_') AND acard.x_migrate = TRUE ORDER BY 1 LIMIT 20
+ SELECT acard.barcode FROM actor_card_legacy acard WHERE acard.barcode LIKE '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.
@@ -981,7 +943,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' OR acard.barcode ~* '^x_') ORDER BY 1 LIMIT 20
+ SELECT acard.barcode FROM actor_card acard WHERE acard.barcode LIKE '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.