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 <[email protected]> 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 < > [email protected]> 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 >> [email protected] >> https://lists.katipo.co.nz/mailman/listinfo/koha >> > -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
