[Koha] Title/Subtitle List Report

[Ma. Victoria H. Silva-Manuel]

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