[Koha] database help needed

[Vimal Kumar]

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