[GH-ISSUE #7851] [Bug] Number of grids returned for linking a relation has a hard limit #3444

Closed
opened 2026-03-23 21:30:14 +00:00 by mirror · 4 comments
Owner

Originally created by @tit1 on GitHub (Apr 28, 2025).
Original GitHub issue: https://github.com/AppFlowy-IO/AppFlowy/issues/7851

Originally assigned to: @richardshiue on GitHub.

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.

Image

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

Originally created by @tit1 on GitHub (Apr 28, 2025). Original GitHub issue: https://github.com/AppFlowy-IO/AppFlowy/issues/7851 Originally assigned to: @richardshiue on GitHub. ### 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. ![Image](https://github.com/user-attachments/assets/1853bc47-d5d3-49bd-93af-c00324d0edcf) ### 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_
mirror 2026-03-23 21:30:14 +00:00
Author
Owner

@richardshiue commented on GitHub (Apr 29, 2025):

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

<!-- gh-comment-id:2837257244 --> @richardshiue commented on GitHub (Apr 29, 2025): 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
Author
Owner

@tit1 commented on GitHub (Apr 29, 2025):

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

Image

<!-- gh-comment-id:2839144180 --> @tit1 commented on GitHub (Apr 29, 2025): Thanks @richardshiue i have, it wont load anything past 20 for me: ![Image](https://github.com/user-attachments/assets/35b97022-d0d0-41e7-b164-f7dd1fd2b2f7)
Author
Owner

@tit1 commented on GitHub (May 7, 2025):

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.

<!-- gh-comment-id:2859709413 --> @tit1 commented on GitHub (May 7, 2025): 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.
Author
Owner

@annieappflowy commented on GitHub (Dec 18, 2025):

Fixed in the upcoming release (v0.10.7)

<!-- gh-comment-id:3669247116 --> @annieappflowy commented on GitHub (Dec 18, 2025): Fixed in the upcoming release (v0.10.7)
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
AppFlowy-IO/AppFlowy#3444
No description provided.