Nope, that didn't work. How about something that will give me the biblio number and the contents of the associated 942$c? I can sort those in a spreadsheet and it might also give me a clue as to what's going on. Elaine
On Thu, Dec 15, 2011 at 12:58 AM, Chris Cormack <[email protected]> wrote: > * Elaine Bradtke ([email protected]) 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 -- Elaine Bradtke Data Wrangler 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) _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
