Change the way data stored in JSON inside table in logger_instance


we have kobo server and i have access to the schemas using Navicat

since the JSON data is stored in table: logger_instance under the kobocat schema

the select-multiple questions is storing only the answers as space separated values, meanwhile the options are extracted as 0s and 1s in separate columns

is possible to include the values in separate columns in the JSON too?

my goal is to migrate the data as it is from the json with the 1s and 0s columns included instead of manually generating them using the query/view/trigger

thanks in advance

1 Like

thank you for your reply but how can i update the Data Processing Point?