dynamicAction
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
name | string | Yes | data type=string; maxLen=255Enter the name of the dynamic action. |
execution
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
sequence | number | Yes | data type=number; maxLen=22 | |
eventScope | enum | Yes | static | data type=string; lov=STATICValid values: static dynamic once |
staticContainer | string | No | data type=string; maxLen=255Applies when eventScope = dynamic | |
type | enum | Yes | immediate | data type=string; lov=STATICValid values: immediate debounce throttleApplies when eventScope in (static)eventScope in (dynamic) |
time | integer | Yes | data type=integer; maxLen=32767Applies when eventScope in (static) and type in (debounce)eventScope in (static) and type in (throttle)eventScope in (dynamic) and type in (debounce)eventScope in (dynamic) and type in (throttle) | |
immediate | boolean | Yes | false | data type=booleanApplies when eventScope in (static) and type in (debounce)eventScope in (static) and type in (throttle)eventScope in (dynamic) and type in (debounce)eventScope in (dynamic) and type in (throttle) |
execution {
sequence: 42
eventScope: static
staticContainer: value
type: immediate
time: 42
immediate: false
}when
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
event | string | Yes | change | data type=string; lov=EVENTS |
customEvent | string | Yes | data type=string; maxLen=130Applies when event = custom | |
selectionType | enum | Yes | data type=string; lov=STATICValid values: items button region columns domObject jQuerySelector jsExpression | |
region | reference | Yes | data type=reference; lov=COMPONENT; references=regionApplies when selectionType = region | |
interactiveGrid | reference | Yes | data type=reference; lov=COMPONENT; references=regionApplies when selectionType = columns | |
columns | array of strings | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when selectionType = columns | |
button | reference | Yes | data type=reference; lov=COMPONENT; references=buttonApplies when selectionType = button | |
items | array of strings | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when selectionType = items | |
domObject | string | Yes | data type=string; maxLen=4000Applies when selectionType = domObject | |
jquerySelector | string | Yes | data type=string; maxLen=4000Applies when selectionType = jQuerySelector | |
javaScriptExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when selectionType = jsExpression |
when {
event: value
customEvent: value
selectionType: items
region: @component
interactiveGrid: @component
columns: [
value
value
]
button: @component
items: [
value
value
]
domObject: value
jquerySelector: value
javaScriptExpression: ```javascript-browser
value
```
}clientSideCondition
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
type | enum | No | data type=string; lov=STATICValid values: item=value item!=value item>value item>=value item<value item<=value itemIsNull itemIsNotNull itemIsInList itemIsNotInList jsExpressionApplies when selectionType = columns and selectionType = region and region does not support IG_REGION | |
item | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when selectionType = columns and selectionType = region and region does not support IG_REGION and type in (item=value)selectionType = columns and selectionType = region and region does not support IG_REGION and type in (item!=value)selectionType = columns and selectionType = region and region does not support IG_REGION and type in (item>value)selectionType = columns and selectionType = region and region does not support IG_REGION and type in (item>=value)selectionType = columns and selectionType = region and region does not support IG_REGION and type in (item<value)selectionType = columns and selectionType = region and region does not support IG_REGION and type in (item<=value)selectionType = columns and selectionType = region and region does not support IG_REGION and type in (itemIsNull)selectionType = columns and selectionType = region and region does not support IG_REGION and type in (itemIsNotNull)selectionType = columns and selectionType = region and region does not support IG_REGION and type in (itemIsInList)selectionType = columns and selectionType = region and region does not support IG_REGION and type in (itemIsNotInList)Enter the page item used in this condition. You can type in the name or pick from the list of available items. | |
value | string | Yes | data type=string; maxLen=4000Applies when selectionType = columns and selectionType = region and region does not support IG_REGION and type in (item=value)selectionType = columns and selectionType = region and region does not support IG_REGION and type in (item!=value)selectionType = columns and selectionType = region and region does not support IG_REGION and type in (item>value)selectionType = columns and selectionType = region and region does not support IG_REGION and type in (item>=value)selectionType = columns and selectionType = region and region does not support IG_REGION and type in (item<value)selectionType = columns and selectionType = region and region does not support IG_REGION and type in (item<=value) | |
list | array of strings | Yes | data type=string; maxLen=4000Applies when selectionType = columns and selectionType = region and region does not support IG_REGION and type in (itemIsInList)selectionType = columns and selectionType = region and region does not support IG_REGION and type in (itemIsNotInList) | |
javaScriptExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when selectionType = columns and selectionType = region and region does not support IG_REGION and type = jsExpression | |
type | enum | No | data type=string; lov=STATICValid values: itemColumn=value itemColumn!=value itemColumn>value itemColumn>=value itemColumn<value itemColumn<=value itemColumnIsNull itemColumnIsNotNull itemColumnIsInList itemColumnIsNotInList jsExpressionApplies when selectionType = columns and interactiveGrid is setselectionType = region and region supports IG_REGION | |
componentType | enum | Yes | column | data type=string; lov=STATICValid values: item columnApplies when selectionType = columns and interactiveGrid is set and type in (itemColumn=value)selectionType = columns and interactiveGrid is set and type in (itemColumn!=value)selectionType = columns and interactiveGrid is set and type in (itemColumn>value)selectionType = columns and interactiveGrid is set and type in (itemColumn>=value)selectionType = columns and interactiveGrid is set and type in (itemColumn<value)selectionType = columns and interactiveGrid is set and type in (itemColumn<=value)selectionType = columns and interactiveGrid is set and type in (itemColumnIsNull)selectionType = columns and interactiveGrid is set and type in (itemColumnIsNotNull)selectionType = columns and interactiveGrid is set and type in (itemColumnIsInList)selectionType = columns and interactiveGrid is set and type in (itemColumnIsNotInList)selectionType = region and region supports IG_REGION and type in (itemColumn=value)selectionType = region and region supports IG_REGION and type in (itemColumn!=value)selectionType = region and region supports IG_REGION and type in (itemColumn>value)selectionType = region and region supports IG_REGION and type in (itemColumn>=value)selectionType = region and region supports IG_REGION and type in (itemColumn<value)selectionType = region and region supports IG_REGION and type in (itemColumn<=value)selectionType = region and region supports IG_REGION and type in (itemColumnIsNull)selectionType = region and region supports IG_REGION and type in (itemColumnIsNotNull)selectionType = region and region supports IG_REGION and type in (itemColumnIsInList)selectionType = region and region supports IG_REGION and type in (itemColumnIsNotInList) |
item | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when selectionType = columns and interactiveGrid is set and type in (itemColumn=value) and componentType = itemselectionType = columns and interactiveGrid is set and type in (itemColumn!=value) and componentType = itemselectionType = columns and interactiveGrid is set and type in (itemColumn>value) and componentType = itemselectionType = columns and interactiveGrid is set and type in (itemColumn>=value) and componentType = itemselectionType = columns and interactiveGrid is set and type in (itemColumn<value) and componentType = itemselectionType = columns and interactiveGrid is set and type in (itemColumn<=value) and componentType = itemselectionType = columns and interactiveGrid is set and type in (itemColumnIsNull) and componentType = itemselectionType = columns and interactiveGrid is set and type in (itemColumnIsNotNull) and componentType = itemselectionType = columns and interactiveGrid is set and type in (itemColumnIsInList) and componentType = itemselectionType = columns and interactiveGrid is set and type in (itemColumnIsNotInList) and componentType = itemselectionType = region and region supports IG_REGION and type in (itemColumn=value) and componentType = itemselectionType = region and region supports IG_REGION and type in (itemColumn!=value) and componentType = itemselectionType = region and region supports IG_REGION and type in (itemColumn>value) and componentType = itemselectionType = region and region supports IG_REGION and type in (itemColumn>=value) and componentType = itemselectionType = region and region supports IG_REGION and type in (itemColumn<value) and componentType = itemselectionType = region and region supports IG_REGION and type in (itemColumn<=value) and componentType = itemselectionType = region and region supports IG_REGION and type in (itemColumnIsNull) and componentType = itemselectionType = region and region supports IG_REGION and type in (itemColumnIsNotNull) and componentType = itemselectionType = region and region supports IG_REGION and type in (itemColumnIsInList) and componentType = itemselectionType = region and region supports IG_REGION and type in (itemColumnIsNotInList) and componentType = item | |
column | string | Yes | data type=string; maxLen=4000Applies when selectionType = columns and interactiveGrid is set and type in (itemColumn=value) and componentType = columnselectionType = columns and interactiveGrid is set and type in (itemColumn!=value) and componentType = columnselectionType = columns and interactiveGrid is set and type in (itemColumn>value) and componentType = columnselectionType = columns and interactiveGrid is set and type in (itemColumn>=value) and componentType = columnselectionType = columns and interactiveGrid is set and type in (itemColumn<value) and componentType = columnselectionType = columns and interactiveGrid is set and type in (itemColumn<=value) and componentType = columnselectionType = columns and interactiveGrid is set and type in (itemColumnIsNull) and componentType = columnselectionType = columns and interactiveGrid is set and type in (itemColumnIsNotNull) and componentType = columnselectionType = columns and interactiveGrid is set and type in (itemColumnIsInList) and componentType = columnselectionType = columns and interactiveGrid is set and type in (itemColumnIsNotInList) and componentType = columnselectionType = region and region supports IG_REGION and type in (itemColumn=value) and componentType = columnselectionType = region and region supports IG_REGION and type in (itemColumn!=value) and componentType = columnselectionType = region and region supports IG_REGION and type in (itemColumn>value) and componentType = columnselectionType = region and region supports IG_REGION and type in (itemColumn>=value) and componentType = columnselectionType = region and region supports IG_REGION and type in (itemColumn<value) and componentType = columnselectionType = region and region supports IG_REGION and type in (itemColumn<=value) and componentType = columnselectionType = region and region supports IG_REGION and type in (itemColumnIsNull) and componentType = columnselectionType = region and region supports IG_REGION and type in (itemColumnIsNotNull) and componentType = columnselectionType = region and region supports IG_REGION and type in (itemColumnIsInList) and componentType = columnselectionType = region and region supports IG_REGION and type in (itemColumnIsNotInList) and componentType = column | |
value | string | Yes | data type=string; maxLen=4000Applies when selectionType = columns and interactiveGrid is set and type in (itemColumn=value)selectionType = columns and interactiveGrid is set and type in (itemColumn!=value)selectionType = columns and interactiveGrid is set and type in (itemColumn>value)selectionType = columns and interactiveGrid is set and type in (itemColumn>=value)selectionType = columns and interactiveGrid is set and type in (itemColumn<value)selectionType = columns and interactiveGrid is set and type in (itemColumn<=value)selectionType = region and region supports IG_REGION and type in (itemColumn=value)selectionType = region and region supports IG_REGION and type in (itemColumn!=value)selectionType = region and region supports IG_REGION and type in (itemColumn>value)selectionType = region and region supports IG_REGION and type in (itemColumn>=value)selectionType = region and region supports IG_REGION and type in (itemColumn<value)selectionType = region and region supports IG_REGION and type in (itemColumn<=value) | |
list | array of strings | Yes | data type=string; maxLen=4000Applies when selectionType = columns and interactiveGrid is set and type in (itemColumnIsInList)selectionType = columns and interactiveGrid is set and type in (itemColumnIsNotInList)selectionType = region and region supports IG_REGION and type in (itemColumnIsInList)selectionType = region and region supports IG_REGION and type in (itemColumnIsNotInList) | |
javaScriptExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when selectionType = columns and interactiveGrid is set and type = jsExpressionselectionType = region and region supports IG_REGION and type = jsExpression |
clientSideCondition {
type: "item=value"
item: value
value: value
list: [
value
value
]
javaScriptExpression: ```javascript-browser
value
```
componentType: item
column: value
}advanced
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
staticId | string | Yes | data type=string; maxLen=255 |
advanced {
staticId: value
}serverSideCondition
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
type | enum | No | data type=string; lov=STATICValid values: always rowsReturned noRowsReturned expression functionBody request=Value request!=Value requestIsContainedInValue requestIsNotContainedInValue item=value item!=value itemIsNull itemIsNotNull itemIsZero itemIsNotZero itemIsNullOrZero itemIsNotNullAndNotZero itemContainsNoSpaces itemIsNumeric itemIsNotNumeric itemIsAlphanumeric itemIsInColonDelimitedList itemIsNotInColonDelimitedList textIsContainedInItem text=value text!=value textIsContainedInValue textIsNotContainedInValue userPreference=value userPreference!=value currentPage=page currentPage!=page currentPageInList currentPageNotInList currentPage=pageSubmitted currentPage!=pageSubmitted currentPageIsInPrinterFriendlyMode currentPageIsNotInPrinterFriendlyMode pageRegionIsReadOnly pageRegionIsNotReadOnly userIsAuthenticated userIsPublicUser inlineValidationErrorsDisplayed inlineValidationErrorsNotDisplayed sqlReportsOkToShowForwardButton sqlReportsOkToShowBackButton currentLanguage=value currentLanguage!=value currentLanguageIsContainedInValue currentLanguageIsNotContainedInValue clientBrowserIsMozilla clientBrowserIsIE7higher clientBrowserIsXhtmlCssCapable clientBrowserIsOther cgiEnvDadName=value cgiEnvDadName!=value cgiEnvServerName=value cgiEnvServerName!=value cgiEnvHttpHost=value cgiEnvHttpHost!=value neverSelect a condition type to be met in order for this dynamic action to be active. | |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type in (rowsReturned)type in (noRowsReturned) | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: sql plsql javaScript-mleApplies when type = expression |
sqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = expression and language = sql | |
plsqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = expression and language = plsql | |
javaScriptExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = expression and language = javaScript-mle | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when type = functionBody |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = functionBody and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = functionBody and language = javaScript-mle | |
value | string | Yes | data type=string; maxLen=4000Applies when type in (request=Value)type in (request!=Value)type in (requestIsContainedInValue)type in (requestIsNotContainedInValue)type in (currentLanguageIsContainedInValue)type in (currentLanguageIsNotContainedInValue)type in (currentLanguage!=value)type in (currentLanguage=value)type in (cgiEnvDadName=value)type in (cgiEnvDadName!=value)type in (cgiEnvServerName=value)type in (cgiEnvServerName!=value)type in (cgiEnvHttpHost=value)type in (cgiEnvHttpHost!=value) | |
item | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when type in (item=value)type in (item!=value)type in (VALUE_OF_ITEM_IN_COND_1_EQ_COND_2)type in (VALUE_OF_ITEM_IN_COND_1_NOT_EQ_COND_2)type in (itemIsNull)type in (itemIsNotNull)type in (itemIsZero)type in (itemIsNotZero)type in (itemIsNullOrZero)type in (itemIsNotNullAndNotZero)type in (itemContainsNoSpaces)type in (itemIsNumeric)type in (itemIsNotNumeric)type in (itemIsAlphanumeric)type in (itemIsInColonDelimitedList)type in (itemIsNotInColonDelimitedList) | |
preference | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when type in (userPreference=value)type in (userPreference!=value) | |
page | integer | Yes | data type=integer; maxLen=4000Applies when type in (currentPage=page)type in (currentPage!=page) | |
pages | array of integers | Yes | data type=integer; maxLen=4000Applies when type in (currentPageInList)type in (currentPageNotInList) | |
text | string | Yes | data type=string; maxLen=4000Applies when type in (textIsContainedInItem)type in (textIsContainedInValue)type in (textIsNotContainedInValue)type in (text=value)type in (text!=value) | |
value | string | Yes | data type=string; maxLen=4000Applies when type in (item=value)type in (item!=value)type in (VALUE_OF_ITEM_IN_COND_1_EQ_COND_2)type in (VALUE_OF_ITEM_IN_COND_1_NOT_EQ_COND_2) | |
list | array of strings | Yes | data type=string; maxLen=4000Applies when type in (itemIsInColonDelimitedList)type in (itemIsNotInColonDelimitedList) | |
item | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when type = textIsContainedInItem | |
value | string | Yes | data type=string; maxLen=4000Applies when type in (textIsContainedInValue)type in (textIsNotContainedInValue)type in (text=value)type in (text!=value) |
serverSideCondition {
type: always
sqlQuery: ```sql
value
```
language: sql
sqlExpression: ```sql
value
```
plsqlExpression: ```plsql
value
```
javaScriptExpression: ```javascript-mle
value
```
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
value: value
item: value
preference: value
page: 42
pages: [
42
42
]
text: value
list: [
value
value
]
}security
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
authorizationScheme | enum | No | data type=reference; lov=COMPONENT; references=authorizationValid values: mustNotBePublicUser |
security {
authorizationScheme: mustNotBePublicUser
}config
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
buildOption | reference | No | data type=reference; lov=COMPONENT; references=buildOption |
config {
buildOption: @component
}comments
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
comments | multiline string | No | data type=multiline string; maxLen=4000 |
comments {
comments: ```
value
```
}APEXlang Example
dynamicAction sample (
name: value
execution {
sequence: 42
eventScope: static
staticContainer: value
type: immediate
time: 42
immediate: false
}
when {
event: value
customEvent: value
selectionType: items
region: @component
interactiveGrid: @component
columns: [
value
value
]
button: @component
items: [
value
value
]
domObject: value
jquerySelector: value
javaScriptExpression: ```javascript-browser
value
```
}
clientSideCondition {
type: "item=value"
item: value
value: value
list: [
value
value
]
javaScriptExpression: ```javascript-browser
value
```
componentType: item
column: value
}
advanced {
staticId: value
}
serverSideCondition {
type: always
sqlQuery: ```sql
value
```
language: sql
sqlExpression: ```sql
value
```
plsqlExpression: ```plsql
value
```
javaScriptExpression: ```javascript-mle
value
```
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
value: value
item: value
preference: value
page: 42
pages: [
42
42
]
text: value
list: [
value
value
]
}
security {
authorizationScheme: mustNotBePublicUser
}
config {
buildOption: @component
}
comments {
comments: ```
value
```
}
)