This repository contains files and SQL snippets related to querying data from Arctos, either via the “Write SQL” tool or to format as a PDF report.
The paired .cfr +.sql files (e.g. CHAS_label_vert.cfr + CHAS_label_vert.sql) are backups of files that live in the Arctos Reporter.
The unpaired .sql files (e.g. cataloged-items-count.sql) are SQL snippets that you can copy and paste into the “Write SQL” tool to get useful information that may be difficult or impossible to find via the main Arctos search interface.
The /img directory contains images to use for the thumbnail when uploading a PDF condition report to a specimen record, as well as a copy of our logo. Erica never figured out how to embed an image into a Coldfusion Report Builder template, e.g. the CAS/PNNM logo on our loan report.
Issues for this repository are a to-do list of what needs to be done related to reporting in Arctos.
The wiki for this repository includes a few notes about working with Coldfusion Report Builder.