Submission Notes: This report was created on 6/15/10 by Ben Shum, Bibliomation on behalf of Mike Peters, Evergreen Indiana.
Version: Evergreen 2.0.6
Data Sources Used:
Running Tips/Guidelines: This report was designed to show hold transits from libraries that do not share the same parent branch.
SELECT aou.name, COUNT(ac.id) FROM action.hold_transit_copy ac INNER JOIN actor.org_unit aou ON aou.id = ac.source INNER JOIN actor.org_unit aou2 ON aou2.id = ac.dest WHERE aou2.parent_ou != aou.parent_ou GROUP BY aou.name ORDER BY 2 DESC;
Back to Evergreen Circulation Reports page