Re: [Koha] Report help needed

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