*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
jsonb_extract_path_text (jsonb_array_elements (jsonb_extract_path (cf.jsonb, 'selectField', 'options', 'values')),'value') AS value_name
---- for value_id and value_name, you can ALSO use:
---- values.jsonb #>> '{id}' as value_id,
---- values.jsonb #>> '{value}' as value_name
FROM folio_users.custom_fields AS cf
...
jsonb_extract_path_text (values.jsonb,'value') AS value_name
---- for value_id and value_name, you can ALSO use:
---- values.jsonb #>> '{id}' as value_id,
---- values.jsonb #>> '{value}' as value_name
FROM folio_users.custom_fields AS cf
...