Page tree
Skip to end of metadata
Go to start of metadata

Date

Attendees

Discussion items

ItemWhoNotes
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


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


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 DeliverAll

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?
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 queriesNassib

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.


Action items

  •  Angela to work with small group to look at Resource Access clusters
  •  Sharon to work with small group to look at Resource Management clusters