evergreen-reports:item_reports

This is an old revision of the document!

Table of Contents

ITEM REPORTS
- Item List Reports
  - Sample Item Barcode from each Circulation Modifier
- Item Statistical Reports

ITEM REPORTS

Item List Reports

Sample Item Barcode from each Circulation Modifier

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 ;

Item Statistical Reports

Back to Evergreen SQL Report Submissions main page

evergreen-reports/item_reports.1274731868.txt.gz · Last modified: 2022/02/10 13:33 (external edit)