[Koha] Report filtered by item type fails

[Liz Rea]

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