[Koha] Report help needed 999$c

Elaine Bradtke eb at efdss.org
Tue May 6 09:55:08 NZST 2014


 I've got something that extracts the biblio numbers from the 999c. Is
there any way to ask it to only show the ones that contain multiple 999c?


SELECT biblionumber, ExtractValue(marcxml,
'//datafield[@tag="999"]/subfield[@code="c"]') AS comp FROM
biblioitems

-- 
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)


More information about the Koha mailing list