hello,
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