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
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.
Craig is a Senior 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.