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