Back
Console: Query on attribute has greater than 500 values: $id
I noticed an issue when one of my tables reached over ~800 rows. That table is relational to my users table
Within the console I am able to view the table with over 500 rows, but when viewing the users table I get 400 Invalid query: Query on attribute has greater than 500 values: $id, This only happens in the console or when I use listRows while querying one of the columns in the 500+ rows table. (I cant check but my guess is 1 user has over 500+ themselves) Which I know I can use paging, although this directly affects the console.
TL;DR
Issue: Console shows error `$id` when querying users table with more than 500 rows due to a user having over 500+ entries in a related table.
Solution: Implement paging to handle large datasets and avoid exceeding the limit of 500 values for a specific attribute.