Dynamic Action

Form Events

The plug-in can be bound with form inputs using standard events such as Key Release, Key Press, Key Down, Lose Focus, Change, and Click.

Triggering Elements and Affected Elements

The plug-in uses a combination of triggering elements and affected elements to evaluate a set of items (or interactive grid columns) to be validated. The table below describes currently supported combinations.

Triggering Element	Affected Elements	Element(s) to validate	Comment
Region (not interactive grid)	Not set	Any APEX item from the region that triggered a dynamic action event	Use this combination to validate the item that has triggered a dynamic action event.
Item(s)	APEX item(s) defined as affected elements	Use this combination to validate the specified item(s) after a dynamic action event has been triggered in the specified region.
Column(s)	Not supported
Region	Item(s) that are defined under the specified region	Use this combination to trigger validation on items in the region that is specified in affected elements.
Region (interactive grid)	Not set	Any interactive grid column that triggered a dynamic action event	Use this combination to trigger validation on a currently edited column after the specified dynamic action event
Item(s)	Not supported
Column(s)	All column(s) defined as affected elements	Use this combination to validate column(s) specified as affected elements after any column in a currently edited row triggers a dynamic action event.
Region	Not supported
Column(s)	Not set	A column defined as a triggering element that triggered a dynamic action event	Use this combination to validate the column specified as a triggering element after it triggers a dynamic action event.
Item(s)	Not supported
Column(s)	Column(s) defined as affected elements	Use this combination to validate the columns specified as affected elements after columns specified as triggering elements trigger a dynamic action event.
Region	Not supported
Item(s)	Not set	Any item that is specified as a triggering element and which triggered a dynamic action event	Use this combination to validate an item immediately after it triggers a dynamic action event.
Item(s)	APEX item(s) defined as affected elements	Use this combination to validate affected element item(s) after the item specified as a triggering element triggers a dynamic action event.
Column(s)	Not supported
Region	Item(s) that are defined under region specified in affected elements	Use this combination to validate item(s) that are children of the affected elements region after item(s) specified as a triggering element trigger a dynamic action event.
Button	Not set	All page items	Use this combination to validate all page items after the button specified as a triggering element triggers a dynamic action event.
Item(s)	APEX item(s) defined as affected elements	Use this combination to validate item(s) specified as affected elements after the button specified as a triggering element triggers a dynamic action event.
Column(s)	Not supported
Region	Item(s) that are defined under region specified in affected elements	Use this combination to validate item(s) that are children of the affected elements region after the button specified as a triggering element triggers a dynamic action event.
document (framework events ie. Key Release, Change and so on)	Not set	APEX items(s) that can be mapped from a dynamic action event target	Use this combination to validate an item right after it triggers a dynamic action event. A dynamic action event property target is compared with existing APEX items and, if the event target references the APEX item, then it is validated.
Item(s)	APEX item(s) defined as affected elements	Use this combination to validate item(s) specified as affected elements after a dynamic action event is populated up to the document tree node.
Column(s)	Not supported
Region	Item(s) that are defined under region specified in affected elements	Use this combination to validate item(s) that are children of the affected elements region after a dynamic action event is populated up to the document tree node.
document (custom event)	Not set	All page items	Use this combination to validate all page items after a dynamic action custom event is populated up to the document tree node.
Item(s)	APEX item(s) defined as affected elements	Use this combination to validate item(s) specified as affected elements after a dynamic action custom event is populated up to the document tree node.
Column(s)	Not supported
Region	Item(s) that are defined under region specified in affected elements	Use this combination to validate item(s) that are children of affected elements region after a dynamic action custom event is populated up to the document tree node.

Oracle APEX Validations

The plug-in uses native Oracle APEX validations to validate items (or interactive grid columns) on the client-side (without an AJAX call) and on the server-side (using an AJAX call).

The Supported Validation and Supported Validation Conditions sections describe Oracle APEX validations and Oracle APEX validation conditions that are supported by the plug-in. Read these sections to learn which native Oracle APEX validations and validation conditions can be executed by the plug-in on the client-side and which are supported only on the server-side.

Supported Validation

Oracle APEX validations are supported by the plug-in if the icon is presented in the Server-side column. Oracle APEX validations can be executed on the client-side (without PL/SQL context) if the icon is presented in the Client-side column.

For example, the Rows returned validation is supported by the plug-in but it can only be evaluated server-side (in the context of PL/SQL using an AJAX call). This is because the validation needs to evaluate a SQL Query which defines the validation result. On the other hand, native validation Item is NOT NULL can be tested on the client-side because it tests whether the given item has a value - it can be tested without the context of PL/SQL.

Validation	Client-side	Server-side
Rows returned
No Rows returned
SQL Expression
PL/SQL Expression
PL/SQL Error
PL/SQL Function Body (returning Boolean)
PL/SQL Function (returning Error Text)
Item is NOT NULL
Item is NOT NULL or zero
Item is NOT zero
Item contains no spaces
Item is alphanumeric
Item is numeric
Item is a valid date
Item is a valid timestamp
Item = Value
Item != Value
Item is contained in Value
Item is NOT contained in Value
Item contains only characters specified in Value
Item contains at least one of the characters in Value
Item does NOT contain any of the characters in Value
Item matches Regular Expression

Supported Validation Conditions

Oracle APEX validations conditions are supported by the plug-in if the icon is presented in Server-side column. Oracle APEX validation conditions can be evaluated on the client-side (without PL/SQL context) if the icon is presented in Client-side column.

For example, the PL/SQL Function Body validation condition requires PL/SQL context to evaluate an anonymous PL/SQL function, thus it can be executed only on the server-side (using an AJAX call).

Condition	Server-side	Client-side
Rows returned
No Rows returned
SQL Expression
PL/SQL Expression
PL/SQL Function Body
Request = Value
Request != Value
Request is contained in Value
Request is NOT contained in Value
Item = Value
Item != Value
Item is NULL
Item is NOT NULL
Item is zero
Item is NOT zero
Item is NULL or zero
Item is NOT NULL and NOT zero
Item contains no spaces
Item is numeric
Item is NOT numeric
Item is alphanumeric
Item is in colon delimited list
Item is NOT in colon delimited list
User Preference = Value
User Preference != Value
Current Page = Page
Current Page != Page
Current Page is in comma delimited list
Current Page is NOT in comma delimited list
Current Page is in Printer Friendly Mode
Current page is NOT in Printer Friendly Mode
Page/Region is Read Only
Page/Region is NOT Read Only
User is Authenticated (not public)
User is the Public User (user has not authenticated)
Inline Validation Errors displayed
Inline Validation Errors NOT displayed
Current Language = Value
Current Language != Value
Current Language is contained in Value
Current Language is NOT contained in Value
Never

HTML5 Validations

HTML5 validations are performed for APEX items and interactive grid columns that have the required attribute set or have a subtype specified as URL, Phone, or E-mail.