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);



  • No labels