Thanks much, Aaron – I appreciate it! Jesse Ephraim Director, Roanoke Public Library
308 S. Walnut Roanoke, TX 76248 jephr...@roanoketexas.com 817-491-2691 From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Aaron Zsembery Sent: Thursday, April 11, 2013 1:03 PM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] SQL question You want the action.circulation table. I would use the following query: SELECT COUNT(action.circulation.id) AS Circs FROM action.circulation WHERE DATE(xact_start) BETWEEN '2012-01-01' AND '2012-12-31' AND circ_lib = XXX /*Put your library ID in here, it can be found in actor.org_unit.id*/ AND phone_renewal IS FALSE /*Remove this if you want Phone renewals to be counted*/ AND desk_renewal IS FALSE /*Remove this if you want Circ Desk renewals to be counted*/ AND opac_renewal IS FALSE /*Remove this if you want OPAC renewals to be counted*/; Aaron Z Jr. Systems Administrator Pioneer Library System 2557 State Rt. 21 Canandaigua, New York 14424 Phone: (585) 394-8260 ________________________________ From: "Jesse Ephraim" <jephr...@roanoketexas.com<mailto:jephr...@roanoketexas.com>> To: "Evergreen Discussion Group" <open-ils-general@list.georgialibraries.org<mailto:open-ils-general@list.georgialibraries.org>> Sent: Thursday, April 11, 2013 1:36:47 PM Subject: [OPEN-ILS-GENERAL] SQL question I need to count (via SQL) the number of checkout transactions that fall with 1/1/2012 and 12/31/2012. Could someone point me at the right table/fields to look at checkout transactions for my library (we are in a consortium). Thanks! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, TX 76248 jephr...@roanoketexas.com<mailto:jephr...@roanoketexas.com> 817-491-2691