Back
Query with relationship
So i have this database with collections user > topic > notes. Each user can have multiple topics and each topic can contain many notes. if I get user document with no queries, it fetches all of his topics and notes which I think might be slow if he has many notes. I've tried to use select query like so Query.select(['topic.*']). It doesn't return notes but also doesn't return $id of the topic document so I could get notes related to that topic. what would be the best practice here?
TL;DR
Developers want to query relationships in a database with collections of users, topics, and notes efficiently. They are currently unable to fetch topic documents along with their associated notes. One suggestion is to add a userId attribute to the topic collection as a reference. This way, developers can query the topic document and then fetch notes related to that specific topic using the userId.
Queries with relationships aren't supported atm.
maybe you could add userId attribute to the topic collection and use it as a reference via the user id.
