[Koha] sql report 952 z (non-public note)

[Chris Meech]

Thanks Linda,
This is just the sql I needed

And http://schema.koha-community.org/ is a great resource!

Cheers
Chris

-----Original Message-----
From: Linda Culberson [mailto:lculber at mdah.state.ms.us] 
Sent: Tuesday, 13 September 2011 1:21 a.m.
To: Chris Meech
Cc: koha at lists.katipo.co.nz
Subject: Re: [Koha] sql report 952 z (non-public note)

Chris,
We use the non-public note to hold our information about the actual 
physical floor/row/bay/shelf information of the boxes in our archives 
(so we call it "location" in our query)  and to print out call slips. 
We use a sql statement  that includes;
ExtractValue(more_subfields_xml, 
'/collection/record/datafield[\@tag=\"999\"]/subfield[\@code=\"x\"]') as 
location

Hope that helps!
Linda

On 1:59 PM, Chris Meech wrote:
> Hi,
>
> We are using item level 952 (? or is it 942 ?) subfield z; non-public note, to store information on certain temporary collections that are loaned to us from other libraries for 3 months or so.
>
> I need an SQL report to search 952 (942?) subfield z non-public note across the database and find a specified value or any non-null value.
>
> I have been looking at adapting the Koha SQL wiki Query MARC reports with no success.
>
> Any suggestions or reports are welcome.
> Or if you have another way of dealing with items that are loaned to the Library from an external source I would be interested in hearing about it.
>
> Koha version:	3.04.04.000
>
> thanks
> Chris
>
> Christopher Meech
>
> Reference Librarian
> Waitaki District Libraries
> P.O. Box 134,Oamaru 9444
> 62 Thames St, Oamaru 9400
>
> cmeech at waitaki.govt.nz
> 03 433 0850
>
>
>
>

-- 
Linda Culberson      lculber at mdah.state.ms.us
Archives and Records Services Division
Ms. Dept. of Archives & History
P. O. Box 571
Jackson, MS 39205-0571
Telephone:  601/576-6873   Fax:  601/576-6824