Hi Elaine, I guess there is a space missing before FROM in ...main_headingFROM `auth_header`...
And also a colon after GENRE/FORM) Else you can try your SQL by parts and start by the basics. Something like SELECT authid, datecreated, authtypecode, concat(ExtractValue(`marcxml`,'//datafield[@tag="100"]/*'), --), main_heading FROM `auth_header`WHERE datecreated SetASpecificDateHere Regards Alvaro |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le mar. 10 mai 2022 à 12:43, Elaine Bradtke <e...@efdss.org> a écrit : > I imported the following report from Mana, but it doesn't work as is. I > tried changing `marcxml` to `metadata` but it still didn't work. The error > message (You have an error in your SQL syntax; check the manual that > corresponds to your MariaDB server version for the right syntax to use near > '' at line 1) isn't specific enough for my limited abilities. I'd be > grateful for your help. > > Here's the original: > SELECT authid, datecreated, authtypecode, > concat(ExtractValue(`marcxml`,'//datafield[@tag="100"]/*'), -- > PERSO_NAMEExtractValue(`marcxml`,'//datafield[@tag="110"]/*'), -- > CORPO_NAMEExtractValue(`marcxml`,'//datafield[@tag="111"]/*'), -- > MEETI_NAMEExtractValue(`marcxml`,'//datafield[@tag="130"]/*'), -- > UNIF_TITLEExtractValue(`marcxml`,'//datafield[@tag="148"]/*'), -- > CHRON_TERMExtractValue(`marcxml`,'//datafield[@tag="150"]/*'), -- > TOPIC_TERMExtractValue(`marcxml`,'//datafield[@tag="151"]/*'), -- > GEOGR_NAMEExtractValue(`marcxml`,'//datafield[@tag="155"]/*') -- > GENRE/FORM) main_headingFROM `auth_header`WHERE datecreated BETWEEN <<(from > yyyy-mm-dd)>> AND <<(to yyyy-mm-dd)>>ORDER BY datecreated, authtypecode, > main_heading > > Elaine Bradtke > VWML <https://www.vwml.org> > English Folk Dance and Song Society <https://www.efdss.org> > Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY > Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and > Song Society in London, England. If you wish to phone me personally, send > an e-mail first. I work off site) > -------------------------------------------------------------------------- > Registered Company No. 297142 > Charity Registered in England and Wales No. 305999 > _______________________________________________ > > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha