[Koha] Report generation

[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 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 <quickfire28 at 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 <ketan404 at 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 <quickfire28 at 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 at lists.katipo.co.nz
> >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> >>
> >
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>