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
cme...@waitaki.govt.nz
03 433 0850
--
Linda Culberson lcul...@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
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
