{"field": [ {"value": "30/07/2020", "FieldName": "Fields.test"}, {"value": "29/07/2020", "FieldName": "Fields.test2"} ]}
SELECT CaseRef, CaseTypeIndex,name,value FROM FieldValues, JSON_TABLE ( FieldValues.json, "$.field[*]" COLUMNS ( name VARCHAR(100) PATH "$.FieldName", value VARCHAR(100) PATH "$.value")) as Results WHERE name = 'Fields.test'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)