[Koha] database help needed
chris at bigballofwax.co.nz
Fri Apr 9 07:43:28 NZST 2010
2010/4/8 Vimal Kumar <vimal0212 at 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.
> 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.
More information about the Koha