IUG FORUM

Stay always connected!
  1. Chad Beecroft
  2. Sierra/ Millennium/ Encore
  3. Tuesday, 21 February 2017
  4.  Subscribe via email
Hi all,

Is it possible to find out if a circulation (checkout) has come from a filled hold? I don't see anything obvious in the circ_trans table. We want to try and find out how many circs come from holds for a specific portion of our patrons. Thanks.

Chad

chad.beecroft@yourlibrary.ca
Comment
  1. Chad Beecroft
  2. 3 years ago
  3. #702
Right, I used 'f' for filled holds and then looked for checkouts and renewals for the same patron, item combinations. A bit convoluted so I was wondering if there is an easier way. Thanks.

chad.beecroft@yourlibrary.ca
I think the op_code in circ_trans breaks down what type of transaction it is...

bbornheimer@sandiego.edu
There are no comments made yet.


There are no replies made for this post yet.
Be one of the first to reply to this post!