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
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
