[SOLVED] How to create a relationship between Auth and my collection?
- 1
- Databases
- Accounts
- Users
- Web

Hey all, i'm currently trying AppWrite out,
https://appwrite.io/docs/tutorials/react/step-6
As I'm flowing the docs and tutorials, i still didn't find how to create a relationship between userId and the Ideas.
I understand to create the field userId, and supply it. but it's without a relationship in the DB, or is it?!
Also on the example , it fetches all of the ideas and not the ideas of the current user.

Currently there is not option to make a relationship between auth (users) and collection.
The approach will be create a collection with all your users, and store all the data you want there, and then in a second collection make a relationship with the "user" collection.
If you activate the document security and assign permission to the owner of the information, you won't need to filter the data, as only will have permission to get the document owned.
To filter a request you can use the Query
class, you can check more information here: https://appwrite.io/docs/products/databases/queries

Thanks!
i'm glad that the solution you offered, was the work around i implemented

[SOLVED] How to create a relationship between Auth and my collection?
Recommended threads
- Problem with login using Retool
I am using the Appwrite rest api to create an email session from Retool. My next api call is to create JWT. The call is failing because Retool is a closed envir...
- Adding Attributes to User
What is the best way to add attributes for a User? Do I need to create another entity with the attributes since I cant add them in the Auth service. Thx
- Appwrite sites 404
Hello ! When I add a subdomain to a deployed website, it gives me a 404 error on said domain thus making the SSL processus not working and im not able to acces...
