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 <eb@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