Hi Mahesh, See https://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC hope this helps Indranil Das Gupta L2C2 Technologies On Tue, 4 Oct, 2022, 11:09 am Mahesh Angadi, <mcdlibrary@gmail.com> wrote:
Hi, I am using Koha 3.20,
In report generation, I am able to get details like title, author, year, publisher, call number, etc, But I am not able to get data related to Tag 650 - Subject. I couldn't find the relevant field in guided wizard of report also.
I am sharing my sql query. Kindly suggest the additions to sql query with which I can also get data related to Tag 650 - Subject.
I have stored all Tag 650 data in one column only (its not a repeatable field, in our case. Eg. one subject name is added for all titles, for eg, Economics) =650 \\$aEconomics
Our Report SQL Query is as follows:-
SELECT
items.barcode,biblio.title,biblio.author,biblioitems.publishercode,biblio.copyrightdate,items.itemcallnumber,biblioitems.isbn FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE items.itype=<<itype|itemtypes>> ORDER BY items.barcode asc
-- Mr. Mahesh Angadi, _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha