Hi, is it possible to use any operator on a relationship column? I have a One to Many relationship column on a table and I would like to add entries to the column using the arrayAppend Operator. I'm hosting Appwrite 1.9.0 and using Flutter/Dart SDK. The following snippet:
await databases.updateRow(
databaseId: AppwriteConstants.databaseID,
tableId: AppwriteConstants.tableID,
rowId: id,
data: {
"related": Operator.arrayAppend([id])
}
);
Fails with the error relationship_value_invalid Thank you!
As per what I've concluded from my search, relationship columns currently don't support operators. And in order to make any new updates, you should follow these steps:
- Fetch the current row
- Get existing relationship IDs
- Append the new ID manually
- Update the entire relationship field again
Yeah that's the workflow I am following right now. I was wondering if operators support was planned on relationship columns
I've created the following Enhancement issue: https://github.com/appwrite/appwrite/issues/12354
Recommended threads
- Attribute not found in schema on REST AP...
I'm querying a appwrite collection via the REST API on appwrite cloud 1.9.5 (no SDK) via a cloudflare worker and keep getting: ``` {"message":"Invalid query: A...
- [SOLVED] Appwrite 25.1.0 returns Invalid...
I've already opened an issue on GitHub, but somewhat it doesn't seem like GitHub is monitored very closely, so I'm leaving a bug report here on Discord as well....
- Can't really use the S3 storage device
hi, I've linked my local MinIO Instance (it's just for testing, not for prod.) to my appwrite instance, when i'm uploading a file it's getting uploaded to the S...