[Koha] Unknown column 'metadata' in 'field list'

[Shivendra]

Dear Vimal,

Please try with this query

SELECT biblio.biblionumber, biblio.author, biblio.title,
biblioitems.editionstatement, biblioitems.publishercode,
SUBSTRING(biblioitems.marcxml, LOCATE('<subfield code="a">',
       biblioitems.marcxml, LOCATE('<datafield tag="650"',
biblioitems.marcxml)+19),
       LOCATE('</subfield>', biblioitems.marcxml, LOCATE('<subfield
code="a">',
       biblioitems.marcxml, LOCATE('<datafield tag="650"',
       biblioitems.marcxml)+19)) - LOCATE('<subfield code="a">',
biblioitems.marcxml,
       LOCATE('<datafield tag="650"', biblioitems.marcxml)+19)) AS keywordl
FROM biblioitems, biblio


Dr. Shivendra Singh
Assistant Librarian
Guru Gobind Singh Medical College
Baba Farid University of Health Sciences
Faridkot -151203, Punjab
https://www.researchgate.net/profile/Shivendra_Singh3/contributions

On 9 August 2017 at 10:36, Vimal Kumar V. <vimal0212 at gmail.com> wrote:

> Dear Friends,
> I am trying to generate a book list with keywords from 650$a using the
> following SQL query,
>
> SELECT ExtractValue( metadata,
> '//datafield[@tag="650"]/subfield[@code="a"]' ) AS Keyword, items.barcode,
> items.dateaccessioned, items.itemcallnumber, biblio.author, biblio.title,
> biblioitems.pages, biblioitems.publishercode, biblioitems.place,
> biblio.copyrightdate
> FROM items
> LEFT JOIN biblioitems ON
> (items.biblioitemnumber=biblioitems.biblioitemnumber)
> LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)
> ORDER BY LPAD(items.barcode,40,' ') ASC
>
> After running the report, I got the following error message,
>
> The database returned the following error:
> Unknown column 'metadata' in 'field list'
> Please check the log for further details.
>
> Please review the SQL query and help me to solve the problem.
>
>
> Regards,
> --
> Vimal Kumar V.
> Librarian
> School of Indian Legal Thought
> Mahatma Gandhi University
> Kottayam, Kerala
> Web: http://www.vimalkumar.info
> Blogs: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in
> http://dspacegeek.blogspot.in
> http://moovandan.blogspot.in  <http://moovandan.blogspot.in>
> ------------------------------------------------------------
> ---------------
> "I forget what I was taught. I only remember what I have learnt"
> -Patrick White
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>



-- 
Shivendra
9815526163