The following:
json_object (
'data', json_group_array(
json_object(
'type', type,
'id', notebook_id,
'attributes', json_object(
'book', book,
'total_notes', total_notes
), ...etc
results in:
{"data":"[{\"type\":\"notebook\",\"id\":2,\"attributes\":{\"book\":\"brew\",\...
etc
the array is a string?
besides manually constructing with:
|| json_quotes('data')
|| ":["
|| group_concat(
json_object( )
)
how should it be done properly in one go?
TIA,
ingo
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
