Hi Zen, This should provide you with a list of bibs with those two MARC tags:
SELECT i.dateaccessioned, b.biblionumber, i.permanent_location AS 'location', i.itemcallnumber AS 'call#', b.title, ExtractValue(metadata,'//datafield[@tag="521"]/subfield[@code>="a"]') AS 'audience', ExtractValue(metadata,'//datafield[@tag="526"]/subfield[@code>="a"]') AS 'note' FROM biblio b LEFT JOIN biblio_metadata m using (biblionumber) LEFT JOIN items i using (biblionumber) GROUP BY b.biblionumber Hope this helps, Barbara -- Barbara Johnson Technical Services Manager Bedford Public Library 2424 Forest Ridge Drive, Bedford, TX 76021-4667 Office: 817-952-2360<tel:817-952-2360> | Fax: 817-952-2396<tel:817-952-2396> | barbara.john...@bedfordtx.gov ________________________________ From: Koha <koha-boun...@lists.katipo.co.nz> on behalf of zen zenitram <quickfir...@gmail.com> Sent: Monday, March 27, 2023 11:17 PM To: koha@lists.katipo.co.nz <koha@lists.katipo.co.nz> Subject: [Koha] Report generation EXTERNAL SENDER Hello Any one know how to create report in sql, of your collection that has Tag 521 and 526 in your output. Thank you! _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha CONFIDENTIALITY NOTICE: This City of Bedford (CoB) email transmission is intended only for the use of the individual to whom it is addressed and may contain information that is confidential, privileged, and exempt from disclosure. Any use, copying, retention or disclosure by any person other than the intended recipient or the intended recipient's designees is strictly prohibited. If you have received this email in error, please notify the sender immediately by return email and destroy all electronic and paper copies of the original message and any attachments immediately. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
