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?

Answer 1

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

Answer 2

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.