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 do a similar thing for 526 by changing the tag numbers Elaine VWML <https://vwml.org> On Tue, Mar 28, 2023 at 12:54 AM zen zenitram <quickfir...@gmail.com> wrote: > We need cataloging report thats shows Tag 521 or Tag 526. > > On Tue, Mar 28, 2023 at 12:54 PM Ketan Kulkarni <ketan...@gmail.com> > 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 zenitram <quickfir...@gmail.com> > > wrote: > > > >> 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 > >> > > > _______________________________________________ > > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
