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 [email protected] On Fri, Dec 7, 2012 at 4:13 PM, Mohamed zalabany <[email protected]> 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 > [email protected] > Mobile: 0009989496 > > > _______________________________________________ > Koha-devel mailing list > [email protected] > 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/ _______________________________________________ Koha-devel mailing list [email protected] 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/
