Execute Dynamic Action From Report Column Link

In my previous post I showed how a dynamic action can be executed by using $event.trigger(<name>). Using the same call we can execute a dynamic action from a column link in a report. Not only can the dynamic action be executed but a value can also be passed to the dynamic action.

This example has a report of employees in the emp table and when the name of the employee is clicked a dynamic action is run to load the employee data from the database and into some page items.

The column link is created with the Target set to a URL of "javascript:$.event.trigger('DAEvent','#EMPNO#');". The Dynamic Action will be created to execute when the "DAEvent" event is triggered. The EMPNO value from the corresponding row will be passed and used by the Dynamic Action.

The Dynamic Action is created with the When Event set to "Custom" and with "DAEvent" entered for the Custom Event. The Selection Type option is set to "DOM Object" and "document" entered into the DOM Object field.

The EMP value that we passed with the event trigger can be referenced in a true action JavaScript Expression using "this.data"

In this true action the P82_EMPNO page item value is being set to the EMPNO value that is in the this.data JavaScript expression.

Then in a subsequent true action we can reference the value in the P82_EMPNO to retrieve and set some data from the database.

(Oracle Application Express) (Oracle APEX version 4.2)

Comments

Posted on 4 Jun 2013 by Jeff Eberhard

I've posted a follow-up blog post about this.

Posted on 29 Oct 2013 by Hello34

This is a great article and i was able to implement and it worked as explained in this doc. Can you please let me know how to achieve the same in earlier version of apex where custom event option is not available... Thanks

Posted on 31 Oct 2013 by Jeff Eberhard

Instead of executing an custom trigger have the column link set the value of an hidden page item and trigger the dynamic action of the change event of the hidden item.

For the column link URL use something like:

javascript:$s("P82_EMPNO","#EMPNO");

Change the Get and Show EMP Data dynamic action to:

Event - Change

Selection Type- Item

Item(s)- P82_EMPNO

Remove the first true action in the dynamic action which sets the item value (it will already be set).

Hope that makes sense.

Posted on 30 Dec 2013 by RK

Thank you Sir.

Posted on 17 Aug 2014 by Gregzepp

Can I just say how important the submit of the items is. This will not work without it!

Posted on 18 Feb 2017 by Kate

Hi! This guide is really helpful, so thank you! :)

However I have a question: I'm using Apex 5.1.0.00.45 (latest on cloud), and there's no such Selection Type as DOM. Is there any alternatives? Can I use the interactive riport's region as Region?

Posted on 21 Feb 2017 by Jeff Eberhard

Yes, in 5.1 you can use the Select Type of "JavaScript Expression".

Posted on 23 Feb 2017 by Kate

Thank you for your answer! I've seen the 'Run Dynamic Action from JavaScript' article, but I would like to submit some information too, not just the 'document'. Is it possible?

Posted on 24 Feb 2017 by Kate

WOW! That's kinda a magic! It's worked :D

The whole design is a big mess, if you want to use the tutorials.

For the fellows, who works with the apex cloud: at the left the flash icon is the dynamic actions, and after you created your custom event, there will be a TRUE/FALSE folder. In the TRUE section, you can create your actions: first, to write your variable, and then to use it.

Thank you again! I'm super happy! :)

Posted on 4 Jul 2022 by Tolgay

I want to pass one more variable with javascript:$.event.trigger('DAEvent',#EMPNO#,#EMPSTATUS#); and I'm going to set another page item P82_EMPSTATUS. How can I do it?

EberApp Blog