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@mdah.state.ms.us] Sent: Tuesday, 13 September 2011 1:21 a.m. To: Chris Meech Cc: koha@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@waitaki.govt.nz 03 433 0850

-- Linda Culberson lculber@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