Re: [Koha] Report help needed 999$c

2014-05-05 Thread Elaine Bradtke
"Note that it looked like your data also had multiple entries in one 999 $c field, separated with '|'. That's weird, and this won't find that. On the other hand, you can just do "WHERE field LIKE "%|%"" to catch those." Yes, that is weird. I'm trying to figure out where it is coming from. In a fe

Re: [Koha] Report help needed 999$c

2014-05-05 Thread Robin Sheat
Elaine Bradtke schreef op ma 05-05-2014 om 22:55 [+0100]: > 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