*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
Then you would add a line in the Select stanza to show the ordinality:
values.ordinality AS custom_fields_ordinality
RESULT:
Extracting an array that is at the top-most level in a table
Sometimes you want to extract an array that is at the top-most hierarchical level of a table – that is, it is not embedded within any other object. An example of this is "departments" element in the folio_users.users table:
