Daily Archives: October 21, 2014

Using variables in Koha Reports 3

Today’s guest post comes from Christopher Brannon at Cooperative Information Network (CIN). Christopher asked us if there was a way to not have enter the date 2 times in a report like this one: SELECT ai.location AS ‘Shelf Location’, COUNT(ai.dateaccessioned) AS ‘Count’ FROM (SELECT dateaccessioned, homebranch, location, timestamp FROM items […]