* Elaine Bradtke (eb@efdss.org) wrote:
The problem: I need to batch edit a group of biblios, but first I have to find them and extract a list of their biblio numbers. All the biblios in question have a common trait: their 942$c is Components They also do not have item records
But I can't seem to create a report that will do this (my grasp of the whole report function is rather feeble). Any advice?
Now for the inevitable weirdness:
I know there are over 70 biblios with Components in the 942$c field.
I created a report that lists all the biblionumbers and itemtypes. The only Components that report produced were ones that had been manually entered. Not the 70+ that came in via a bulk import. If I search for the items individually by title, etc. they are there and appear to be normal records. If I try to limit an advance search to Components, it draws a blank. Which makes me think there's something fishy going on somewhere. But where to look?
Hi Elaine I bet the ones imported just have the data in the marcxml field, so in order to find them you would use some sql like SELECT biblionumber FROM (SELECT biblionumber, ExtractValue(marcxml, '//datafield[@tag="942"]/subfield[@code="c"]') AS comp FROM biblioitems) as comptable WHERE comp="Components"; Try that and see if you get at least 70 biblionumbers back One caveat, your mysql server needs to be running at least 5.1.5 for this query to work (most modern installs will be) Hope this helps Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand