[Koha] Additonal help needed on ciruclation report

[Scott Zollars]

The Circulation report that I requested help on is progressing, thanks
to everyone who contributed help. This one is for daily circ but could
also be adapted for monthly. I obviously am still having trouble with my
Biographies (B) and Fiction (F). On this day, we had one biography and
two fiction checked out. I have no idea where the other numbers are
coming from.

 

Currently my squl is as follows. I have cut and pasted and tried
different variations that in my mind should work. So, I am back to have
the collective eye tell me the obvious thing that I am missing.

 

SQUL

select substring(itemcallnumber,1,1) as 'Call# range', count(*) from
items, statistics where statistics.itemnumber = items.itemnumber and
type in ('issue', 'renew') and date(datetime) between '2009-07-09' and
'2009-07-09'  and itemcallnumber is not null and length(itemcallnumber)
and substring(itemcallnumber,1,1) between '0' and '9' or
substring(itemcallnumber,1,1) = 'F' or substring(itemcallnumber,1,1) =
'B' group by substring(itemcallnumber,1,1)

 

This results in the following. Everything is fine but the F's and B's

CIRC

Total number of rows matching the (unlimited) query is 1.

Call# range

count(*)

0

1

1

1

7

1

B

145321

F

225423

 

Scotty Zollars

Director of Library Services

Labette Community College

200 S. 14th

Parsons, KS  67357

620-820-1168

620-421-1469 FAX

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090713/16f37023/attachment.htm