<iteration>0</iteration>
<report_title>Sample of Holds with No Matches</report_title>
<heading>Borrower Barcode.Title.Request Date</heading>
- <query>SELECT l_borrower_id, l_title, l_request_date FROM action_hold_request_legacy WHERE TO_DATE(l_expire_date,'MM/DD/YYYY') > NOW() AND x_title_matches = 0 LIMIT 20</query>
+ <query>SELECT l_borrower_id, l_title, l_request_date FROM action_hold_request_legacy WHERE TO_DATE(l_expire_date,'MM/DD/YYYY') > NOW() AND x_title_matches = 0 AND x_migrate LIMIT 20</query>
</report>
<report>
<iteration>0</iteration>
<report_title>Sample of Holds with More Than One Title Match</report_title>
<heading>Borrower Barcode.Title.Request Date</heading>
- <query>SELECT l_borrower_id, l_title, l_request_date FROM action_hold_request_legacy WHERE TO_DATE(l_expire_date,'MM/DD/YYYY') > NOW() AND x_title_matches > 1 LIMIT 20</query>
+ <query>SELECT l_borrower_id, l_title, l_request_date FROM action_hold_request_legacy WHERE TO_DATE(l_expire_date,'MM/DD/YYYY') > NOW() AND x_title_matches > 1 AND x_migrate LIMIT 20</query>
</report>
<!-- ASSET REPORTS -->
<query>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</query>
</report>
+ <report>
+ <name>asset_cops_w_loc_one</name>
+ <report_title>Copies with a Location of Stacks</report_title>
+ <tag>assets</tag>
+ <iteration>0</iteration>
+ <heading>Barcode</heading>
+ <query>SELECT barcode FROM asset_copy_legacy WHERE location = 1 AND x_migrate</query>
+ </report>
+
<!-- report>
<name>asset_barcode_lengths</name>
<report_title>Barcode Lengths by Library</report_title>
<query>SELECT COUNT(id) FROM biblio_record_entry where id IN (SELECT record FROM asset.call_number WHERE label ~* '##URI##')</query>
</report>
+ <report>
+ <name>bibsff</name>
+ <report_title>Bibliographic Records with Adjusted Fixed Fields</report_title>
+ <tag>bibs</tag>
+ <iteration>0</iteration>
+ <heading>Count.Original Search Format.New Search Format</heading>
+ <query>SELECT COUNT(*), ARRAY_TO_STRING(x_search_format,','), ARRAY_TO_STRING(x_after_search_format,',') FROM biblio_record_entry_legacy WHERE x_migrate AND x_after_search_format IS NOT NULL GROUP BY 2, 3 ORDER BY 3,2</query>
+ </report>
+
<report>
<name>bibs_notes</name>
<report_title>Bib Record Notes</report_title>