Back

[SOLVED] Major Problem with 25 records limit

  • 0
  • Self Hosted
  • Databases
  • Web
Tassos P.
24 Apr, 2024, 13:16

I am building an app and several collections used to populate drop down selects. These select inputs have more than 35 records each. Is there a solution to overpass the limit? because so far with Query.limit(100) i.ex. it returns maximum 25!

TL;DR
Developers had a major issue with the 25 records limit, but it was resolved by setting a limit on a third query. The issue stemmed from not specifying a limit on a query, affecting the available IDs in an array. By setting the limit appropriately, the problem was fixed.
Kenny
24 Apr, 2024, 13:31

What does your code look like because query limit 100 should work to extend the limit with a max of 5000 I believe.

Tassos P.
24 Apr, 2024, 13:38

Look here @Kenny

const refs = await db.listDocuments(ODKE_DB, COL_REFS,[ Query.equal('user_id', res.availablereferees), Query.limit(100) ])

Tassos P.
24 Apr, 2024, 13:38

where res.availablereferees is an array of another collection in the same function

Kenny
24 Apr, 2024, 13:42

Just curious, if you remove that query equal does the limit work then?

Tassos P.
24 Apr, 2024, 13:48

yes but ok, it was my mistake because I had not set a limit on a third Query so it was limiting the available ids into the other array! Sorry for this!!! thank you @Kenny for the instant interest and guidance!

Tassos P.
24 Apr, 2024, 13:48

[SOLVED] Major Problem with 25 records limit

Kenny
24 Apr, 2024, 13:49

Glad you got it resolved! :)

Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more