...
To export all case properties as JSON, create a column in a case export file with a "Source Field" of "properties" and a data type column set to "json".
This data can then be queried using Postgres JSON queries. For example:
| Code Block | ||
|---|---|---|
| ||
select form->'@name' as form_name, form->'meta'->'username' as username, form->'meta'->'timeStart' as time_start from form_lake limit 5;
form_name | username | time_start
-------------+-------------------+-------------------------------
"New Event" | "alice" | "2017-06-24T16:24:07.676000Z"
"New Event" | "bob" | "2017-07-02T13:43:52.655000Z"
"New Event" | "chelsea" | "2017-07-04T07:51:12.528000Z"
"New Event" | "daniel" | "2017-07-09T06:10:48.591000Z"
"New Event" | "edith" | "2020-04-02T05:58:11.712000Z"
|