*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
-
Created by
Sharon Helen Markus, last updated on Jul 29, 2024
1 minute read
This page provides a list of each of the SQL query directories created and maintained by the CUL FOLIO Reporting Team to support CUL staff reporting needs. "Canned" reports are queries that can be used with multiple parameters (e.g., locations, fiscal years, item statuses, etc.) to generate reports that use those different parameters to limit the results set. "Ad Hoc" reports are "one-off" queries written to generate a specific results set without providing different parameters.
| Directory | Description |
|---|---|
| Metadb Canned Report SQL Query Directory | Canned report SQL queries written to run on the Metadb reporting database |
| Metadb Ad Hoc Report SQL Query Directory | Ad Hoc report SQL queries written to run on the Metadb reporting database |
| LDP Canned Report SQL Query Directory | Canned report SQL queries written to run on the LDP reporting database |
| LDP Ad Hoc Report SQL Query Directory | Ad Hoc report SQL queries written to run on the LDP reporting database |
| LDP Archive SQL Query Directory | Archive of SQL queries written to run on the LDP reporting database that are no longer actively used and maintained |
| Using the CUL FOLIO Analytics Report Repository | instructions for accessing and using queries on the Cornell Library's FOLIO Analytics report repository, a GitHub repository of SQL report queries and documentation written for the Cornell Library |