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.title,
biblioitems.pages, biblioitems.publishercode,,
FROM items
LEFT JOIN biblioitems ON
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.

Vimal Kumar V.
School of Indian Legal Thought
Mahatma Gandhi University
Kottayam, Kerala
Blogs:  <>
"I forget what I was taught. I only remember what I have learnt"
-Patrick White
Koha mailing list

Reply via email to