Hi I´m trying to make this changes and I get the folowing error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/datafield[@tag="856"]/subfield[@code="u"]),"/", 3) FROM biblio_metadata WHERE' at line 2 My sql report looks like: SELECT DISTINCT Substring_index(Extractvalue(metadata, ‘//datafield[@tag="856"]/subfield[@code="u"]),"/", 3) FROM biblio_metadata WHERE Extractvalue(metadata, ‘//datafield[@tag="856"]/subfield[@code="3"]’) LIKE ‘ACCESS ONLINE VERSION%’ Note that koha updated the marclxlm fields to metadata Any idea? I cant find where this error comes from. Since report does not work yet I didn't test the JS yet Regards Alvaro Cornejo |-----------------------------------------------------------------------------------------------------------------| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.com Le mer. 6 févr. 2019 à 09:02, Owen Leonard <oleonard@myacpl.org> a écrit :
https://bywatersolutions.com/education/koha-electronic-resources
At the moment ByWater's blog isn't correctly formatting JS and CSS, so check this version:
https://gitlab.com/snippets/1811230
I assume you're replacing DOMAIN.NAME and YOUR_REPORT_ID with the correct values? Another thing to check is whether your system has the TrackClicks preference enabled. If so, the script's check for URL patterns is going to need to be revised.
-- Owen
-- Web Developer Athens County Public Libraries https://www.myacpl.org _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha