Okay - now here's the new issue - the grand total does not show:
SELECT IFNULL(a.lib,'*GRAND TOTAL*') as Location, thingy.circs AS
Circulations FROM (select i.location as loction, count(s.datetime) as
circs from statistics s left join items i using (itemnumber) left join
borrowers p using
Here's a thought, it might be an error in the authorized values., and I
think it is a bug
I recreated it on our system by adding an authorized_value in a different
category with the same value as one in the LOC:
i.e.
I added AFIC to our Vendor category, with description Error! The system
doesn't
Nick,
I figured it out - we needed to limit to LOC authorized values:
SELECT IFNULL(a.lib,'*GRAND TOTAL*') as Location, thingy.circs AS
Circulations FROM (select i.location as loction, count(s.datetime) as
circs from statistics s left join items i using (itemnumber) left join
borrowers p using
Ah, I see now, not a bug, I thought the duplicate authorised_values weren't
showing up, they were just filing odd because I was using test values and
not sorting.
On Tue, Mar 25, 2014 at 4:03 PM, Nicole Engard neng...@gmail.com wrote:
Nick,
I figured it out - we needed to limit to LOC
It looks like there isn't a direct way to do that, see
herehttp://stackoverflow.com/questions/12940119/mysql-change-last-row-of-rollup,
but you can wrap the query up and join it to authorised values and make it
work with the caution that any circs without location defined will also end
up labeled
Thank you so much Nick!!
Nicole
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
Okay, any idea why the Juveasy might be showing 2 times?
http://screencast.com/t/6dbByW4eZ
I added the location code in case that was it - they're identical as
are their numbers.
On Thu, Mar 20, 2014 at 1:50 PM, Nicole Engard neng...@gmail.com wrote:
Thank you so much Nick!!
Nicole
7 matches
Mail list logo