#sql
Read more stories on Hashnode
Articles with this tag
select w.code, w.message, COUNT(*) from (SELECT io.iologEntryId, JSON_VALUE(payload, '$.envelope.error.code') as code, JSON_QUERY(payload,...
Assuming your table is named error_log and the column containing the JSON string is error_data, and the JSON structure is like this: { "error_code":...