Back

Navigating Collection Relationships Beyond the 25th

  • 0
  • Databases
hamed
17 Feb, 2024, 21:31

Hey there! I encountered an issue while working early, and I feel the need to report it. Here’s the problem: you can’t add your most recently created collection as a relationship attribute to another collection if it’s listed as your 26th collection.

Let me break it down:

Scenario 1 (12 Collections): Suppose you have 12 collections. You want to add the last one (12th) as a relationship to any previous collections. The result will be successful.

Scenario 2 (26 Collections): Now imagine you have 26 collections. You want to add the 26th collection as a relationship. Unfortunately, it won’t appear in the options list.

P.S.: In Scenario 2, although you can search for the 26th collection, the selected field will remain empty.

TL;DR
Developers can't add their 26th collection as a relationship attribute to another collection. Even if the collection is searched for, it won't be selectable. This issue seems to occur only in the Appwrite console when the filter fails to find the document. The suggested solution is to create a GitHub issue.
Steven
17 Feb, 2024, 21:33

This should only be a problem in the Appwrite console...and only if your filter for the related document doesn't find the document, right?

hamed
17 Feb, 2024, 21:38

you don’t necessarily need to filter them. Mostly, if you scroll down the list, you will find your specific collection. However, in the case of the 26th collection, it won’t appear. But if you use a filter, you’ll get results, although they won’t be selectable

Steven
17 Feb, 2024, 21:45

Oh NVM, I misunderstood the problem. Interesting....would you please create a GitHub issue?

Steven
17 Feb, 2024, 21:46

That said, you can still create the attribute using a server SDK or the CLI

hamed
17 Feb, 2024, 21:52

Sure,

Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more