2019-08-19 RPWG Meeting notes

Date

12 Aug 2019

Attendees

Discussion items

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

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