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

2011-09-13 Thread Chris Meech
: 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 state

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

2011-09-12 Thread Chris Cormack
On 13 September 2011 01:20, Linda Culberson wrote: > 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

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

2011-09-12 Thread 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, '/colle

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

2011-09-11 Thread Chris Meech
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 fin