Yes, it worked like magic. Thank you so much for your help. On Tue, Oct 23, 2018 at 4:19 PM Bob Birchall <bob@calyx.net.au> wrote:
Ah yes, sorry. Replace each occurrence of marcxml with metadata
That should do it. Bob
On 23/10/18 6:51 pm, Ma. Victoria H. Silva-Manuel wrote:
We are using 17.11.10. I followed your instructions but i'm still getting the same error message.
On Tue, Oct 23, 2018 at 3:43 PM Bob Birchall <bob@calyx.net.au> wrote:
On 23/10/18 6:16 pm, Ma. Victoria H. Silva-Manuel wrote:
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?
Hi, do three things: - delete LEFT JOIN biblioitems bi and replace it with LEFT JOIN biblio_metadata bi - at FROM biblio bLEFT JOIN insert a space between b and LEFT - at i.itype AS 'Item Type'FROM insert a space between Type' and FROM
The marcxml was taken out of the biblioitems table and put in a separate biblio_metadata table a couple of versions back. You haven't said what version you are using, but it must be relatively recent?
HTH, Bob Birchall Calyx _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892
-- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892