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 <b...@calyx.net.au
<mailto:b...@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=
<http://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 <mailto:Koha@lists.katipo.co.nz>
https://lists.katipo.co.nz/mailman/listinfo/koha
--
Ma. Victoria H. Silva-Manuel
Registered Librarian, 3892
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
