*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
SELECT
folio_users.users__.id,
jsonb_extract_path_text (users__ .jsonb, 'personal', 'lastName') AS requestor_last_name,
jsonb_extract_path_text (users__ .jsonb, 'personal', 'firstName') AS requestor_first_name
FROM
folio_users.users__
The following expression will also get "lastName" and "firstName":
SELECT
folio_users.users__.id,
users__ .jsonb #>> '{personal, lastName}' AS requestor_last_name,
users__ .jsonb #>> '{personal, firstName}' AS requestor_first_name
FROM
folio_users.users__
Extracting "Third level" Data Fields
...