This repository stores shared queries designed to produce reports of FOLIO data in a local LDP instance. These queries have been developed by the FOLIO reporting community. For more information about FOLIO reporting, see the FOLIO Reporting SIG.
You can find queries by browsing the subfolders in this folder or by reviewing the Query Table of Contents below.
In the folder for each query, you should see an .sql file and a README file, or perhaps multiple .sql files.
The README file summarizes the purpose, output, and special instructions of the query.
The .sql file contains the SQL code for the query. You can copy and paste the content of this file into the reporting tool of your choice (or download the file and open it in the tool).
While some queries may be designed to use only tables in the public schema of the LDP (that is, the tables populated directly with FOLIO data), other queries rely on our derived tables. The derived tables simply the data architecture of the public schema, making FOLIO data much easier and more efficient to query. To make sure the report queries are using current FOLIO data, all derived table queries should be scheduled to run automatically and regularly, perhaps using a nightly Cron job.