[Koha] Title/Subtitle List Report

[Alvaro Cornejo]

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 at 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 at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>