Hi,
v18.2.
I have a requirement to have a custom button appear in the Interactive Grid (IG) toolbar area, and upon clicking this button I would like it to update the status column in the underlying database records for the selected rows in the IG and then refresh the grid (or page if refreshing just the grid is not possible) to reflect this status change in the IG. The IG is not editable.
Following various resources, I have been able to customise my IG toolbar to include my new button but I am not sure how I can achieve the processing part i.e. to get a handle on the IG's selected rows and then pass the IDs of these rows to an action which is linked to the pressing of the new button.
This post (https://community.oracle.com/thread/4174439) suggests having a custom dynamic action which is linked to the event of what I presume is the button click of the custom button. But how do we trigger that exactly and how can we pass it the IDs of the IG's selected rows? I'm aware that there is a 'getSelectedRecords' function available but not sure how to incorporate it into my solution. Will the dynamic action run PL/SQL code or JavaScript code (if it's supposed to use 'getSelectedRecords')?
I would be grateful for any tips/guidelines on how I can achieve this. I have been following the Hard Like Software 'How to hack APEX Interactive Grids' series which I believe has my answer in there somewhere but I am not experienced enough to fully comprehend what is being described there.
Regards