Submission Notes: This report was submitted on 5/24/10 by Amy Terlaga of Bibliomation, Inc. It was created by Dan Scott of Laurentian University.

Version: Evergreen v.1.6.0.2 Data Sources Used: Running Tips/Guidelines: This report is perfect for consortium/library staff to assist in testing purposes. It will provide a representative item barcode per circulation modifier in the Evergreen system so that circulation rules can be tested.

You do not need to change anything in this report to run it.

SELECT aou.shortname, ac.circ_modifier, MAX(ac.barcode)

FROM asset.copy ac 
  INNER JOIN actor.org_unit aou ON ac.circ_lib = aou.id
WHERE ac.deleted IS FALSE
GROUP BY aou.shortname, circ_modifier
ORDER BY aou.shortname, ac.circ_modifier ;

Back to Evergreen SQL Report Submissions main page