Dear Friends,<br>I would like to prepare a report from "marcxml" field in "biblioitems" table.<br>The report should include author, title, subject and abstract.<br>I got some hint from koha wiki page,<br>
<a href="http://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC">http://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC</a><br><br>But I failed to wrote an SQL query for the purpose. <br>I am not familiar with writing query to extract data from XML part in MySQL.<br>
Can you help me to prepare a report from "marcxml" ?<br><br>If anybody from developers or users give guideline with examples, that will be a good contribution to Koha community.<br clear="all"><br>-- <br>Vimal Kumar V.<br>
Asst. Librarian<br>Asian School of Business<br>Technopark, Trivandrum-695 581<br>Web: <a href="http://www.vimalkumar.co.nr">www.vimalkumar.co.nr</a><br>Blog: <a href="http://vimalkumar.oksociety.in">http://vimalkumar.oksociety.in</a><br>
<br>OK Society Volunteer. <a href="http://oksociety.in">http://oksociety.in</a><br>---------------------------------------------------------------------------<br>"I forget what I was taught. I only remember what I have learnt"<br>
-Patrick White<br>