Oracle Apex - How to setup a row custom button on Interactive Report

Oracle Apex - How to setup a custom button to rows on Interactive Report

We will add a "Test" button on each Interactive Report row.  It will pass the current row's ID value to linked Dynamic Action.  You can use this for further processing.


1. At report Query SQL , all a column

   select id, null as test_button from your_table;

2. Setup a Dynamic Action linking to Custom Event

3. At True Action, set it as run Javascript

4. At test_button column properties, set HTML Express as following





5. You will see something like

6. You will see the dialog box with ID value when click the row button

7. If you are using Pagination mode, you need to set the Custom Event to Dynamic mode, otherwise it does not work after change to another pages.