Vimal emailed me off-list with the data he needs to extract. This should do it: SELECT extractValue(marcxml,"collection/record/datafield[@tag='952'][1]/subfield[@code='p']"), extractValue(marcxml,"collection/record/datafield[@tag='024'][1]/subfield[@code='a']"), extractValue(marcxml,"collection/record/datafield[@tag='020'][1]/subfield[@code='a']"), extractValue(marcxml,"collection/record/datafield[@tag='100'][1]/subfield[@code='a']"), extractValue(marcxml,"collection/record/datafield[@tag='245'][1]/subfield[@code='a']"), extractValue(marcxml,"collection/record/datafield[@tag='650'][1]/subfield[@code='a']"), extractValue(marcxml,"collection/record/datafield[@tag='500'][1]/subfield[@code='a]"), extractValue(marcxml,"collection/record/datafield[@tag='520'][1]/subfield[@code='a']"), extractValue(marcxml,"collection/record/datafield[@tag='650'][1]/subfield[@code='a']") FROM biblioitems Cheers, Daniel Vimal Kumar-3 wrote:
Dear Friends, I would like to prepare a report from "marcxml" field in "biblioitems" table. The report should include author, title, subject and abstract. I got some hint from koha wiki page, http://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC
But I failed to wrote an SQL query for the purpose. I am not familiar with writing query to extract data from XML part in MySQL. Can you help me to prepare a report from "marcxml" ?
If anybody from developers or users give guideline with examples, that will be a good contribution to Koha community.
-- Vimal Kumar V. Asst. Librarian Asian School of Business Technopark, Trivandrum-695 581 Web: www.vimalkumar.co.nr Blog: http://vimalkumar.oksociety.in
OK Society Volunteer. http://oksociety.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- View this message in context: http://old.nabble.com/How-to-extract-data-from-marcxml.biblioitmes---tp28514... Sent from the Koha - Discuss mailing list archive at Nabble.com.