The following example will demonstrate how a Dynamic Action can be utilised within a report column to confirm deletion of a record, before the deletion process occurs.
Apex Event Trigger
The function requires three parameters:
pSelector is the jQuery formatted selector used to trigger the Apex event.
pEvent is the browser event that will occur on the selector.
pData is not required.
In this example a hidden item is used as the selector to trigger a “select” browser event.
Trigger Dynamic Action from Report Column
Note: Ensure that value protection is disabled on the hidden item.
A Dynamic Action can now be created with the “select” event defined on the hidden item. When the user clicks the link within the report row, the new Dynamic Action will fire.
The Dynamic Action contains a confirm action to request approval of the records deletion. A submit action is also defined to submit the page and trigger the delete page process. As the row identifier was passed into a hidden item, this value can be utilised within the page process.
About the Author
Oracle APEX Development Consultant
Explorer (UK) Ltd – Oracle awarding winning Platinum Partner
Craig is a Development Consultant at Explorer. Craig has an MSc in Computing Science and is an experienced software engineer, utilising development tools such as PL/SQL and APEX to provide bespoke ERP software to both UK and international businesses. Craig has experience developing solutions to connect Oracle systems to a wide range of existing external applications within business environments.
Explorer, How to /