Page History

...

   jsonb_extract_path_text (values.jsonb,'value') AS value_name
           ------ because "values" is a jsonb object (produced by the cross join below), we need to use json extract statements in "Select" to get the value id and the value name from "values"
           ------ the shorthand way to get the same "id" and "value" extracts is by using the "#>>" operator: 
                      values.jsonb #>> '{id}'
                      values.jsonb #>> '{value}'

FROM folio_users.custom_fields AS cf

...