I'm loading data into an Interactive Grid and want to show all rows at once (less than 100 rows). I'm doing lots of manipulation of the grid data using the model interface in the Oracle APEX JavaScript API. It appears to load only 50 rows by default into the grid. I've tried using the Toolbar ‘rows per page’ feature to load 500 rows at a time. I've tried using model.fetchAll to programmatically load all rows, but status.done seems to return false most or all of the time. Nothing I've tried returns all rows consistently. Occasionally it will load all rows, sometimes it will only load 50 even though the row count at the bottom of the grid states that it loaded all of them, and sometimes it only loads 50 and the row count agrees that it only loaded 50.
Anyone run into this problem and solved it?
This is APEX 22.2. On a side note, this UI requirements state that we don't show the Toolbar so users can't change the number of rows on their own.