Dear Koustubha, Magnu and Lenora,<br><br>Thank you for the quick response.<br><br>I understood from your mail that data in 650 stored in xml and we have to filter it from there.<br><br>This thing also mentioned in SQL Library in Koha Wiki.<br>
<br>According to the SQL Library following query will filter data from 650-a field in biblio number 24.<br><br>SELECT <br> ExtractValue((SELECT marcxml FROM biblioitems WHERE biblionumber=24), '//datafield[@tag="650"]/subfield[@code>="a"]') AS ITEM<br>
<br>What are the changes in query list entire 650-a field from all records?<br><br><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>