Hi Elaine, What happens if you try SELECT itemtype, biblionumber FROM biblioitems WHERE itemtype = 'CR' - are your results any different?
Cheers, Liz On 13/11/14 14:43, Elaine Bradtke wrote: > Koha 3.16 > According to my statistical report, we have 848 biblios that are > continuing resources (BIBITEMTYPE CR) > But when I try to build a report that limits the output to these records I > get only a handful of records (these uniquely have items attached, 99% of > our CR records do not, so this information usually only appears in the > 942c). > > If I run the following report it doesn't list any entries with CR. > SELECT biblionumber, ExtractValue(marcxml, > '//datafield[@tag="942"]/subfield[@code="c"]') AS comp FROM > biblioitems > > But I can search and retrieve individual records, and they do indeed have > CR in the 942c. > > When I run an advanced search and limit it to this item type, the search > results are exactly what I expect to see. > > I can't figure out how it will count them in one instance, but not list > them in another; find them in the advanced search, but not when I query > the database with a report. . . > > We've just moved our server over to a new virtual machine and a different > version of Linux. . . Is the above a symptom of indexing problems or some > other technical glitch? > > -- -- Liz Rea Catalyst.Net Limited Level 6, Catalyst House, 150 Willis Street, Wellington. P.O Box 11053, Manners Street, Wellington 6142 GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7 _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
