Turning query/table into nested list view by category

💬 App Building
,
5

Yep! It's possible to have the array you're generating be an array of objects instead of just values. Using Query JSON with SQL that would look something like:

select sport, array(@{name: name, day: day}) as signups from {{sampleData.data}} group by sport

Then to access a property you'd use something like this:

{{transformedDataSql.data[ri[0]].signups[ri[1]].name}}

Here's an updated example to play around with that also includes the JavaScript version!
nested-20listview-20transformation.json

1 Like
Database Table to Array, for Nested List