Page History

...

ON jsonb_extract_path_text (cf.jsonb,'id')::UUID = cft.id

         ------ I'm joining to the custom_fields__t table to show has the custom fields id, the ref_id and the custom_fields name from this table (joining to this table is not necessary, it's just a conveniencerequired – I just wanted to capture those fields in the results)

ORDER BY name, jsonb_extract_path_text (values.jsonb,'id'), jsonb_extract_path_text (values.jsonb,'value')

...