Oracle Apex : Dynamic Action with English subtitle

Name: Oracle Apex : Dynamic Action with English subtitle
Rating: 5.0 (4 reviews)

Understanding Dynamic Action in Oracle APEX

Created byAli Saleh Ali

Last updated 5/2022

Arabic

What you'll learn

Browser Events ,Framework Events ,Component Events and Custom Event
Selection Type : Item(s) ,Button ,Region ,Column(s) ,jQuery Selector and JavaScript Expression
All Action
Client-side Condition

Course content

7 sections • 38 lectures • 3h 4m total length

Introduction5:24

[Browser Events] change on item4:43
how to create Dynamic action
event : change on item
action : alert, confirm ,execute java script
[Browser Events] false action5:48
1- how to use false action
2- event /change item
3- action disable item,enable item
4- client side condition
[Browser Events] opposite action & fire on initialization4:19
event change item
action show/hide opposite action
fire on initialization
[Browser Events] click & double click on button4:17
event :click & double click on button
action :clear item, set focus , set value [static]
[Browser Events] get focus1:34
event : get focus
action: set value
[Browser Events] Key-down, Key-press , Key-Release3:25
event
Key-down, Key-press , Key-Release
action : alert
[Browser Events] mouse event [button press,button Release,enter,leave,move]3:16
event:
mouse button press
mouse button Release
mouse enter
mouse leave
mouse move
action : alert
[Browser Events] page Load / page unload4:00
event :page Load
page unload
action :
disable button
alert
java script position in page
[Browser Events] resize / resource load / select4:21
event : resize resource load select
action : alert
selection type : JavaScript expression

calendar event6:27
calendar event
date changed
event changed
view changed
action : alert
Tree events5:49
event: selected change
action :expand Tree ,collapse tree
Interactive [Grid Mode change]2:13
event :Interactive Grid Mode change
Action:alert
Interactive Grid [Page change]2:09
event :Interactive Grid Page change
Action:alert
Interactive Grid [Report change]1:21
event :Interactive Grid Report change
Action:alert
Interactive Grid [ Raw Initialization ]0:56
event :Interactive Grid Raw Initialization
Action:alert
Interactive Grid [ save ]1:04
event :Interactive Grid save
Action:alert
Interactive Grid [ View change ]2:10
event :Interactive Grid View change
Action:alert
Interactive Grid [ selection change ]5:23
event :Interactive Grid selection change
Action:alert ,
execute JavaScript code to get column value to item,
set value with JavaScript expression to get column value to item
---code for execute JavaScript
if (apex.region("EMP_REGION"))
{
var grid = apex.region("EMP_REGION").widget().interactiveGrid("getViews", "grid"); var model = grid.model; var record = grid.getSelectedRecords()[0];
if (record) { $s("P6_EMPNO", model.getValue(record, "ENAME"));
}
}
----- ---
code for set Value using JavaScript expression
(this.data && this.data.selectedRecords && this.data.selectedRecords.length == 1) ? this.data.model.getValue( this.data.selectedRecords[0], "COMM") : ""
---

Open Region / Close Region7:39
Action : Open Region
Close Region
Clear,disable,enable,show,hide,Refresh,Set Focus10:59
Action : Clear
disable,enable
show,hide
Refresh
Set Focus
Set value6:12
Action : set value
Set Type: Static Assignment
JavaScript Expression,
SQL Statement,
PL/SQL Expression,
PL/SQL Function Body
Set value with Set Type: Dialog Return Item6:09
Event: Dialog Closed
Action : set value
Set Type: Dialog Return Item
Execute JavaScript Code6:20
Execute Pl/SQL Code, Submit2:29
event : Button Click
Action : Execute Pl/SQL Code Submit
Cancel Event4:28
event : Button Click
Action :Cancel Event
Close Dialog ,Cancel Dialog4:26
Add Class11:20
event : Button Click
Action : Add Class (apex class & custom class)
Remove class , Set style3:55

Selection Type12:46
Selection Type
Item(s)
Button
Region
Column(s)
jQuery Selector
JavaScript Expression
Delete a Row From Classic Report with a Dynamic Action5:57
Delete a Row From Classic Report with a Dynamic Action
Plugin6:24
event : click on button
action :Redirect [Plugin]
Sample Dynamic Actions Application4:32
How to install and use Sample Dynamic Actions Sample Application
Dynamic Action on interactive grid column6:59
Dynamic Action on interactive grid column

Requirements

APEX
Oracle
SQL
PL/SQL

Description

Dynamic actions enable developers to define complex client-side behavior declaratively without the need for JavaScript.

About Dynamic Actions
Dynamic actions provide a way to define complex client-side behavior declaratively without the need for JavaScript. Using the Dynamic Action Create wizard, you specify an action that is performed when a defined set of conditions occur. You can also specify which elements are affected by the action, and when and how they are affected.
About Dynamic Action Events
You can define dynamic actions can to fire based on events that happen on the page. Oracle Application Express includes four different categories of events: Browser events, Framework events, Component events, and Custom events. This section describes all supported events, including the internal JavaScript event name in brackets.
Creating a Dynamic Action
Creating a dynamic action involves specifying when the action happens (with optional conditions), what action or actions are performed, and what elements are affected by the action. To learn more about any Property Editor attribute, select the attribute and click the Help tab in the central pane.
Editing Dynamic Actions
Once you create a dynamic action, you can modify attributes defined during the creation process, specify attributes not available during the process (such as specifying an Authorization Scheme) and add additional true actions.
Defining Dynamic Action Event Scope
After creating the dynamic action, the scope of the action can be modified to trigger only once, for the lifetime of the current page, or until triggering elements are updated by a Partial Page Refresh (PPR).
Deleting a Dynamic Action
Delete a dynamic action by selecting it in Page Designer and selecting Delete from the context menu.
Debugging Dynamic Actions
Learn how to debug dynamic actions in Oracle Application Express.

Who this course is for:

Beginner Oracle APEX developers

Oracle Apex : Dynamic Action with English subtitle

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 5min

Browser Events9 lectures • 36min

Framework Events3 lectures • 13min

Component Events9 lectures • 28min

Custom event1 lecture • 2min

Actions10 lectures • 1hr 4min

Advanced5 lectures • 37min

Requirements

Description

Who this course is for: