[OPEN-ILS-GENERAL] SQL Help - Item Count by Location/Collection

Jason Etheridge jason at esilibrary.com
Thu Dec 10 12:59:02 EST 2009

> Both seemed to yield the same results, so what's the difference when it
> comes to item count?

It's possible for an item to have a circ lib that differs from the
copy location (shelving location) owning lib, especially in the
context of rotating collections.  Likewise, the owning lib on the
asset.call_number could also be different.

Jason Etheridge
 | VP, Tactical Development
 | Equinox Software, Inc. / The Evergreen Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  jason at esilibrary.com
 | web:  http://www.esilibrary.com

Please come by and visit the Equinox team
and learn more about Evergreen
ALA MidWinter
January 15-18, 2010
booth # 2064

More information about the Open-ils-general mailing list