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
- Export, Import or Migration giving this ...
As you can see in yhe screenshot i am not able to export any data or export the data from tables. Also it is affecting the migration from appwrite to appwrite h...
- local (self-hosted) sites issues
setup: - `composer run installer:dev` issues - Getting error when visiting the site ```Synchronous function execution timed out. Use asynchronous execution in...
- Error With iOS Apps
I keep getting the below errors for my flutter app. The clients are registered and have been. This wasn't an issue a few hours ago. AppwriteException: AppwriteE...