X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-xml%2Fevergreen_staged_report.xml;h=ca0d47c85757eec5ff583464ddc16ca4fa4df322;hp=491965c5b3c77013f0e9a2dac9eff7cf61c05a4b;hb=5f91fb205ffb7dc220bd1b2812cd4becd1d86cba;hpb=13e86d342c9b320afbbcc2c1007bcded07468599 diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml index 491965c..ca0d47c 100644 --- a/mig-xml/evergreen_staged_report.xml +++ b/mig-xml/evergreen_staged_report.xml @@ -315,6 +315,15 @@ + 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 @@ -646,21 +655,12 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 Extracted Bibliographic Records bibs 0 - Count.Deleted.Migrated - SELECT COUNT(bre.id), bre.deleted::TEXT, bre.x_migrate::TEXT FROM biblio_record_entry_legacy bre GROUP BY 2, 3 ORDER BY 2, 3 + Count.Sourcee.Migrated + SELECT COUNT(bre.id), bre.x_source, bre.x_migrate::TEXT FROM biblio_record_entry_legacy bre GROUP BY 2, 3 ORDER BY 2, 3 False means the records are not deleted. - bibs - Extracted Bibliographic Records - bibs - 1 - Count - SELECT COUNT(id) FROM biblio_record_entry_stage WHERE x_migrate = TRUE - - - bibswovolumes Bibliographic Records Without Volumes bibs