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=c03e788dfa3435354f1be74863ad13db3a0f241b;hp=289261c8ff7fb261cbe15c72a16845812f1ca4e4;hb=daa5cc1f2162c79b5ffdaaeacbb642162381dda9;hpb=956560674444f2f69b877dffb4760c388f265123
diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml
index 289261c..c03e788 100644
--- a/mig-xml/evergreen_staged_report.xml
+++ b/mig-xml/evergreen_staged_report.xml
@@ -402,7 +402,7 @@
assets
0
Collision List
- SELECT ac.barcode FROM m_asset_copy_legacy ac WHERE ac.barcode LIKE 'x_%' ORDER BY 1 LIMIT 20
+ SELECT ac.barcode FROM m_asset_copy_legacy ac WHERE ac.barcode LIKE 'x_%' AND ac.x_migrate = TRUE 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.
@@ -422,7 +422,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 m_asset_copy_legacy ac WHERE barcode LIKE 'x_%' 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 m_asset_copy_legacy ac WHERE barcode LIKE 'x_%' AND ac.x_migrate = TRUE GROUP BY 2 HAVING COUNT(ac.id) > 10 ORDER BY 2