evergreen-reports:sql:item
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
evergreen-reports:sql:item [2015/06/12 11:20] – roganh | evergreen-reports:sql:item [2022/02/10 13:34] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 76: | Line 76: | ||
GROUP BY aou.shortname, | GROUP BY aou.shortname, | ||
ORDER BY aou.shortname, | ORDER BY aou.shortname, | ||
+ | </ | ||
+ | |||
+ | |||
+ | ==== Sample Item Barcode from each Circulation Modifier and Org Unit ==== | ||
+ | |||
+ | **Submission Notes:** | ||
+ | This report was submitted on 6/12/2015 by Rogan Hamby of SC LENDS. It was created by Rogan Hamby. | ||
+ | |||
+ | **Version**: | ||
+ | |||
+ | **Data Sources Used**: | ||
+ | |||
+ | **Running Tips/ | ||
+ | |||
+ | <code sql> | ||
+ | |||
+ | SELECT DISTINCT ON (ac.circ_modifier, | ||
+ | FROM asset.COPY ac | ||
+ | JOIN asset.copy_location acl ON acl.id = ac.LOCATION | ||
+ | JOIN actor.org_unit aou ON aou.id = ac.circ_lib | ||
+ | JOIN actor.org_unit paou ON paou.id = aou.parent_ou | ||
+ | WHERE ac.deleted = FALSE AND ac.status IN (0,7) AND ac.circulate = TRUE AND acl.circulate = TRUE AND aou.ou_type = 3 | ||
+ | UNION ALL | ||
+ | SELECT DISTINCT ON (ac.circ_modifier, | ||
+ | FROM asset.COPY ac | ||
+ | JOIN asset.copy_location acl ON acl.id = ac.LOCATION | ||
+ | JOIN actor.org_unit aou ON aou.id = ac.circ_lib | ||
+ | JOIN actor.org_unit paou ON paou.id = aou.parent_ou | ||
+ | WHERE ac.deleted = FALSE AND ac.status IN (0,7) AND ac.circulate = TRUE AND acl.circulate = TRUE AND aou.ou_type = 5 | ||
+ | ; | ||
</ | </ | ||
Line 117: | Line 147: | ||
Back to [[evergreen-reports: | Back to [[evergreen-reports: | ||
- |
evergreen-reports/sql/item.txt · Last modified: 2022/02/10 13:34 by 127.0.0.1