ERM - Add new tables for refdata to derived table "agreements_custom_property"

folio-org / folio-analytics

Community query repository for FOLIO analytics based on Metadb/LDP

Apache License 2.0

13 stars 30 forks source link

ERM - Add new tables for refdata to derived table "agreements_custom_property" #792

Open stdombek opened 1 year ago

stdombek commented 1 year ago

There are new additional tables that need to be added to the derived table agreements_custom_property.

"custom_property_refdata" with their "refdata_value"

agreements_custom_property
LEFT JOIN folio_agreements.custom_property_refdata ON custom_property_refdata.id = agreements_custom_property.id
LEFT JOIN folio_agreements.refdata_value ON refdata_value.rdv_id = custom_property_refdata.value_id

kitokirti commented 1 year ago

Hi @stdombek , I would like to work on this. Please assign this to me.