Hi, Alvaro. Thank you for your insight. I have found another SQL report that can generate the data that I need. I'm not into programming, all I can do is copy ready-made SQL and edit some parts. Again, thank you and have a nice day. On Fri, Aug 16, 2019 at 9:53 AM Alvaro Cornejo <cornejo.alvaro@gmail.com> wrote:
Hi Ma. Victoria
Some tables has been modified in the latest version of koha. Al marc data has been moved to an especific table outside the rest of reccord information. The new table is biblio_metadata
xml strucure is the same though.
You can check the tables structure for your specific version in:
http://schema.koha-community.org/
Therefore, you need to edit your query using a join of the biblio table and biblio_metadata
Regards,
Alvaro
|-----------------------------------------------------------------------------------------------------------------| 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 jeu. 15 août 2019 à 19:33, Ma. Victoria H. Silva-Manuel < mavicsilva@gmail.com> a écrit :
Hi.
I got the SQL report below from wiki.koha-community.org, however it is not working.
SELECT concat(b.title, ' ', ExtractValue((
SELECT marcxml FROM biblioitems b2 WHERE b.biblionumber = b2.biblionumber), '//datafield[@tag="245"]/subfield[@code="b"]')) AS title, b.author, i.itemcallnumber FROM biblio b LEFT JOIN items i ON (i.biblionumber=b.biblionumber)
It shows the following error:
The following error was encountered:
The database returned the following error:
Unknown column 'marcxml' in 'field list'
Please check the log for further details.
Return to previous page
Does anyone knows what went wrong?
Thank you.
-- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892