Removing the comma fixed it! It was built off another report with a lot more fields. I'm a proud graduate of the cut and paste school of report writing. ;-) Elaine VWML <https://vwml.org>
On Tue, Jan 5, 2021 at 11:38 AM Lisette Scheer <liset...@latahlibrary.org> wrote: > Elaine, > There is a comma after AS sub3 that is not needed. > I was able to get the report to run on my system after taking out the , > Lisette > -----Original Message----- > From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Elaine > Bradtke > Sent: Tuesday, January 5, 2021 11:10 AM > To: koha <koha@lists.katipo.co.nz> > Subject: [Koha] Report help needed > > I'm trying to find records lacking 300 fields. The following keeps > failing. Any help would be appreciated. Thanks! > > SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber= > ',biblionumber,'\">',biblionumber,'</a>') > AS bibnumber > FROM > (SELECT biblionumber, > ExtractValue(metadata,'//datafield[@tag="300"]/subfield[@code>="a"]') AS > suba, > ExtractValue(metadata,'//datafield[@tag="300"]/subfield[@code>="b"]') AS > subb, > ExtractValue(metadata,'//datafield[@tag="300"]/subfield[@code>="3"]') AS > sub3, FROM biblio_metadata) AS subfields WHERE suba = "" > AND subb = "" > AND sub3 = "" > > Elaine Bradtke > VWML <https://www.vwml.org> > Our income is severely diminished in these exceptionally uncertain times. > Please help us to survive beyond this national crisis. Donate now < > https://www.efdss.org/support-us>. > 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