Hi Toni, On Thu, Jan 14, 2010 at 11:42 AM, Toni Rosa <ar...@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), '//datafie...@tag="952"]/subfie...@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), '//datafie...@tag="260"]/subfie...@code>="b"]') AS ITEM;' returns the 260$b data fro biblionumber 14 And so on. Maybe this will help. Kind Regards, Chris
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
