A comment was left on the "Execute Dynamic Action From Report Column Link" post asking "How do you pass more than one column in the same report to the dynamic action using this method?"

Refer to the aforementioned post for a more detailed description regarding this functionality.

There are two ways that this may be accomplished:

  1. Pass the values as an array of unnamed parameters.
  2. Pass the values as a list of named parameters

Pass the values as an array of unnamed parameters

In the $.event.trigger call of the column link we can pass an array of parameters in the second argument.  An example of the column link URL would be:

javascript:$.event.trigger('DAEvent', [['#EMPNO#','#MGR#']]);

In the dynamic action reference the values using the array value of this.data. In the example line above I would reference the EMPNO value by using this.data[0] and reference the MGR value by using this.data[1].

Pass the values as a list of named parameters

An alternate way to pass values through the event object is to name the parameters. An example of the column link URL is:

javascript:$.event.trigger({ type:'Method2', empno:'#EMPNO#',mgr:'#MGR#' });

The type is the name of the event we want to trigger and then we can add a list of named parameters/values that will included when the event is triggered.  In the dynamic action the parameters are referenced by name of the browserEvent object.  In this 2nd example line above I would reference the EMPNO value by using this.browserEvent.empno and reference the MGR value by using this.browserEvent.mgr.

Example Page

 

[ Oracle Apex 4.2 Dynamic Actions ]