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, <mcdlibr...@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 > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha