*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
When extracting arrays embedded in text objects, it's usually best to use a "cross join lateral" statement in the FROM stanza. This cross join creates a "json object" that can then be further extracted in the Select stanza.
...
------ the custom_fields__t table has the id, the ref_id and the custom_fields name (joining to this table is not required – I just wanted to capture include those fields in the results)
...