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 will not work in all cases but if your query is simple it should work.
Regards, Jonathan On Wed, 9 Aug 2017 at 02:06 Vimal Kumar V. <[email protected]> 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 > [email protected] > https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
