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 Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha