Dynamic Action
Dynamic Action
Section titled “Dynamic Action”The plug-in implements the Oracle APEX dynamic action plug-in API.
Application Attributes
Section titled “Application Attributes”Application attributes are set immediatley after installing the plug-in and can be changed in Shared Components // Component Settings. The plug-in exposes 3 application attributes that are used to save, fetch, and delete end-user defined chart reports.
Procedure - Save chart report
Section titled “Procedure - Save chart report”An example implementation is part of the sample application supporting objects. Learn more in the Sample Application section.
The procedure saves the current changes applied to the Oracle APEX JET chart when the end-user selects the plug-in Reports // Save functionality. The procedure must implement the following parameters and insert the plug-in data into a defined table.
| Parameter | Direction | Type | Description |
|---|---|---|---|
| pi/_user | IN | VARCHAR2 | The current end-user username. |
| pi/_region/_id | IN | VARCHAR2 | Chart region id (static id if defined). |
| pi/_report/_name | IN | VARCHAR2 | The report name given by the end-user. |
| pi/_keys | IN | VARCHAR2 | A colon-separated list of JET chart attributes to be saved. |
| pi/_values | IN | VARCHAR2 | A colon-separated list of JET chart attribute values to be saved. |
| po/_message | OUT | VARCHAR2 | Message to be displayed after successfully saving a chart report. |
| po/_status | OUT | BOOLEAN | If true, a message is displayed using apex.message.showPageSuccess. Otherwise, a message is displayed using apex.message.showErrors. |
Procedure - Fetch chart reports
Section titled “Procedure - Fetch chart reports”An example implementation is part of the sample application supporting objects. Learn more in the Sample Application section.
The procedure fetches all saved Oracle APEX JET chart reports for the current user. The procedure must implement the following parameters and select an existing chart report’s data from a defined table.
| Parameter | Direction | Type | Description |
|---|---|---|---|
| pi/_user | IN | VARCHAR2 | The current end-user username. |
| pi/_region/_id | IN | VARCHAR2 | Chart region id (static id if defined). |
| po/_reports | OUT | VARCHAR2 | A colon-separated list of the plug-in chart reports names |
| po/_keys | OUT | VARCHAR2 | A colon-separated list of the JET chart attributes to be saved. |
| po/_values | OUT | VARCHAR2 | A colon-separated list of the JET chart attribute values to be saved. |
Procedure - Delete chart report
Section titled “Procedure - Delete chart report”An example implementation is part of the sample application supporting objects. Learn more in the Sample Application section.
The procedure deletes the selected saved Oracle APEX JET chart report for the current user. The procedure must implement the following parameters and it deletes a existing chart report’s data from a defined table.
| Parameter | Direction | Type | Description |
|---|---|---|---|
| pi/_user | IN | VARCHAR2 | The current end-user username. |
| pi/_region/_id | IN | VARCHAR2 | Chart region id (static id if defined). |
| pi/_report/_name | IN | VARCHAR2 | The report name given by the end-user. |
| po/_message | OUT | VARCHAR2 | Message to be displayed after successfully deleting a chart report. |
| po/_status | OUT | BOOLEAN | If true, a message is displayed using apex.message.showPageSuccess. Otherwise, a message is displayed using apex.message.showErrors. |
Standard
Section titled “Standard”Standard attributes define what APEX components will be exposed via dynamic action affected elements. The plug-in uses 2 standard attributes: For Region and Affected Element Required.
| Attribute | Supported |
|---|---|
| For Item(s) |  |
| For Button | |
| For Region |  |
| For jQuery Selector | |
| For JavaScript Expression | |
| For Triggering Element | |
| For Event Source | |
| Affected Element Required | |
| Check “Fire on Initialization” | |
| Has “Stop Execution on Error” Attribute | |
| Has “Wait For Result” Attribute | |
| Has “Initialization JavaScript Code” Attribute | |
Custom Attributes
Section titled “Custom Attributes”Custom Attributes are attributes exposed for the APEX page designer. The plug-in doesn’t expose any custom attributes.