Michal Krawczyk
12/12/2025, 11:02 AMMichal Krawczyk
12/12/2025, 11:22 AMSELECT
attempts.status,
attempts.failure_summary,
attempts.output->'sync'->'failures'->0->'failureType' AS failureType,
attempts.output->'sync'->'failures'->0->'failureOrigin' AS failureOrigin,
attempts.output->'sync'->'failures'->0->'externalMessage' AS externalMessage,
attempts.output->'sync'->'failures'->0->'internalMessage' AS internalMessage
FROM attempts
WHERE JSONB_ARRAY_LENGTH(attempts.output->'sync'->'failures') > 0
AND attempts.status != 'failed'