Page History

...

Sample 1:

FROM folio_derived.instance_ext AS instext
LEFT JOIN folio_source_record.marc__t AS sm ON instext.instance_id = sm.instance_id
LEFT JOIN folio_source_record.records_lb AS rec ON sm.instance_id = rec.external_id
WHERE rec.state = 'ACTUAL' 

Here is an example of a query that uses 'ACTUAL' :

-- The query finds records that have "disk" in the call number and gets multiple fields from the marc__t table.

https://github.com/cul-it/cul-folio-analytics/tree/main/metadb/canned_reports/MCR413

...