Writing Queries
This section of the wiki contains tips and resources for writing LDP and Metadb queries
FOLIO Data Model Documentation
- Data Dictionary (FOLIO Schema Parser)
- Diagram - ACRL Cost (in constant progress)
- Diagram - Count Cluster
- ERM-Agreements Costs - Cross-module connections
- Examples of data model changes and exchanges with developers
- Historical Reports should avoid metadata.updatedDate
- Inventory Module Documentation
General Query Writing Tips
- Building Report Prototypes and Queries (old procedure)
- DBeaver Tips and Tricks
- Non latin symbols
- Querying JSON fields in the LDP (old, unfinished)
- SQL Training Resources for Developing Queries for the LDP Analytics Repository
- Using GitHub to develop report queries for folio-analytics
Open Access Reporting
- ERM - OpenAccess derived table for charges 'openaccess_charges'
- ERM - OpenAccess derived table for checklists 'openaccess_checklists'
- ERM - OpenAccess derived table for party 'openaccess_party'
- ERM - OpenAccess derived table for publication requests 'openaccess_publication_request'
- ERM - OpenAccess derived table for works 'openaccess_works'
- Glossary
- Reports