[Koha-devel] help in report

[Mohamed zalabany]

I need to make report to extract serials data but its not workingi think there is sothing wrong but i don't konowcould 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 ZalabanyIntegrated library systems consultant

Zalabany Knowledge Systems Team©
For Libraries and Information systems Development and support
mh_zalabany at hotmail.com
Mobile: 0009989496

 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20121207/a9fa9405/attachment.html>