16 Aug
2019
16 Aug
'19
2:33 a.m.
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