[Koha] SQL help please

[Ian Bays]

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 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
>>
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at 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 at ptfs-europe.com