13.20.0
New Features
Enhancements
Bugfixes
UPDATE audit_record SET audit_event = ( jsonb_set( audit_event::jsonb #- '{definitionId,caseDefinitionId}', '{definitionId,blueprintId}', jsonb_build_object( 'blueprintType', 'CASE', 'blueprintKey', audit_event->'definitionId'->'caseDefinitionId'->>'key', 'blueprintVersionTag', audit_event->'definitionId'->'caseDefinitionId'->>'versionTag' ) ) )::json WHERE audit_event::jsonb->'definitionId'->'caseDefinitionId' IS NOT NULL;UPDATE audit_record SET audit_event = JSON_REMOVE( JSON_SET( audit_event, '$.definitionId.blueprintId', JSON_OBJECT( 'blueprintType', 'CASE', 'blueprintKey', JSON_UNQUOTE(JSON_EXTRACT(audit_event, '$.definitionId.caseDefinitionId.key')), 'blueprintVersionTag', JSON_UNQUOTE(JSON_EXTRACT(audit_event, '$.definitionId.caseDefinitionId.versionTag')) ) ), '$.definitionId.caseDefinitionId' ) WHERE JSON_EXTRACT(audit_event, '$.definitionId.caseDefinitionId') IS NOT NULL;
Last updated