Thank you very much the problem was in the last coma Mohamed El ZalabanyIntegrated library systems consultant Zalabany Knowledge Systems Team© For Libraries and Information systems Development and support mh_zalabany@hotmail.com Mobile: 0111291444
Date: Fri, 7 Dec 2012 16:35:06 -0300 Subject: Re: [Koha-devel] help in report From: bgkriegel@gmail.com To: mh_zalabany@hotmail.com CC: koha@lists.katipo.co.nz; koha-devel@lists.koha-community.org
I detected 4 errors, 1) Simbol ">" in Extract Value 2) Space on "as Publication place" (use underscore or between quotes) 3) Last comma after 'Price' 4) Itemtype must by within single quote
try
select ExtractValue(marcxml,'//datafield[@tag="501"]/subfield[@code="a"]') as ID, ExtractValue(marcxml,'//datafield[@tag="310"]/subfield[@code="a"]') as Freq, ExtractValue(marcxml,'//datafield[@tag="245"]/subfield[@code="a"]') as Title, ExtractValue(marcxml,'//datafield[@tag="260"]/subfield[@code="b"]') as Publisher, ExtractValue(marcxml,'//datafield[@tag="260"]/subfield[@code="a"]') as Publication_place, ExtractValue(marcxml,'//datafield[@tag="546"]/subfield[@code="a"]') as Language, ExtractValue(marcxml,'//datafield[@tag="500"]/subfield[@code="a"]') as Note, ExtractValue(marcxml,'//datafield[@tag="500"]/subfield[@code="a"]') as Subject, ExtractValue(marcxml,'//datafield[@tag="982"]/subfield[@code="a"]') as Price from biblioitems where itemtype = 'CR'
-- Bernardo Gonzalez Kriegel bgkriegel@gmail.com
On Fri, Dec 7, 2012 at 4:13 PM, Mohamed zalabany <mh_zalabany@hotmail.com> wrote:
I need to make report to extract serials data
but its not working
i think there is sothing wrong but i don't konow
could any body help me
select ExtractValue(marcxml,'//datafield[@tag="501"]/subfield[@code>="a"]') as ID, ExtractValue(marcxml,'//datafield[@tag="310"]/subfield[@code>="a"]') as Freq, ExtractValue(marcxml,'//datafield[@tag="245"]/subfield[@code>="a"]') as Title, ExtractValue(marcxml,'//datafield[@tag="260"]/subfield[@code>="b"]') as Publisher, ExtractValue(marcxml,'//datafield[@tag="260"]/subfield[@code>="a"]') as Publication place, ExtractValue(marcxml,'//datafield[@tag="546"]/subfield[@code>="a"]') as Language, ExtractValue(marcxml,'//datafield[@tag="500"]/subfield[@code>="a"]') as Note, ExtractValue(marcxml,'//datafield[@tag="500"]/subfield[@code>="a"]') as Subject, ExtractValue(marcxml,'//datafield[@tag="982"]/subfield[@code>="a"]') as Price, from biblioitems where itemtype = CR
Mohamed El Zalabany
Integrated library systems consultant
Zalabany Knowledge Systems Team© For Libraries and Information systems Development and support mh_zalabany@hotmail.com Mobile: 0009989496
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/