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