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

Vimal, Koha 17.05 has been released with bug 17898. With it you should see a new "Update" column on the report list if you have reports using the biblioitems.marcxml columns. There is a "Update SQL" button, when clicked a script will update the query to use the new biblio_metadata column. This

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

Dear Vimal, Please try with this query SELECT biblio.biblionumber, biblio.author, biblio.title, biblioitems.editionstatement, biblioitems.publishercode, SUBSTRING(biblioitems.marcxml, LOCATE('', biblioitems.marcxml, LOCATE('', biblioitems.marcxml, LOCATE('', biblioitems.marcxml,

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

Hello Vimar, you need to join the table biblio_metadata to your query Best Josef st 9. 8. 2017 v 7:06 odesílatel Vimal Kumar V. napsal: > Dear Friends, > I am trying to generate a book list with keywords from 650$a using the > following SQL query, > > SELECT

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

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,