[SOLVED] Get Relations when using TablesDB

Hi there, I have a table containing a relation column with a one-to-many relationship to another table. When Using TablesDB.GetRow in "node-appwrite" i get all the normal rows but not the relations. Does anyone have an idea?

By default, Appwrite returns only a row's own fields when you retrieve rows. Related rows are not automatically loaded

Use the * wildcard to load all fields from related rows:

const doc = await tablesDB.getRow({
    databaseId: '<DATABASE_ID>',
    tableId: '<TABLE_ID>',
    rowId: '<ROW_ID>',
    queries: [Query.select(['*', 'reviews.*'])]
});

https://appwrite.io/docs/products/databases/relationships#performance-loading

I'll try it. Thanks in advance 🙏

It worked.... Thanks a lot

[SOLVED] Get Relations when using TablesDB