[Koha] Report help needed

Elaine Bradtke eb at efdss.org
Wed May 11 05:42:16 NZST 2022

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,

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

More information about the Koha mailing list