Usage

Classic Report

Example nested report is based on emp and dept table.

1. Create a new application
2. Create a new page
3. Create a Classic Report based on SQL query [1]
4. Create derivied column and configure it as follows:
   1. Change derivied column Type to Link
   2. Set Target to URL
   3. Set URL to <span class="fa fa-search"></span><span class="DEPTNO" style="display: none">#DEPTNO#</span>
   4. Set Link Attributes to class="dept"
5. Create new dynamic action and configure it as follows:
   1. Set Event to Click
   2. Set Selection Type to jQuery Selector
   3. Set jQuery Selector to .dept
   4. Set Event Scope to Dynamic
   5. Set Static Container (jQuery Selector) to body
6. Create true action and configure it as follows:
   1. Set Action to United Codes Nested Reports [Plug-In]
   2. Set Details query to [2]
   3. Set Affected Elements > Selection Type to Report
   4. Set Affected Elements > Region to Classic Report defined in step 3.
   5. (Not required) Adjust the plug-in behavior up to your needs using the plug-in attributes
7. Save and run a page

[1] SQL Query (for step 3)

select * from dept

[2] SQL Query (for step 6.b)

select * from emp where deptno = '#DEPTNO#'