[Koha] SQL help please
ian.bays at ptfs-europe.com
Wed Jun 3 21:12:46 NZST 2020
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>
>> 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
>> 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
Director, PTFS Europe Limited
Content Management and Library Solutions
+44 (0) 7774 995297 (mobile)
email: ian.bays at ptfs-europe.com
More information about the Koha