Self HostedFlutterDatabases

How to use Operator.arrayAppend on a relationship

May 8, 2026, 21:00

View on Discord

Votes

Replies

Participants

Unknown

Messages

NoxOriginal post

Rank 1: Thread

May 8, 2026, 19:45

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!

Summary

To use Operator.arrayAppend on a relationship, fetch the current row, retrieve existing relationship IDs, manually append the new ID, and then update the entire relationship field. Currently, relationship columns do not support operators so this manual process is necessary. The user has created an Enhancement issue for this on GitHub.

Devika

May 14, 2026, 16:11

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

Nox

Rank 1: Thread

May 17, 2026, 18:38

Yeah that's the workflow I am following right now. I was wondering if operators support was planned on relationship columns

Nox

Rank 1: Thread

May 19, 2026, 19:50

I've created the following Enhancement issue: https://github.com/appwrite/appwrite/issues/12354

How to use Operator.arrayAppend on a relationship

Need support?_