Hello. I see that when you use a multichoice variable it splits that
variable into its own table. I like the way that the Aggregator displays
the values as a single variable with commas between each value. Can you
share the SQL code that you used to do this?
Thanks!
Alex
This question and other technical questions like it should be asked on the
opendatakit-developers@ list.
Aggregate has a data modeling layer that maps the flat submission XML
document into a database structure, including, as you note, the
splitting-out of multiple-choice questions into separate rows for each
choice, each in a separate table associated with the main survey table.
This is largely to enable data visualization and data filtering features.
When it comes to display, we first reconstruct an entire Submission object
from these underlying SQL tables; each Submission object corresponds to the
original flat submission XML document. The code then uses a Visitor pattern
to traverse the Submission to apply a formatter that produces the display
values you see.
Given that description, what are you interested in? (and please move this
thread to opendatakit-developers@)
Mitch
Hello. I see that when you use a multichoice variable it splits that
variable into its own table. I like the way that the Aggregator displays
the values as a single variable with commas between each value. Can you
share the SQL code that you used to do this?Thanks!
Alex--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com