[Koha] SQL help please

[Ketan Kulkarni]

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>
wrote:

> 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
>