[Koha] Not for Loan

Ma. Victoria H. Silva-Manuel mavicsilva at gmail.com
Tue Oct 23 20:16:06 NZDT 2018


Hi.

I copied this SQL report

SELECT
    CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',b.biblionumber,
'\">', b.title, '</a>' ) AS Title,
    ExtractValue(bi.marcxml,
'//datafield[@tag="245"]/subfield[@code="b"]') AS "Subtitle",
    ExtractValue(bi.marcxml,
'//datafield[@tag="245"]/subfield[@code="n"]') AS "Part name",
    ExtractValue(bi.marcxml,
'//datafield[@tag="245"]/subfield[@code="p"]') AS "Part",
    b.author AS 'Author',
    b.copyrightdate AS 'Year',
    i.barcode AS Barcode,
    i.itemcallnumber AS 'Callnumber',
    i.itype AS 'Item Type'FROM biblio bLEFT JOIN items i USING (
biblionumber ) LEFT JOIN biblioitems bi USING ( biblionumber ) WHERE
i.notforloan = '1'ORDER BY b.title


but I'm got this message when I ran it.

*The following error was encountered:*
The database returned the following error:
Unknown column 'bi.marcxml' in 'field list'
Please check the log for further details.
Return to previous page
<http://192.168.1.18:8080/cgi-bin/koha/reports/guided_reports.pl?reports=23&phase=Run%20this%20report#>

Can anyone tell me what is wrong?
-- 
Ma. Victoria H. Silva-Manuel
Registered Librarian, 3892


More information about the Koha mailing list