[Koha] Not for Loan

[Ma. Victoria H. Silva-Manuel]

Yes, it worked like magic.
Thank you so much for your help.

On Tue, Oct 23, 2018 at 4:19 PM Bob Birchall <bob at 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 at 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 at 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