I have two collections: workspaces and workspace_membership. The workspaces collection has a one-to-many relationship. When I attempt to add a member to the workspace document via the workspace_membership collection, I receive an error message:
Here’s the schema for the workspace_membership collection:
{
"$id": "workspace_membership",
"$createdAt": "2025-01-08T08:54:55.354+00:00",
"$updatedAt": "2025-01-08T08:54:55.354+00:00",
"$permissions": [],
"databaseId": "dbid123",
"name": "workspace_membership",
"enabled": true,
"documentSecurity": false,
"attributes": [
{
"key": "user_id",
"type": "string",
"status": "available",
"error": "",
"required": true,
"array": false
},
{
"key": "role",
"type": "string",
"status": "available",
"error": "",
"required": true,
"array": false,
"elements": ["OWNER", "ADMIN", "MEMBER", "GUEST", "VIEWER"],
"format": "enum",
"default": null
},
{
"key": "status",
"type": "string",
"status": "available",
"error": "",
"required": true,
"array": false,
"elements": ["INVITED", "ACTIVE", "EXPIRED", "REVOKED"],
"format": "enum",
"default": null
},
{
"key": "invited_at",
"type": "string",
"status": "available",
"error": "",
"required": false,
"array": false
},
{
"key": "accepted_at",
"type": "string",
"status": "available",
"error": "",
"required": false,
"array": false
},
{
"key": "workspace_id",
"type": "string",
"status": "available",
"error": "",
"required": true,
"array": false
}
],
"indexes": []
}
What should I do to resolve this issue and correctly link the member to the workspace document?
Note: This issue only occurs when I try to add a member to a workspace. All other relationships are working fine.
Recommended threads
- Sydney Cloud Sites: App Git deployment a...
Project ID: rentwize-db The app Site fails after the build completes with a missing build archive error. Site id: app Framework: TanStack Start SSR Output dir...
- Active Running Project Deletion Alert Em...
Hi , I received an email alert from Appwrite today stating “your project will be deleted within 14 days if no action is taken,” though I have been actively usin...
- Project restoration button in console
The project restore button in console is taking no effect, i have tried several times and still nothing, it gives same popup if i reload