Table storing Tracker datavalues

Support - Assistance technique
9

This worked for me:

SELECT data.key as de_uid,
cast(data.value::json → ‘value’ AS VARCHAR) AS de_value
FROM programstageinstance psi
JOIN json_each_text(eventdatavalues::json) data ON TRUE

2 Likes