Skip to content
Back

Why TablesDB ListRows function does not include columns?

  • 0
  • 2
  • Self Hosted
  • Databases
Karim
16 Nov, 2025, 06:29

When I try to list the rows with queries, there is no column data included in the returned value with forced me to fetch the items one-by-one with ID (which was not the case with older Database module) . Am I doing something wrong?

Example snippet (Go SDK):

TypeScript
docs, err := ServerClient.TablesDB.ListRows(
        AuthDB,
        EmailVerifyTable,
        ServerClient.TablesDB.WithListRowsQueries([]string{
            query.Equal("user_id", userID),
            query.Equal("email", email),
            query.Equal("secret_key", secret),
            query.Offset(0),
            query.Limit(1),
        }),
    )
TL;DR
Issue 1: Decoding a nested struct should be done by decoding `docs.Rows.Decode()` as a whole list, not by decoding `docs.Rows[0].Decode()`. Issue 2: Instead of `query.Select(["*"])`, use `query.Select("*")` because the select query only accepts a single value. Question: Do you only have relationship columns or do you have non-relationship columns too?
Karim
16 Nov, 2025, 06:34

I have tried to use with query.Select([*]), however that was not include the columns either.

16 Nov, 2025, 18:07

I had tried to decode the nested struct, as: docs.Rows[0].Decode() which is incorrect. I fixed this by decoding docs.Rows.Decode() as a whole list.

Another issue, query.Select(["*"]) was incorrect, select query accepts only single value. So the correct usage should be query.Select("*")

17 Nov, 2025, 00:46

Do you only have relationship columns or do you have non-relationship columns too?

Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more