[Koha] [Koha-devel] help in report

[Mohamed zalabany]

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 at hotmail.com
Mobile: 0111291444



> Date: Fri, 7 Dec 2012 16:35:06 -0300
> Subject: Re: [Koha-devel] help in report
> From: bgkriegel at gmail.com
> To: mh_zalabany at hotmail.com
> CC: koha at lists.katipo.co.nz; koha-devel at 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 at gmail.com
> 
> 
> 
> On Fri, Dec 7, 2012 at 4:13 PM, Mohamed zalabany
> <mh_zalabany at 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 at hotmail.com
> > Mobile: 0009989496
> >
> >
> > _______________________________________________
> > Koha-devel mailing list
> > Koha-devel at 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/