[Koha] Report help needed
Barton Chittenden
barton at bywatersolutions.com
Tue Sep 29 02:00:43 NZDT 2015
Elaine,
This query should do what you're looking for:
select biblionumber, from biblioitems where ExtractValue( marcxml,
'//datafield[@tag=942]/subfield[@code="c"]' ) = '';
Depending on the number of bibs, this could take quite a while to run -- I
would try it after hours.
Alternatively, if you have 942$c mapped in your biblio-marc mappings, you
could try querying the filed that it's mapped to, which would look a bit
like this:
select biblionumber from biblioitems where FOO is NULL;
where FOO is the column in question (FOO could conceivably be in items or
biblio... adjust the query above accordingly). This would run much faster
than the ExtractValue query.
--Barton
More information about the Koha
mailing list