/
Writing Queries
Writing Queries
- Sharon Markus
- Tod Olson
- Angela Zoss (Old)
Owned by Sharon Markus
Last updated: Oct 04, 2021 by Tod OlsonVersion comment
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
, multiple selections available,
Related content
Query search examples
Query search examples
More like this
Build Metadb query cookbook-style documentation
Build Metadb query cookbook-style documentation
More like this
2023-10-23 Meeting notes: Query builder in LDP Reporting App
2023-10-23 Meeting notes: Query builder in LDP Reporting App
More like this
SQL Training Resources for Developing Queries for the LDP Analytics Repository
SQL Training Resources for Developing Queries for the LDP Analytics Repository
More like this
DBeaver Tips and Tricks
DBeaver Tips and Tricks
Read with this
Benefits of Metadb
Benefits of Metadb
More like this