🐛 Bug Report: Unable to add most recently created collection (collection #26) as a relationship attribute

[demanhamed]

👟 Reproduction steps

Description:

I encountered an issue while setting up relationships between collections. It seems that the most recently created collection (#26) is not accessible as a relationship option if it exceeds a specific threshold (in this case, 25 collections).

• This issue has been observed in Scenario 1 with 12 collections, where adding the latest (12th) collection as a relationship was successful.

Steps to Reproduce:

Create 26 collections on your platform.
Attempt to add a relationship attribute to any existing collection.
Observe that the most recently created collection (#26) is not listed as an option in the dropdown menu.

👍 Expected behavior

All created collections, regardless of their position in the list, should be available as relationship options.

👎 Actual Behavior

Collections created beyond a certain threshold (25 in this case) are not displayed as relationship options. While searching for the collection name allows selection, the chosen field remains empty.

🎲 Appwrite version

Version 1.4.x

💻 Operating system

Linux

🧱 Your Environment

Self-hosting version 1.4.13

👀 Have you spent some time to check if this issue has been raised before?

• I checked and didn't find similar issue

🏢 Have you read the Code of Conduct?

• I have read the Code of Conduct

[stnguyen90]

Discord thread: https://discord.com/channels/564160730845151244/1208526266312163388

[stnguyen90]

While searching for the collection name allows selection, the chosen field remains empty.

Demo of this behavior:

Screencast_from_02-26-2024_075341_PM.webm

This is the same behavior as #1471 except with collections rather than documents.