*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
In the meantime, you can use the record state of 'ACTUAL' as a workaround to make sure you are getting accurate record counts when you are using the folio_source_record.marc__t table.
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'
...
:
https://github.com/cul-it/cul-folio-analytics/tree/main/metadb/canned_reports/MCR413
...