search

folio-org / folio-analytics

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

ACQ/ERM - Update derived table agreements_package_content_item #836

Closed stdombek closed 3 weeks ago

stdombek commented 3 months ago

The derived table agreements_package_content_item needs an update. The relationship between the title_instance and identifier_occurrence tables has changed.

Old:

title_instance
LEFT JOIN identifier_occurrence ON identifier_occurrence.io_ti_fk = title_instance.id

New:

title_instance
LEFT JOIN identifier_occurrence ON identifier_occurrence.io_res_fk = title_instance.id