Dear Koustubha, Magnu and Lenora, Thank you for the quick response. I understood from your mail that data in 650 stored in xml and we have to filter it from there. This thing also mentioned in SQL Library in Koha Wiki. According to the SQL Library following query will filter data from 650-a field in biblio number 24. SELECT ExtractValue((SELECT marcxml FROM biblioitems WHERE biblionumber=24), '//datafield[@tag="650"]/subfield[@code>="a"]') AS ITEM What are the changes in query list entire 650-a field from all records? -- 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
2010/4/8 Vimal Kumar <vimal0212@gmail.com>:
Dear Koustubha, Magnu and Lenora,
Thank you for the quick response.
I understood from your mail that data in 650 stored in xml and we have to filter it from there.
This thing also mentioned in SQL Library in Koha Wiki.
According to the SQL Library following query will filter data from 650-a field in biblio number 24.
SELECT ExtractValue((SELECT marcxml FROM biblioitems WHERE biblionumber=24), '//datafield[@tag="650"]/subfield[@code>="a"]') AS ITEM
What are the changes in query list entire 650-a field from all records?
You would need to write a little script to do it, one that selects all the bibloitems, then extracts value for each one. If you try to extractvalue on more than one row at a time mysql will complain. Chris
participants (2)
-
Chris Cormack -
Vimal Kumar