[Koha] (no subject)

[Bob Birchall]

The MARC metadata are no longer in the biblioitems table (since 17.05). 
The new table is biblio_metatdata.
HTH,
Bob Birchall
Calyx

On 03/03/18 19:27, Javed Sahil wrote:
> Hi all,
> I am using koha 17.11,
> Can anybody help me correcting the syntax?
>
> ExtractValue( marcxml , ''//datafield[@tag="650"]/subfield[@code="a"]'')
> AS lcsh FROM biblioitems)
>
> The full code of report is following:
>
> SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=
> ',biblionumber,'\">',biblionumber,'</a>')
> AS bibnumber, lcsh
> FROM
> (SELECT biblionumber, ExtractValue( marcxml ,
> ''//datafield[@tag="650"]/subfield[@code="a"]'')
> AS lcsh FROM biblioitems)
> AS subjects
> WHERE lcsh LIKE CONCAT( '%', <<Subject>>, '%' )
>
> Regard,
> Javed Shoukat
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha