For the Orchid release of FOLIO, there will be changes to updates to instance records (subjects and series) to capture changes associated with authority control.
To accommodate these changes, the FOLIO Analytics derived tables release for Orchid 1.6 will include these changes in the following derived tables:
- instance_subjects
- instance_series
Subjects:
json_extract_path_text(subjects.data, 'value') AS subject,
subjects.ordinality AS subject_ordinality
FROM inventory_instances AS instances
CROSS JOIN json_array_elements(json_extract_path(instances.data, 'subjects'))
WITH ORDINALITY AS subjects (data);
Series:
SELECT
instances.id AS instance_id,
instances.hrid AS instance_hrid,
json_extract_path_text(series.data, 'value') AS series,
series.ordinality AS series_ordinality
FROM
inventory_instances AS instances
CROSS JOIN json_array_elements(json_extract_path(instances.data, 'series'))
WITH ORDINALITY AS series (data);