>
> Aaron Z
> Jr. Systems Administrator
>
> Pioneer Library System
> 2557 State Rt. 21
> Canandaigua, New York 14424
> Phone: (585) 394-8260
>
> --
>
> *From: *"Jesse Ephraim"
> *To: *"Evergreen Discussion Group" <
>
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
ystems Administrator
Pioneer Library System
2557 State Rt. 21
Canandaigua, New York 14424
Phone: (585) 394-8260
- Original Message -
> From: "Jesse Ephraim"
> To: "Evergreen Discussion Group"
>
> Sent: Thursday, April 11, 2013 1:36:47 PM
> Subject:
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