[Koha] Report generation

[Barbara Johnson]

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.Johnson at bedfordtx.gov

________________________________
From: Koha <koha-bounces at lists.katipo.co.nz> on behalf of zen zenitram <quickfire28 at gmail.com>
Sent: Monday, March 27, 2023 11:17 PM
To: koha at lists.katipo.co.nz <koha at 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 at 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.