Page History

...

Extracting "First Level" Data Fields 

In the code below, 'itempatron_status' is a "first level" jsonb field. In the JSON data array in this table, the main field 'status' has only one subfield (one possible value). The data field is extracted from the folio_users.users __ table because this table contains JSON data array where that field exists (this field is not available in the users__t "transformed" table). Note that the folio_users.The "users" table is in the Partition subfolder under "users__t". The partition table only contains "current" versions of the records, while the "users__ table has 2 underscores at the end of its name." table contains current and archive versions of the records. (You generally want just current records for queries.)

SELECT
     folio_users.users__.id AS user_id,
     jsonb_extract_path_text (folio_users.users__ .jsonb,  'status') AS item AS patron_status,
FROM folio_users.users__

Extracting "Second Level" Data Fields

...