title: Oracle Apex Interactive Grid select all only select 1 page records
body: <p>I have a button “Select All” and it has a true dynamic cation “JS Function” to select all the records on the interactive Grid.</p>
  <pre><code>apex.region(“payment_info”).widget()
       .interactiveGrid(“getViews”, “grid”).view$.grid(“selectAll”);
  </code></pre>
  <p>This function only selects the record on the page I am currently focusing on.  I want to select all the records from all the pages in that Interactive Grid.</p>
  <p>NOTE: I need to keep the pagination of the IG. I cannot have the page as a scroll.</p>
  <p>I can see similar questions like this one: <a href="https://stackoverflow.com/questions/54823218/interactive-grid-in-oracle-apex-only-40-rows-are-selected-if-i-do-select-all">Interactive grid in Oracle APEX - Only 40 rows are selected, if I do &#39;Select All&#39;</a>
  but it is not really what I'm after.</p>
  <p>Thanks in advance.</p>