I have a dashboard with two child grids. One of them loads all the records from its respective BAQ as expected, but the other one only displays 2 records but has a down-arrow button to load the remainder of the records. Both grids are set to a max of 500 records in Overflow > Options; but the BAQ providing results for the second grid has ~1400 records in its results.
If I increase this to say, 3000 record max, then it gets rid of the down-arrow load button. My question then is: how can I modify that record max in Application Studio so that all users will not have to manually change the value?
I don’t know if this is what you are looking for, but in the admin console you can set the BAQ returned results. But this sets it for everyone. If you put it at 0 it returns the whole result.
Setting Grid Model page size seems to fix it. I thought “Page Size” had to do with grid height or such. Also, the Options showed 500, but Page Size showed 100, so I assumed the two values were unrelated.
Edit: From the App Studio Reference User Guide
Data > Grid Model > Page Size
Determines the number of records or rows to be displayed per page in
the grid. By setting the page size, you can control how many records are
visible at a time, providing better navigation and performance for the
users. The page size can be defined as an integer value, representing
the desired number of records to be shown. It allows you to organize
and present data in manageable chunks, facilitating easier browsing,
sorting, and filtering of the grid content.
So, it’s probably not exactly the same as the Options max record number. But the behavior is somewhat similar.
