(no subject)

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

(no subject)

Javed Sahil
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
[hidden email]
https://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: (no subject)

Bob Birchall @ Calyx
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
> [hidden email]
> https://lists.katipo.co.nz/mailman/listinfo/koha

_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
https://lists.katipo.co.nz/mailman/listinfo/koha