Page Comparison

Date

05 Oct 2020

...

Item	Who	Notes
Attendance & Notes	Sharon	Attendance & Notes Today's attendance-taker: Linda Miller Today's note-takers: Team Leads for project updates
Update from Tod on Jira ranking conversions	Tod?	Please note that JIRA rankings for UXPROD and REP issues were converted by Holly to the new ranking system R1 (urgent) to R5 (not needed). Update from Tod on JIRA ranking conversions? See Implementation Group 2020-09-22 Meeting notes. See Ranking JIRA Issues page in wiki for recent updates Reminder: As of 2020, the Reporting SIG is only ranking reporting cluster issues, such as "UXPROD-2029 RA-Requests Cluster." You can find report clusters by using the label "report-cluster" in your JIRA search. Individual report requirements are captured in JIRA issues that start with "REP," such as "REP-275 Curbside Pickup Report."
Abbreviation List	Tod Olson	Tod et al. will draft a proposed list of standard abbreviations for naming https://docs.google.com/document/d/16gIDaslANA93u6AiPbigmge82Rl1SL8H3qRBah0R0OY/edit?usp=sharing
Updates from Various Reporting Related Groups and Efforts	Community & Coordination, Reporting Subgroup Leads	Project updates The Reporting SIG is using small working groups to address priorities and complete our work. Each week, we will provide updates to the Reporting SIG from these various reporting-related groups and efforts. Please include updates on specific JIRA issues for prototype or query development workflow. Additional JIRA tickets for Angela to create for prototypes or queries ? Community & Coordination: reporting survey entries are complete! Aliasing for reports Questions Should we remove WITH clauses in our derived table queries? may or may not be used, case by case FOLIO Reporting development The derived table spreadsheet: https://docs.google.com/spreadsheets/d/1GL5XssOJaBMuKOrM0H_0lhht0G4ApDNr72SVLGV0JT0/edit?usp=sharing This is now superseded by issues in GitHub: https://github.com/folio-org/folio-analytics/issues This week: query development groups take another look at what additional tables may be needed to support ad hoc querying Draft starter list of proposed column names important to keep using the "json_extract_path_text()" latest model queries for using JSON arrays https://github.com/folio-org/folio-analytics/tree/master/sql/derived_tables JSON array examples: https://github.com/library-data-platform/ldp/blob/master/doc/User_Guide.md#7-json-arrays RA/UM Working Group RA/UM derived table demo rows 25, 28, 29 shown so far MM Working Group MM derived table demo changing queries to remove the WITH and to use CROSS JOIN demo of holdings_electronic_access_v2 (in progress) ERM Working Group identifying derived tables in agreements and knowledge base Khalilah Gambrel will attend the next ERM meeting to find out how eHoldings data can be loaded in LDP verifying the latest reports ranking (rank renaming) to match with the current development roadmapdiscussion about what ERM data come from what storage (diagram) two approaches of getting eHoldings data to get in use for reporting eHoldings app to be enhanced to provide the data for reporting LDP will be enhanced to pull in the data out of eHoldings for latest updates, see ERM Prototype and Query Development Status RM Working Group for latest updates, see RM Prototype and Query Development Status RM Derived Table demos rows 11, 21 shown so far demo of local.invoice_lines_fund_distributions, needs to be updated for the new way to extract json arrays WITH allows you to create a subquery (intermediate table "funds_distr" is created); locally-scoped table that exists for External Statistics Working Group Recategorize External Statistics REP Issues
Topics for Future Meetings	All	Review and update Topics for Future Reporting SIG Meetings

...

Versions Compared

Old Version 5

New Version 6

Key

Date