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
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. 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
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-bounces@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
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 <lisettes@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-bounces@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
participants (3)
-
Elaine Bradtke -
Katrin Fischer -
Lisette Scheer