[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)