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

Chris Cormack chris at bigballofwax.co.nz
Tue Sep 13 08:34:28 NZST 2011


On 13 September 2011 01:20, Linda Culberson <lculber at mdah.state.ms.us> 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  that includes;
> ExtractValue(more_subfields_xml,
> '/collection/record/datafield[\@tag=\"999\"]/subfield[\@code=\"x\"]') as
> location
>

This looks perfect, except needs to be 952 not 999

Chris


More information about the Koha mailing list