[Koha] Not for Loan

[Jonathan Druart]

Hello Victoria,

If you want even more magic you can try the "Update SQL" button that
appears on the report list view when a report is using the old
biblioitems.marcxml fields.

See those screenshots: https://snag.gy/j17fdl.jpg and
https://snag.gy/1i063z.jpg

Regards,
Jonathan

On Tue, 23 Oct 2018 at 05:23 Ma. Victoria H. Silva-Manuel <
mavicsilva at gmail.com> wrote:

> 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
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>