only 25 initial items are available for a many to many relationship

i have a "many to many" relationship and in the target table , i have 48 entries ranging from 1 to 48 . but in the UI, only initial 25 items are visible.

<image 1>

if i add the relationship from SDK, only those entries within the 25 initial entries are visible in the UI.. the entry which is more than 25 entry is shown as blank text field. does it have anything to do with default query limit of 25 ? (image is of another collection, its reproducable in all of the collections )

<image 2>

But in the "all documents" view, if i click the relations cell, pop -up is showing all relationships correctly.. and i can navigate to target row in the target collection as expected

<image 3>

in the inspect element of that console page also, out of 64 entries, 25 are only fetched..

<image 4>

The idea is you should be able to search for the related record, but there's a bug at the moment. See https://github.com/appwrite/appwrite/issues/5454

But i can search for documents if the target collection is having only 25 entries.. but even if it contains more ethan 25 entries, the initial 25 entries are visible in UI and is searchable

Do you see network errors when you search?

yea , i had this network error that says $id need a full text index .. and i added it.. and then that network error is gone.. but it has nothing to do with the issue i mentioned..

steps to reproduce :

1. create 2 collections , host and target. and add a many to many relationship from host -> target
2. add about 30 documents to the target collection with ID as numbers from "1" to "30" instead of default unique ID's (for easy identification)
3. go to the host collection and while adding a document, search for any ID which is more than 25 , it wont show up. but upto 25th id, you can choose and add..
4. even if you add 30th ID as a relationship using any SDK or server code. , in console, you will see that relation as an editable blank Text field instead of showing the ID of the target document as a disabled text field.