[Koha] Koha - query help needed for bilblioitems.marc
gmc at esilibrary.com
Thu Aug 23 03:43:47 NZST 2012
On 08/22/2012 11:27 AM, Galen Charlton wrote:
> 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()') = '';
By the way, this query will return all bibs that lack *both* of those
subfields. This variant returns bibs that lack one or the other:
WHERE marcxml RLIKE '<datafield tag="773"'
'//datafield[@tag="773"]/subfield[@code="9"]/text()') = ''
'//datafield[@tag="773"]/subfield[@code="o"]/text()') = ''
This isn't perfect, though -- if a record has multiple 773 fields, and
one of them has the required subfields while the others do not, it won't
be included in the query results.
Director of Support and Implementation
Equinox Software, Inc. / The Open Source Experts
email: gmc at esilibrary.com
direct: +1 770-709-5581
cell: +1 404-984-4366
Supporting Koha and Evergreen: http://koha-community.org &
More information about the Koha