Databases Reference
In-Depth Information
Figure 11-26.
Example of many-to-many cascading select lists
In this scenario developers may want to preserve child value selections if they existed in the new list
of values when the parent changed. This would prevent the user from having to reselect the same value if
that's what they intended to do. The default functionality for cascading LOVs does not support this but,
with enough knowledge of how cascading LOVs work in APEX, the functionality can be added through a
Dynamic Action plug-in.
The plug-in will be designed so that either the
change
event of a parent item or the load event of the
page can be used as the driver of the dynamic action. Ultimately, the load event of the page will be used
in either case.
To begin creating the plug-in, navigate to Shared Components
Plug-ins and follow these steps as
shown in Figure 11-27.
1.
Click Create >.
2.
Set Name to PlugGen Save Value on Cascade (1.0).
3.
Set Internal Name to COM_PLUGGEN_SAVE_VALUE.
4.
Set Type to Dynamic Action.
5.
Set Category to Component.
6.
Set PL/SQL Code to the code from Listing 11-2.
7.
Set Render Function Name to save_value_render.
8.
Select the following under Standard Attributes: For Item(s), Affected Element
Required, Check “Fire on page load”.
9.
Click Create.
