Report help needed
We have one record in the catalogue that is missing a 942 $c. but I can't find it. I'm looking for a 942$c that is empty. If I could get the biblio number of the problem record, I could fix it. Thanks in advance -- Elaine Bradtke VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
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
participants (2)
-
Barton Chittenden -
Elaine Bradtke