[Koha] how to generate a report on Language wise tiles of the items.

[Katrin Fischer]

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