...
To export all form contents as JSON, create a column in a case export file with a "Source Field" of "form" and a data type column set to "json".
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".
...
| 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" |
Next Page: DET and CommCare Sync >
| Page Tree | ||
|---|---|---|
|