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:[email protected]] Sent: Tuesday, 13 September 2011 1:21 a.m. To: Chris Meech Cc: [email protected] 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 > > [email protected] > 03 433 0850 > > > > -- Linda Culberson [email protected] 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 _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
