Discussion on "APEX Interactive Grid - Processing Selected Records"

Jon Dixon · 2022-12-21T13:13:13.757Z

Introduction The Interactive Grid is a feature-rich component that facilitates handling tabular data in APEX. I frequently use a read-only Interactive Grid (IG) to allow users to select specific records from a list for further processing in PL/SQL an...

This is the best answer I have seen so far. I loved it. It works so seemlessly even in mid-2025. I also added a "Submit Page" action after the complete message so that the page reloads and does not retain the selected records. Well I did this for my own use-case but thanks a lot! This was soooooooooo helpful <3

Did I miss where you created the button and placed it in the IG region?

He did not show that part cuz it is kinda obvious i guess. However, this solution is great, cheers!

I always enjoy reading your posts. What I want to do as part of the processing is to generate GRANT statements. My IG query compares a list of existing grants and a list of objects needing grants. I'm planning to generate an IR with the grants statements which the user can download. Is there a better way to do this within APEX? The goal is to demonstrate to our team, rather than passing a round shared Excel files, APEX is a better way. I hate using Excel to consolidate info.

Thanks.

Hi Jon, I have been looking for a solution like this for a while and coming across your post, I thought I had struck Gold. Well, I did. Just a little comment on the "completion Message". The completion message is pop up irrespective of the outcome of the "Process Selected IDs". How do I link those events? Once again, thanks.

Hi Nat, Glad you liked the post. You could create another page item that is Hidden and Unprotected. In the 'Execute Server-side Code' step, populate that page item with a more specific message or some text that indicates that the completion message should not be displayed. In the Completion Message Javascript, put an if statement around the apex.message.showPageSuccess to either not display it or display the content of the new item. You could even use the JS API apex.message.showErrors to indicate an error occurred.

Jon Dixon Hi Jon, I implemented the solution described in your post, but I do have an issue - When I click on "Select All" checkbox in the header of APEX$ROW_SELECTOR column, I only get the records visible (rendered) on page. Even though the total row count, in the footer of the grid, shows the count of all rows selected, the page item gets populated only with 50 ids. When I start scrolling down and click "Process Selected" button, I start getting more ids. How do I solve this? How can I get all grid's ids when Select All is checked?

Thanks again!

Hi, for Fetch All, I recommend having a second button that says something like 'Process All'. Clicking this button would process all records regardless of what is selected. Have a second button that says something like 'Process Selected', which processes the selected records. You can fetch all records in the IG, but this could be very inefficient if you have lots of records. if you really want to fetch all records, this forum answer may help forums.oracle.com/ords/apexds/post/interactive-gr…

Hello Jon, Great post indeed. Very useful. One question though. Is it possible to process a row or rows when APEX$ROW_SELECTOR check box is unchecked? In other words, unselected? Thank you, Leon

Hi Leon, thank you for your feedback. Wouldn't it be easier (and more efficient) to pass the selected records to a PL/SQL API, then just process all the records NOT IN the selected list?

You can loop through all records in the IG using model.forEach and then see which ones are checked: docs.oracle.com/en/database/oracle/apex/22.2/aexj…

Because you want all un-selected records, you will need to make sure you fetch all records from the server into the IG model. You can use this API to do this. Note: Depending on how many records you have, this may be very inefficient. docs.oracle.com/en/database/oracle/apex/22.2/aexj…

Hi,

Thanks for the post, very good!

Do you have some solution where i can check all de records on the grid?

Hi, I usually add a button called 'Process All' or something like that and then have that button call code to process all the eligible records. To select all in the Grid is inefficient and complex as you have to use JS.

Jon Dixon

Hey,

Thanks a lot, this is the same solution I'm adopting

Thank you, much appreciated.

Thank you, glad you liked it.

Another excellent post, all very clearly explained as usual

Thank you Jonathan, much appreciated.

Discussion

APEX Interactive Grid - Processing Selected Records

Responses(10)

Recent in Forum

Search Hashnode

APEX Interactive Grid - Processing Selected Records

Responses(10)

Recent in Forum