Hi Dixson, take a look at the Koha Reports library, especially the Query MARC section:
https://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC So for your report, you could do: select dateaccessioned, (select description from itemtypes it where i.itype = itemtype) as itemtype, barcode, author, title, ExtractValue(metadata, '//datafield[@tag="245"]/subfield[@code="n"]') as Medium from items i left join biblio b on (i.biblionumber = b.biblionumber) left join biblio_metadata bm on (i.biblionumber = bm.biblionumber) order by 6, 5 Hope this helps, Katrin On 09.04.19 13:02, Dixson Rodriges wrote:
Please help me, how to generate a report on Language wise tiles of the items. The report should contain the the follwoing Fields Item type|Bar code|Author | Title | Language of the tile which we are mentioning in the "245 h" in the Catalogue DateaccessioneditypeitemcallnumberbarcodeauthortitleCopyright Medium Regards, Dixson _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
