Daily Circulation Statistical Reports

Submission Notes: This report was submitted on 5/14/10 by Amy Terlaga of Bibliomation, Inc. It was originally created by Dan Scott of Laurentian University.

Version: Evergreen v.1.6.0.2

Data Sources Used:

Running Tips/Guidelines: This report is designed to be run the day AFTER the day you are interested in getting daily circulation totals. If you would like it to reflect today's activity, remove - '1 day'::interval If you would like it to reflect activity from two days ago, change the 1 to a 2 (and so on). Where you see ORG, replace with your org unit's short name.

SELECT copy_location.name, COUNT(circulation.id) AS COUNT
   FROM action.circulation
   JOIN actor.org_unit ON circulation.circ_lib = org_unit.id
   JOIN asset.copy ON copy.id = circulation.target_copy
   JOIN asset.copy_location ON copy.location = copy_location.id
  WHERE org_unit.shortname = 'ORG'::text AND date_trunc('DAY'::text, circulation.create_time) = date_trunc('DAY'::text, now() - '1 day'::INTERVAL)
  GROUP BY copy_location.name
UNION 
 SELECT 'ZZZ Total' AS name, COUNT(circulation.id) AS COUNT
   FROM action.circulation
   JOIN actor.org_unit ON circulation.circ_lib = org_unit.id
   JOIN asset.copy ON copy.id = circulation.target_copy
   JOIN asset.copy_location ON copy.location = copy_location.id
  WHERE org_unit.shortname = 'ORG'::text AND date_trunc('DAY'::text, circulation.create_time) = date_trunc('DAY'::text, now() - '1 day'::INTERVAL)
  ORDER BY 1;

Back to Evergreen Circulation Reports page