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/