Versions Compared

Old Version 4

changes.mady.by.user Sharon Helen Markus

Saved on

compared with

New Version 5

changes.mady.by.user Sharon Helen Markus

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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_hrid = rec.external_hrid
WHERE rec.state = 'ACTUAL' 
Sample 3:
FROM folio_source_record.marc__t
LEFT JOIN folio_source_record.records_lb on cast (folio_source_record.marc__t.srs_id as UUID)
    = folio_source_record.records_lb.id
WHERE
folio_source_record.records_lb.state = 'ACTUAL'

...



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

https://github.com/cul-it/cul-folio-analytics/tree/main/metadb/canned_reports/MCR413https://github.com/cul-it/cul-folio-analytics/tree/1a2621f867e24c219d0edae1d96cd3730cfc9205/metadb/canned_reports/MCR406