Skip to Main Content
Feature Request FR-3691
Product Area Page Components
Status CLOSED

2 Voters

interactive grid show records

derik.tran Public · Mar 13 2024

Idea Summary
Similar to interactive reports, can we have native option to show how many records on a page by default and allow users to choose whether they want 15, 50, 100, 150, all?

Use Case
Depending on the number of records, our users do not want to go through different pages.  Plus we have actions attached to the grid where we allow users to mass update a value based on record selectors.  The select all option on the grid only select all records on the page (15 records at a time) but “Select all” to them is SELECT ALL.  We then have to create another custom button to take action on all records and not depend on it.  It's still a training issue and is confusing to most.

Preferred Solution (Optional)
Just have a default configuration to set to 15 or 50 records and allow the users to change how many records they want to view at a time.

Question:  How many records can an interactive grid handle before it crashes the browser as I do notice it takes a massive amount of memory?  That's probably why you guys did not enable this feature in the beginning but at least give us some acceptable level (max it at 500 records or 1000).

This is a great idea! You can already achieve this in APEX today with a slightly different approach.

Comments

Comments

  • derik.tran OP 1.2 years ago

    And what's that slighly different approach?

  • jayson hanes Admin OP 1.2 years ago

    hi @derik.tran I wasn't on today's Ideas call with the team, but I suspect the ‘different approach’ is the feature that is already in IG:

  • john.snyders APEX Team OP 1.2 years ago

    Jayson is correct. When pagination type is Page the user can choose how many rows to show on a page. The developer can choose the number of rows and save as the default report. If users don't want to go through pages then the pagination type Scroll is probably best. 

    It seems that the real issue that select all does not work as expected. This is tracked in bug 35145331. We hope to improve select all in the future. There are workarounds you can try for now such as using model method fetchAll and grid widget option persistSelection. 

    How many records can an interactive grid handle before it crashes the browser as I do notice it takes a massive amount of memory?

    The answer is: it depends. IG imposes no limit on the client side. The capabilities of client browsers vary widely from the cheapest phone or tablet to high end desktops and servers. The Sample Interactive Grid app comes with a sample data set that has over 4000 rows. I use that often for testing and find that my browsers handle it just fine.