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):
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),
}),
)
I have tried to use with query.Select([*]), however that was not include the columns either.
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("*")
Do you only have relationship columns or do you have non-relationship columns too?
Recommended threads
- Cannot migrate from Supabase
Hi, I was trying to migrate from Supabase to the Appwrite database. My database had around 190K columns. I tried it twice. Both times, after 2 days, the proce...
- Production down - createExecution return...
Hey, Since 1.9.6 rollout in fra (~17:00 UTC, 14 Aug), POST /v1/functions/{functionId}/executions returns a 400 whenever the body includes an empty headers ob...
- CreateRow is doing ListRows on self-host...
### setup ``` appwrite 1.9.5 self-hosted bun 1.3 node-appwrite 27.1.0 ``` ### issue Im running a function on a self hosted 1.9.5 with "node-appwrite": "^27.1.0...