We need cataloging report thats shows Tag 521 or Tag 526. On Tue, Mar 28, 2023 at 12:54 PM Ketan Kulkarni <ketan404@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@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
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@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@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@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
participants (2)
-
Elaine Bradtke -
zen zenitram