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 [email protected] Mobile: 0111291444 > Date: Fri, 7 Dec 2012 16:35:06 -0300 > Subject: Re: [Koha-devel] help in report > From: [email protected] > To: [email protected] > CC: [email protected]; [email protected] > > 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/
