[Koha] [Koha-devel] help in report

[Bernardo Gonzalez Kriegel]

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/