[SOLVED] looking for somehelp in relationships,

each order will have multiple Products

TL;DR

The user was looking for help with relationships in their app. They initially tried using JSON.stringify, which worked but they were looking for a better solution. They wanted to have objects in a string array. Another user suggested creating a profiles collection and using database relationships with that collection. The original user mentioned that they couldn't create new attributes for Auth and wanted to know how to create a relationship with a user(Auth) and a collection. It was suggested that they create a collection for order items and have an array of IDs in the orders collection, but the original user preferred using an array of objects. No solution was provided for this preference.

so i thought of using array of objects

Right so have a collection of order items. And in the orders collection you'd have an array of IDs (strings)

will array of objects supported in future release?

most likely not especially since we have relationships in the latest bersion of Appwrite

How can i create a relationship for a user(Auth) with collection,

Unable to create new attributes for Auth

I would suggest creating a profiles collection for any user related data you want to use in your app. then you can use database relationships with that collection (assuming you're on Appwrite version 1.3.x)

yes. I am using 1.3.7

i dont see any option to create a releationship with Auth collection, I am using the email and password authentication

i am seeing only Products and Orders collection

I expected to see Authentication collection

I have collection called userProfiles, i want to make a relationship with Auth

You can't make a relationship with the Auth service.

ok, so copy the $id from AuthService and keep it in UserProfile

I typically use the same user Id as the document ID in my user profiles collection

Sure.. That helps

Thanks Steven