I have 2 collection skills and ProductContent. ProductContent have one to many relationship attribute connected with skills collections and skills collection have one to many relationship attribute connected with ProductContent collection. I want to store in ProductContent (skills=>collection of skills id's) and in skills (ProductContent=>collections of project id's) but i am getting server error and error type is unknown.
As what I observed, you have One way attribute relationship in each collection.
Skill collections has One way attribute relationship of the ProductContent, and Similar to the ProductContent collection. I recommend use the Two way
reason?
That could make effecient way
reason maybe it will create a new instance of attributes.
But base in your explanation that could make better
my code is correct ?
can I see the sample value of skills in your code
and can I ask for screenshot of what is the error response of this issue
you can look the error response by using Insepct > Network Tab
in technology, i am getting as [{id:"id1",technology:"reactjs"},{id:"id2",technology:"python}] and that i am including in skills
[{id:"id1",technology:"reactjs"},{id:"id2",technology:"python}], if this is the sample value of skills in creating document within ProductContent. I aware that you include the id but seems your skills collection does not have id attribute. You can remove this one.
so i should first remove id's from skills then insert it into the function
?
if your code has id properties then yes. But if you dont want to delete it then
do this
const skillsMutate = skills.map(item => ({ technology: item.technology }));
{
...
skills: skillsMutate
}
It will only extract the technology property
i am using many to many for 2 way, but it storing redundant data
hmmmm, if I recall. The Business logic of your collection is that "The Product Content can contain many skills. While the skills only belong to one Product Content". If that the case you should set up into One to many.
If your previous solved you can edit this post into [SOLVED] if you have new issue please create new one.
no ProductContent can contain many skills and skills contain many ProductContent
[solved]Relationship attribute between collections
Recommended threads
- Custom API domain is unreachable
Earlier my custom api domain was working fine. Now it seems to be offline without a trace a few hours later. I didn't change anything, all the relevant DNS reco...
- "Invalid console fingerprint" when unpau...
I've tried logging out and logging back in, still can't figure out why this is happening.
- Inviting members while SMTP is disabled ...
Issue: https://github.com/appwrite/console/issues/3125 PR: https://github.com/appwrite/console/pull/3126