[Koha] 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