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
