APEX 4.2 : Dynamic Action with Before Refresh Event

A Form on a Table with Report has to be created. We can create Dynamic Action to ensure that user gets access to only specific fields while updating any record.

Report:

Form:

In this exercise we will create a dynamic action to hide the manager button when the department number is 10.

Click on Edit Page in form where we will be taken to following screen.Right click on region and select

Create Dynamic Action.

Enter the name of Dynamic Action in following screen and click on next.

In the following screen, enter the details as shown below.

Event : Before Refresh

Selection Type : Item

Item : P42_DEPTNO

Condition : equal to

Value : 10

Select Action as Hide in following screen.A false action will be created automatically as the Generate Opposite False Action button is checked.

Enter the Selection Type as Item and select the item(P42_MGR).Then click on Create Dynamic Action button.

Dynamic Action will be created as shown in following screenshot. We can modify the dynamic action by right clicking on the dynamic action and click on edit.

After successful creation of Dynamic Action when we try to update a record of an employee with department number 10 it will not show any Manager field.

When updating record of an employee with any other department, manager field will be shown.