Re: [Koha] Report generation

2023-03-28 Thread Elaine Bradtke
Warning: what I don't know about SQL queries would fill a book, but I've adapted one that works for us. SELECT biblionumber, ExtractValue(`metadata`,'//datafield[@tag="521"]/*') FROM `biblio_metadata` WHERE ExtractValue(`metadata`,'count(//datafield[@tag="521"])>0') If that works you could also d

Re: [Koha] Report generation

2023-03-28 Thread 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(m

Re: [Koha] Report generation

2023-03-28 Thread zen zenitram
We need cataloging report thats shows Tag 521 or Tag 526. On Tue, Mar 28, 2023 at 12:54 PM Ketan Kulkarni wrote: > What kind of report are you trying to generate ? > You can get many here > https://wiki.koha-community.org/wiki/SQL_Reports_Library > > Ketan > > On Tue, Mar 28, 2023 at 9:47 AM zen