[Koha-devel] Koha3, loading locale data, contribs and funcionality

[Chris Nighswonger]

Hi Toni,

On Thu, Jan 14, 2010 at 11:42 AM, Toni Rosa <arosa at tgi.es> wrote:

> Thanks for your answer, Nicole.
> I have another doubt regarding Koha 3.
>
> I've seen that in Koha 3 (and maybe in earlier versions too) the table
> "marc_subfield_table" is gone.
>
> Does it mean that it is not possible, anymore, to select a biblio by its
> marc subvalues only using SQL?
> (Skimming over the code I see in C4/Biblio.pm that the method
> GetMarcBiblio loads a new MARC::Record from the values in
> biblioitems.marcxml, but that' would be programming, and we have some
> SQL queries in use with Koha 2.7 that use the now gone
> "marc_subfield_table" table)
>

MySQL has some XML handling functions:

http://dev.mysql.com/doc/refman/5.4/en/xml-functions.html

For example:

'SELECT ExtractValue((SELECT marcxml FROM biblioitems WHERE
biblionumber=14), '//datafield[@tag="952"]/subfield[@code>="a"]') AS ITEM;'
returns the entire 952 data for all 952 fields for biblionumber 14 (without
delimiting)

'SELECT ExtractValue((SELECT marcxml FROM biblioitems WHERE
biblionumber=14), '//datafield[@tag="260"]/subfield[@code>="b"]') AS ITEM;'
returns the 260$b data fro biblionumber 14

And so on.

Maybe this will help.

Kind Regards,
Chris
-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/koha-devel/attachments/20100114/fa09db0c/attachment-0003.htm>