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.
: [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
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
Canandaigua, New York 14424
Phone: (585) 394-8260
--
*From: *Jesse Ephraim jephr...@roanoketexas.com
*To: *Evergreen Discussion Group
open-ils-general@list.georgialibraries.org
*Sent: *Thursday, April 11, 2013 1:36:47 PM
*Subject: *[OPEN-ILS-GENERAL] SQL question
I