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 <[email protected]> wrote: > We need cataloging report thats shows Tag 521 or Tag 526. > > On Tue, Mar 28, 2023 at 12:54 PM Ketan Kulkarni <[email protected]> > 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 <[email protected]> > > 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 > >> [email protected] > >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > >> > > > _______________________________________________ > > Koha mailing list http://koha-community.org > [email protected] > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
