Hi,
The live page on the conference website is now up:
http://eg2013.evergreen-ils.org/live/
You'll find the Twitter feed (conference hashtag is #egcon2013), notes from
our live note takers and video. The main track is being recorded and we
hope to post the video in a few weeks. The tech track
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.
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*/
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
Additionally if you're in a system in a consortium (versus single library)
you may want not just for one library but for your library system you may
want to make a join and go by parent org ie...
SELECT COUNT(action.circulation.id) AS Circs
FROM action.circulation circ
JOIN actor.org_unit org
Hi all,
Here in our consortium, we've used Join.me (www.join.me) with pretty good
success as well as Google Hangouts for group training. Join.me is great
for one on one training as well as remote desktop support. Google Hangouts
is a great alternative to more traditional webinar-type software,