[Koha] SQL help please

Ketan Kulkarni ketan404 at gmail.com
Wed Jun 3 16:53:30 NZST 2020

You will have to use the function ExtractValue() for extracting the public
note. Once you do that, just download the CSV and sort that column in a
spreadsheet application. Should do the trick.

On Wed, Jun 3, 2020 at 10:18 AM Kerrie Stevens <kerrie.stevens at ac.edu.au>

> Hi All,
> I want to be able to run a report that pulls out bib number, title, author
> & barcode for resources that have "Added to LA" in the 'x-non-public note'
> field of the item record. That last bit is the bit I'm not sure how to
> do...?
> Thank you for any assistance you may provide...
> Kerrie Stevens
> Alphacrucis College
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

More information about the Koha mailing list