[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?

TL;DR

Appwrite developer needed help with getting relations when using TablesDB. Solution: Use the `*` wildcard to load all fields from related rows.

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:

TypeScript

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