i am fetching occasion_data via v2 json query and result is a list of object which looks something like this. ``` { "type": "message", "id": "<messageid>", "occasion_data": { "type": "occasion_data", "rsvp": { "query": "SELECT * FROM rsvps WHERE message.id = '<msgid>'" } ``` here i want to fetch rsvps list too using sub-queries. when i tried in this way. it didn't work. ``` { "messages": { "fields": [ "id", "occasion_data.rsvp" ], "constraints": [ { "occasion_data.end_time": { ">=": 1 } } ], "subQueries": { "occasion_data.rsvp": { "fields": [] } } } } ``` i believe the reason is because rsvp is a field in occasion_data which is field in message itself. pleas let me know if any doing wrong or a workaround.
... View more