folio-org / folio-analytics

Community query repository for FOLIO analytics based on Metadb/LDP
Apache License 2.0
15 stars 30 forks source link

Create Metadb report to simulate LDP table po_receiving_history #826

Open nassibnassar opened 4 months ago

nassibnassar commented 4 months ago

Joanne Leary wrote:

Hi everyone - I am trying to convert an LDP query to Metadb, and one of the tables has no Metadb equivalent. The table is "po_receiving_history" (public table). I need to get the last issue received and the date received. Any suggestions for where this data is found in Metadb?

Later Joanne found the fields she needed in folio_orders.pieces__t

This issue is to propose creating a community report that would simulate as much of po_receiving_history as possible by combining data from Metadb tables.