[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('',biblionumber,'') AS bibnumber FROM (SELECT biblionumber, ExtractValue(metadata,'//datafield[@tag="300"]/subfield[@code>="a"]') AS suba, ExtractValue(metadata,'//data

Re: [Koha] Report help needed

Hi Elaine, I notice that you compare to >= so it will include other subfields bigger than... . Can you try changing this to read just =? Katrin On 05.01.21 20:10, Elaine Bradtke wrote: I'm trying to find records lacking 300 fields. The following keeps failing. Any help would be appreciated. T

Re: [Koha] Report help needed

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 S

Re: [Koha] Report help needed

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 On Tue, Jan 5, 2021 at 11:38 AM Lisette Scheer wrote: > Elaine, > There is a comma after AS sub3 that is