How do I increase query page size of widget from the default of 100

Question

I am using a suggest box to pull up and select records from a database, but it appears to limit suggestions to the first 100 records in the database. To be specific, the 101st record will not appear as a suggestion. I have read that "query page size" defaults to 100 records. Is this what's going on, and if so, is there a workaround?

Also be aware that app maker is shutting down in less than a year. Don’t know how much time you want to invest in learning it because of that. — Markus Malessa, Jan 31 '20 at 20:29

score 1 · Answer 1 · answered Jan 31 '20 at 20:17

1

SOLVED: I found "default page size" under the datasource properties under the datasourses tab of the datasource. Changed it from the default, '100' to an ample value.

answered Jan 31 '20 at 20:17

Mike C

25
3

score 0 · Answer 2 · answered Jul 16 '20 at 05:35

0

You can try changing the number to 0, that means all records would be in one page.

answered Jul 16 '20 at 05:35

FSperoni

66
4

How do I increase query page size of widget from the default of 100

2 Answers2