I think you will find the data required in items.itemnotes_nonpublic so your WHERE clause might be: WHERE items.itemnotes_nonpublic LIKE '%Added to LA%' Use the LIKE comparison in case there is anything else in the notes. On 03/06/2020 05:53, Ketan Kulkarni wrote:

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@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

_______________________________________________

Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

-- Ian Bays Director, PTFS Europe Limited Content Management and Library Solutions +44 (0) 7774 995297 (mobile) skype: ian.bays email: ian.bays@ptfs-europe.com