2019-08-19 RPWG Meeting notes

Attendance

Update Attendee List

Action Items

Review and update Action Items

Angela

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://folio-org.atlassian.net/wiki/display/RPT/Circulation+Item+Detail+Report+Prototype

Prototyping

-note whether or not we are aggregating

-note where there are filters

-good documentation helps a lot

Writing the Queries

-need to understand the prototype

-need to be sure the right data is there

Documentation

-Angela will add documentation on query writing to the Reporting SIG wiki

-a style guide for 

Key Changes for Moving from Star-Schema to JSON Syntax

-straight FOLIO tables require more joins

-FOLIO

-hierarchy 

API Documentation

-need to know how tables join

JSON Syntax Documentation

• see http://www.postgresqltutorial.com/postgresql-json/

Possibility of Adding Views

-pre built queries

-query against the views instead of the tables

Follow-ups

-need to update connecting documentation in the Reporting SIG wiki for the LDP

Skills

-getting familiar with JSON Extract function

Tools

-Schema Spy

-PGP Admin

Clusters

Next Reporting Data Models to Deliver

All

Shall we build these reporting data models next?

1. Circ Item Detail: https://folio-org.atlassian.net/wiki/display/RPT/Circulation+Item+Detail+Report+Prototype

2. Services Usage: https://folio-org.atlassian.net/wiki/display/RPT/Services+Usage+Report+Prototype

3. Shelf List Location: https://folio-org.atlassian.net/wiki/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?

For our next meeting...

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:

Using GitHub for developing SQL report queries

Nassib

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 Using GitHub to develop report queries for folio-analytics for written instructions.