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

[Linda Culberson]

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