[Bug] Number of grids returned for linking a relation has a hard limit

[tit1]

Bug Description

Hello,
I may have an odd situation in that i am using. Numerous grids in my notes as im tracking trip data across multiple pages in the same workspace.
The general page holds Locations, attractions, Hotels and the such which is linked to in separate pages (one for each trip). Each trip page has at a min of 8 grids. Currently between the general page (6 grids) and 5 trip pages i have a total of 46 grids (some are views of anouther grid).

When I go to select a grid in the “Related Database” selection box only the first 20 grids are displayed. There is no visible way to search for or load additional grids.

How to Reproduce

• Create a page or pages with more than 20 grids
• In one of e the grids add a new property with the type of Relation.
• Click on the new field to display the 'Related Database'

Expected Behavior

All grids are displayed or there is an option to search for or load more grid names.

Operating System

mac OS 15.4.1 (24E263)

AppFlowy Version(s)

App version: Version 0.8.9 (0.8.9) ; Self hosted cloud version: Unsure (installed 4-5 days ago)

Screenshots

No response

Additional Context

No response

[richardshiue]

Hey there @tit1, have you tried scrolling on the list? I have a workspace that has more than 20 databases and they all show up

[tit1]

Thanks @richardshiue i have, it wont load anything past 20 for me:

[tit1]

Server has been upgraded to 0.9.49 and desktop application has been upgraded to Version 0.9.1 (0.9.1).

The issue still seams to persist.

I don't know if this helps but some of the grids I am missing are form workspace: UUID - 7cd27276-27b7-49c9-9277-03c01a3df4c9

These are some errors in the logs:

{"msg":"[GET_WORKSPACE_USAGE - EVENT] flowy_user::user_manager::manager_user_workspace","time":"05-07 13:37:55","target":"flowy_user::user_manager::manager_user_workspace","error":"code:Internal error, message:HTTP status client error (404 Not Found) for url (https://appflowy.URL.com/api/workspace/7cd27276-27b7-49c9-9277-03c01a3df4c9/usage-and-limit)","workspace_id":"7cd27276-27b7-49c9-9277-03c01a3df4c9"}
{"msg":"[GET_WORKSPACE_USAGE - END]","time":"05-07 13:37:55","target":"flowy_user::user_manager::manager_user_workspace","workspace_id":"7cd27276-27b7-49c9-9277-03c01a3df4c9","elapsed_milliseconds":8}
{"msg":"flowy_user::event_handler","time":"05-07 13:37:55","target":"flowy_user::event_handler","error":"code:Internal error, message:HTTP status client error (404 Not Found) for url (https://appflowy.URL.com/api/workspace/7cd27276-27b7-49c9-9277-03c01a3df4c9/usage-and-limit)"}
{"msg":"[Flutter]: Failed to get workspace usage: msg: HTTP status client error (404 Not Found) for url (https://appflowy.URL.com/api/workspace/7cd27276-27b7-49c9-9277-03c01a3df4c9/usage-and-limit)\n","time":"05-07 13:37:55","target":"dart_ffi"}

I also deleted all the files here: '/Users/USERNAME/Library/Application Support/com.appflowy.appflowy.flutter' and re-synced with the cloud server to no success.