validation
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
name | string | Yes | data type=string; maxLen=255Enter the name for the validation. This name should be descriptive so that developers can easily identify conditions being checked. |
execution
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
sequence | number | Yes | data type=number; maxLen=22 |
execution {
sequence: 42
}validation
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
editableRegion | reference | No | data type=reference; lov=COMPONENT; references=region | |
type | enum | Yes | expression | data type=string; lov=STATICValid values: rowsReturned noRowsReturned expression plsqlError functionBodyReturningBoolean functionBody itemIsNotNull itemIsNotNullOrZero itemIsNotZero itemContainsNoSpaces itemIsAlphanumeric itemIsNumeric itemIsAValidDate itemIsAValidTimestamp item=Value item!=Value itemIsContainedInValue itemIsNotContainedInValue itemContainsOnlyCharsInValue itemContainsAtLeastOneOfCharsInValue itemContainsNoneOfCharsInValue itemMatchesRegexp |
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 = functionBodyReturningBoolean |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = functionBodyReturningBoolean and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = functionBodyReturningBoolean 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 | |
plsqlCodeRaisingError | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = plsqlError | |
item | string | Yes | data type=string; maxLen=255; textCase=UPPER | |
regexp | string | Yes | data type=string; maxLen=4000Applies when type = itemMatchesRegexp | |
value | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type in (item=Value)type in (item!=Value)type in (itemIsContainedInValue)type in (itemIsNotContainedInValue)type in (itemContainsAtLeastOneOfCharsInValue)type in (itemContainsOnlyCharsInValue)type in (itemContainsNoneOfCharsInValue) | |
type | enum | Yes | expression | data type=string; lov=STATICValid values: rowsReturned noRowsReturned expression plsqlError functionBodyReturningBoolean functionBody columnIsNotNull columnIsNotNullOrZero columnIsNotZero columnContainsNoSpaces columnIsAlphanumeric columnIsNumeric columnIsAValidDate columnIsAValidTimestamp column=Value column!=Value columnIsContainedInValue columnIsNotContainedInValue columnContainsOnlyCharsInValue columnContainsAtLeastOneOfCharsInValue columnContainsNoneOfCharsInValue columnMatchesRegexpApplies when editableRegion is set |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=4000Applies when editableRegion is set and type in (rowsReturned)editableRegion is set and type in (noRowsReturned) | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: sql plsql javaScript-mleApplies when editableRegion is set and type = expression |
sqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when editableRegion is set and type = expression and language = sql | |
plsqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when editableRegion is set and type = expression and language = plsql | |
javaScriptExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when editableRegion is set and type = expression and language = javaScript-mle | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when editableRegion is set and type = functionBodyReturningBoolean |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when editableRegion is set and type = functionBodyReturningBoolean and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when editableRegion is set and type = functionBodyReturningBoolean and language = javaScript-mle | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when editableRegion is set and type = functionBody |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when editableRegion is set and type = functionBody and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when editableRegion is set and type = functionBody and language = javaScript-mle | |
plsqlCodeRaisingError | multiline string | Yes | data type=multiline string; maxLen=4000Applies when editableRegion is set and type = plsqlError | |
column | string | Yes | data type=string; maxLen=128Applies when editableRegion is set | |
regexp | string | Yes | data type=string; maxLen=4000Applies when editableRegion is set and type = columnMatchesRegexp | |
value | multiline string | Yes | data type=multiline string; maxLen=4000Applies when editableRegion is set and type in (column=Value)editableRegion is set and type in (column!=Value)editableRegion is set and type in (columnIsContainedInValue)editableRegion is set and type in (columnIsNotContainedInValue)editableRegion is set and type in (columnContainsAtLeastOneOfCharsInValue)editableRegion is set and type in (columnContainsOnlyCharsInValue)editableRegion is set and type in (columnContainsNoneOfCharsInValue) | |
alwaysExecute | boolean | Yes | false | data type=boolean |
validation {
editableRegion: @component
type: rowsReturned
sqlQuery: ```sql
value
```
language: sql
sqlExpression: ```sql
value
```
plsqlExpression: ```plsql
value
```
javaScriptExpression: ```javascript-mle
value
```
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
plsqlCodeRaisingError: ```plsql
value
```
item: value
regexp: value
value: ```
value
```
column: value
alwaysExecute: false
}advanced
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
staticId | string | Yes | data type=string; maxLen=255 |
advanced {
staticId: value
}error
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
errorMessage | multiline string | Yes | data type=multiline string; maxLen=4000Applies when editableRegion is set | |
displayLocation | enum | Yes | inlineWithFieldAndInNotification | data type=string; lov=STATICValid values: inlineWithFieldAndInNotification inlineWithField inlineInNotification onErrorPage |
associatedItem | reference | No | data type=reference; lov=COMPONENT; references=pageItem | |
associatedColumn | string | No | data type=string; maxLen=255Applies when editableRegion is set |
error {
errorMessage: ```
value
```
displayLocation: inlineWithFieldAndInNotification
associatedItem: @component
associatedColumn: value
}serverSideCondition
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
whenButtonPressed | reference | No | data type=reference; lov=COMPONENT; references=button | |
executionScope | enum | Yes | forCreatedAndModifiedRows | data type=string; lov=STATICValid values: forCreatedAndModifiedRows allSubmittedRowsApplies when editableRegion is set |
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 never | |
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) | |
executeCondition | enum | Yes | forEachRow | data type=string; lov=STATICValid values: forEachRow onceApplies when editableRegion is set and type is set |
serverSideCondition {
whenButtonPressed: @component
executionScope: forCreatedAndModifiedRows
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
]
executeCondition: forEachRow
}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
validation sample (
name: value
execution {
sequence: 42
}
validation {
editableRegion: @component
type: rowsReturned
sqlQuery: ```sql
value
```
language: sql
sqlExpression: ```sql
value
```
plsqlExpression: ```plsql
value
```
javaScriptExpression: ```javascript-mle
value
```
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
plsqlCodeRaisingError: ```plsql
value
```
item: value
regexp: value
value: ```
value
```
column: value
alwaysExecute: false
}
advanced {
staticId: value
}
error {
errorMessage: ```
value
```
displayLocation: inlineWithFieldAndInNotification
associatedItem: @component
associatedColumn: value
}
serverSideCondition {
whenButtonPressed: @component
executionScope: forCreatedAndModifiedRows
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
]
executeCondition: forEachRow
}
security {
authorizationScheme: mustNotBePublicUser
}
config {
buildOption: @component
}
comments {
comments: ```
value
```
}
)