Page Comparison

Angela will provide a walk through of using PostgreSQL's JSON query syntax on mirrored FOLIO JSON data in the LDP to generate the query for the following report prototype

• Circ Item Detail:https://wiki.folio.org/display/RPT/Circulation+Item+Detail+Report+Prototype

Prototyping

-note whether or not we are aggregating

-note where there are filters

Writing the S

Shall we build these reporting data models next?

1. Circ Item Detail:https://wiki.folio.org/display/RPT/Circulation+Item+Detail+Report+Prototype
2. Services Usage:https://wiki.folio.org/display/RPT/Services+Usage+Report+Prototype
3. Shelf List Location: https://wiki.folio.org/display/RPT/Shelf+List+Location+Report+Prototype

Questions:

• What do RPWG members think of these (above) as our current highest priorities?
• Would the prototype developers like to develop the SQL queries for each of these?

Future Topics:

• Definition of "all FOLIO data" required for inclusion in the LDP.
• Evaluate the data model of the LDP's MARC implementation.
• Identify representative report queries on MARC records.

Next meeting date:

Demonstration of how to contribute a new SQL report query--or a modification of an existing query--using the shared community space in GitHub that has been set up for this purpose.

Refer to Contributing report queries to ldp-analytics for written instructions.