Custom list data load is truncated to 20 items

I believe I’ve encountered a bug related to how items are loaded into my custom lists. Based on my filters, I expect 23 records to be displayed, but the list consistently shows a maximum of 20, even though no limit has been set. (Maximum number of items = No Maximum)

Key Observations:

  1. Hard Limit of 20 Items:
  • Despite setting a higher limit (e.g., 200), only the 20 most recent records load.
  1. Unexpected Item Removal:
  • The issue doesn’t seem to be with the list itself but with how data is retrieved from the database.
  • Example: If I have a category called apples with three items, all three appear in the list of 20 mixed fruit/veg.
  • If I add a new item (e.g., plums), one of the apples disappears from the mixed list—seemingly because it was the 21st item.
  1. Category Filtered View Also Affected:
  • When I switch to the apples category, I’d expect to see all three apples. Instead, I only see two, meaning the item removed from the mixed list isn’t just hidden—it isn’t loaded at all.

Suspected Cause:
This suggests the issue lies in how data is being fetched from the database, rather than how the list itself is structured. It seems like only the first 20 records are retrieved from the database before filtering is applied, which results in missing data when viewing a specific category.

Load items as user scrolls is enabled, however turning that off made no difference.
This is a big issue for me, as I already have more than 20 customer ‘items’ to be displayed in the list.

Thanks in advance.
Tony

Could it be that if a custom list was ever set to a maximum number of rows, that it retains that limit, even if the max value is deleted. Meaning that 20 rows max will only ever be returned. Guess I need to try a list delete and rebuild :frowning:

Seems like this bug is still in existence - it was reported in 2020
Pagination on lists don’t work - Get Help - Adalo

I’ve tried re-creating my custom list, adjusting it so that it’s not in a container and ensuring it’s the only thing on a screen, but still, despite being set to load items on scroll, it never loads beyond 20 items. I have no choice but to set the list to load all items, which has the potential to be very slow. From what I can gather, load on scroll always loads 20 items in its initial database pull.

Hi

I have the same issue…but sometimes it loads the next set of 20 after a long while. This custom list contains a nested horizontal list. I have other custom lists that work great when “load on scroll”.

I have another custom list which loads the next rows beyond 20 on scroll, but the main list just stops at 20. I’ve had to alter it to load 50 max in one go, then add a note to say ‘this is limited for loading performance’ and to filter by category to see more. The filtered list is unlimited. It’s not pretty, but should get the job done for now.

Hi Tone

That’s a great idea! I am also filtering so that i need not show all list items for the user to view. In my case, its a tutoring app. So I filter for preferred max travel distance & one subject group (the most popular) and users change that if they want to view other subject groups.

It is the only way to keep the app from grinding to a halt. Hopefully this will be fixed once all performance upgrades are done

1 Like