[OPEN-ILS-GENERAL] SQL question

2013-04-11 Thread Jesse Ephraim
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.

Re: [OPEN-ILS-GENERAL] SQL question

2013-04-11 Thread Aaron Zsembery
: [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

Re: [OPEN-ILS-GENERAL] SQL question

2013-04-11 Thread Jesse Ephraim
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

Re: [OPEN-ILS-GENERAL] SQL question

2013-04-11 Thread Rogan Hamby
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