[Koha] Koha - query for biblioitems marc
lculber at mdah.state.ms.us
Fri Aug 24 02:39:28 NZST 2012
That did the trick! Thank you!
> Re: [Koha] Koha - query help needed for bilblioitems.marc
> Galen Charlton <gmc at esilibrary.com>
> 8/22/2012 10:27 AM
> koha at lists.katipo.co.nz
> Hi Linda,
> On 08/22/2012 10:51 AM, Linda wrote:
>> I need to find records having a 773 field that are missing either a
>> subfield "9". or a subfield "o"..
>> I'm at a loss of how to accomplish this. Any input would be
>> Thanks in advance.
> This should do the trick:
> SELECT biblionumber
> FROM biblioitems
> WHERE marcxml RLIKE '<datafield tag="773"'
> AND ExtractValue(marcxml, '//datafield[@tag="773"]/subfield[@code="9"
> or @code = "o"]/text()') = '';
Linda Culberson lculber at mdah.state.ms.us
Miss. Dept. of Archives and History
Archives& Records Services
P.O. Box 571
Jackson, MS 39205-0571
Phone: (601) 576-6873
More information about the Koha