[Koha] Collection Code Totals

[Chris Cormack]

* Kerrie Stevens (KStevens at harvest.edu.au) wrote:
> I am trying to run a report to give me the total number of items within each of our collection codes (we have 5) at each branch but I can only get it show me the results from one of them... can anyone see where I'm going wrong?
> 
> SELECT count(ccode), ccode AS collection
>   FROM items
>    WHERE items.homebranch='VIC'
>   ORDER BY items.dateaccessioned DESC
> 
> I have looked through the Reports Library but can't find anything to do this. I've tried to adapt others but without any luck.
> 

Id try

SELECT count(ccode), ccode AS collection, homebranch
FROM items
GROUP BY homebranch,ccode

That should give you the count per code, per branch

(Note I haven't tested this, just typed it into the mail client, so
beware typos)

Chris

> Any help is much appreciated.
> 
> Thank you,
> 
> Kerrie Stevens
> 
> 
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand