*** 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 ---- this expression specifies the PATH necessary to get the last field entered in the path; the result is a json object and will be enclosed in double-quotes
- jsonb_extract_path_text ---- this expression does the same thing as jsonb_extract_path, but returns a TEXT object (no quotes)
- jsonb_array_elements ---- this expression is used for extracting values within an array object
- table_name_or_alias.jsonb #>> '{path_of_fields_in_the_hierarchy_separated_by_commas}'
- Example: audit_loan.jsonb #>> '{loan, metadata, updatedByUserId}' — this will get the value for "updatedByUserId"
...