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