[Koha] database help needed
Vimal Kumar
vimal0212 at gmail.com
Fri Apr 9 05:14:44 NZST 2010
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20100408/9c44d3f2/attachment.htm
More information about the Koha
mailing list