X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-xml%2Fevergreen_staged_report.xml;h=7e9fce312e105b3cb1b46962c1f8bb5c5262a570;hp=564b7417db1b981695f50bddbc693dfb63102228;hb=d658005feeb916a45ca199abc17839de9bfa8d96;hpb=4336a9b3c2327970e0dacfc5861fa35668585449 diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml index 564b741..7e9fce3 100644 --- a/mig-xml/evergreen_staged_report.xml +++ b/mig-xml/evergreen_staged_report.xml @@ -386,14 +386,14 @@ SELECT COUNT(ac.id), acl.name, aou.name, ac.x_migrate::TEXT FROM asset_copy_legacy ac JOIN asset.copy_location acl ON acl.id = ac.location JOIN actor.org_unit aou ON aou.id = ac.circ_lib GROUP BY 2, 3, 4 ORDER BY 2, 3, 4 - + asset_barcode_patterns @@ -873,8 +873,8 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 Count of Barcodes (greater than 10).Left 60% of Characters SELECT COUNT(acard.id), LEFT(acard.barcode,(ROUND(LENGTH(acard.barcode)*.6))::INT) FROM actor_card acard GROUP BY 2 HAVING COUNT(acard.id) > 10 ORDER BY 2 - - + + usr_barcode_collisions Patron Barcode Collisions actors