Limit on Query all Records
Options
![Georges Duverger](https://us.v-cdn.net/6037124/user_avatars/1709796.jpg)
Georges Duverger
Trusted Xano Expert ✭
I see a way to sort and paginate inside the Query all Records function but I'm wondering if there is a way to limit the number of records being returned (with or without an input)?
As a work-around, I added the following custom query…
db: events.id ≤ 100000… but that doesn't seem like the right approach.
As a work-around, I added the following custom query…
db: events.id ≤ 100000… but that doesn't seem like the right approach.
Comments
-
There is an option to enable paging. You can choose the number of items per page and just receive the first page. It is on the output tab next to sorting.
-
Good call. I saw that option but I didn't think of using it as a limit. I'll give that a try.
Categories
- All Categories
- 53 ? Announcements
- 47 ? Releases
- 37 ? Welcome
- 983 ? Help! I'm a Noob
- 125 ? No-Code Front-Ends
- 633 ? Working with APIs
- 439 ? Transforming data
- 126 ? Connect Xano to ...
- 50 ?? Find an Expert
- 348 ❓Other questions
- 35 ? Security
- 22 ✂️ Snippets
- 19 ? Showcase
- 7 ?️ Xano Chatter
- 62 ? Video Tutorials
- 171 ? Request a feature
- 229 ? Report a Bug
- 19 ? Templates & Extensions
- 7 ? Feedback