Relation not showing collections list
When i'm trying to create new relationship attribute it is showing 0 collections list. I'm on version 1.7.4
It might be happening because the other collection might not have the required string ID attribute (max size: 36). Try adding that and it should then appear. Sometimes a quick refresh helps too.
Please try this (if you haven't done it yet) and let me know the results
how to do that?
Yes it is. But you should always have one manually created attribute other than those default ones
Then only your table will be considered valid and will appear in the drop-down
Look, since my other two tables (with which I want to create the relationship of my current table) have the additional attribute except those default ones, they're being listed in the drop-down
yes i've attributes in those collections
it was working fine in previous version
but not showing up in my this version, what version are you on?
from the image i'm sure you and i are on different version
Yes. I'm on latest version
Can you share the attribute screenshot (which you're having in your collection/table)?
And btw, are you using an older version? Like the one below 1.4?
these are the attributes
Oh ok. It seems you're using an older version, which is why the tables aren't being listed. Can you try using a bit newer version? 1.4+?
i'm on 1.7.4
And tell me one thing, is the Document Security enabled for your collections? If it's not, the options won't appear
And also keep in mind that both of your collections are in same db
yes both are in same db, and just enabled the security option too but still not working
legacy? what does that mean? i think it is a document
If none of above fixes are working, I would suggest you switching to the latest version. It handles everything properly and your collections will appear too. I know this process is a bit long but it will work
Actually, I am using the latest version. So it's a bit tricky for me to figure out the cause. But as per the information I have, it's ideal to switch to the latest version in your case
Nothing worked for me and upgrading the whole appwrite was not in my bucket list so i just created relationship attribute using CLI and also works with node-appwrite too
Sorry I couldn't help you out to fix that.. anyways, that's really good if now it is working 👍
