pageItem (textarea)
type = textarea| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
name | string | Yes | P#PAGE_ID#_NEW | data type=string; maxLen=255; textCase=UPPER |
type | enum | Yes | data type=string; lov=PLUGINSValid values: textarea |
settings
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
resizable | boolean | Yes | true | data type=boolean |
autoHeight | boolean | Yes | false | data type=boolean |
charCounter | boolean | Yes | false | data type=boolean |
trimSpaces | enum | Yes | leadingAndTrailing | data type=string; maxLen=4000; lov=STATICValid values: leading none leadingAndTrailing trailing |
settings {
resizable: false
autoHeight: false
charCounter: false
trimSpaces: leading
}label
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
label | string | No | data type=string; maxLen=4000Applies when type supports VISIBLE | |
alignment | enum | Yes | rightCenter | data type=string; lov=STATICValid values: above below center centerBottom centerCenter centerTop left leftBottom leftCenter leftTop right rightBottom rightCenter rightTopApplies when type supports VISIBLE |
tableCellAttributes | array of strings | No | data type=string; maxLen=255Applies when type supports VISIBLE |
label {
label: value
alignment: above
tableCellAttributes: [
value
value
]
}lov
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
type | enum | No | data type=string; lov=STATICValid values: sharedComponent sqlQuery staticValues functionBodyApplies when type supports LOV | |
lov | reference | Yes | data type=reference; lov=COMPONENT; references=lovApplies when type supports LOV and type = sharedComponent | |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports LOV and type = sqlQueryEnter the SQL query definition to populate this list of values. Generally list of value queries are of the form:
select [displayValue],
[returnValue]
from ...
where ...
order by ...
Each column selected must have a unique name or alias. Oracle recommends using an alias on any column that includes an SQL expression. Note: When defining a Popup LOV item type, if you would like to display multiple columns in the popup, you must instead define your List of Values in Shared Components, with the required additional metadata. Inline list of values can only be used to display single columns for Popup LOVs. | |
staticValues | multiline string | Yes | STATIC:Display1;Return1,Display2;Return2 | data type=multiline string; maxLen=4000Applies when type supports LOV and type = staticValues |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when type supports LOV and type = functionBody |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=32767Applies when type supports LOV and type = functionBody and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=32767Applies when type supports LOV and type = functionBody and language = javaScript-mle | |
displayExtraValues | boolean | Yes | true | data type=booleanApplies when type supports LOV and type is set |
displayNullValue | boolean | Yes | true | data type=booleanApplies when type supports LOV_DISPLAY_NULL and type supports LOV and type is set |
nullDisplayValue | string | No | data type=string; maxLen=255Applies when type supports LOV_DISPLAY_NULL and type supports LOV and type is set and displayNullValue = true | |
nullReturnValue | string | No | data type=string; maxLen=255Applies when type supports LOV_DISPLAY_NULL and type supports LOV and type is set and displayNullValue = true |
lov {
type: sharedComponent
lov: @component
sqlQuery: ```sql
value
```
staticValues: ```
value
```
language: plsql
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
displayExtraValues: false
displayNullValue: false
nullDisplayValue: value
nullReturnValue: value
}cascadingLov
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
parentItems | array of strings | No | data type=string; maxLen=255; textCase=UPPERApplies when type supports CASCADING_LOV and type supports LOV and type is set | |
itemsToSubmit | array of strings | No | data type=string; maxLen=4000; textCase=UPPERApplies when type supports CASCADING_LOV and type supports LOV and type is set and parentItems is set | |
parentRequired | boolean | Yes | true | data type=booleanApplies when type supports CASCADING_LOV and type supports LOV and type is set and parentItems is set |
cascadingLov {
parentItems: [
value
value
]
itemsToSubmit: [
value
value
]
parentRequired: false
}genAI
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
enabled | boolean | Yes | false | data type=booleanApplies when type supports AI_ENABLED |
agent | reference | No | data type=reference; lov=COMPONENT; references=aiAgentApplies when type supports AI_ENABLED_ALWAYS and type supports AI_ENABLED and enabled = truetype supports AI_ENABLED and enabled = true | |
service | reference | No | data type=reference; lov=COMPONENT; references=genAIServiceApplies when type supports AI_ENABLED_ALWAYS and type supports AI_ENABLED and enabled = truetype supports AI_ENABLED and enabled = true | |
systemPrompt | multiline string | No | data type=multiline string; maxLen=32767Applies when type supports AI_SYSTEM_PROMPT and type supports AI_ENABLED_ALWAYS and type supports AI_ENABLED and enabled = truetype supports AI_SYSTEM_PROMPT and type supports AI_ENABLED and enabled = true | |
welcomeMessage | multiline string | No | data type=multiline string; maxLen=32767Applies when type supports AI_UI and type supports AI_ENABLED_ALWAYS and type supports AI_ENABLED and enabled = truetype supports AI_UI and type supports AI_ENABLED and enabled = true |
genAI {
enabled: false
agent: @component
service: @component
systemPrompt: ```
value
```
welcomeMessage: ```html
value
```
}multipleValues
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
type | enum | Yes | delimitedList | data type=string; lov=STATICValid values: delimitedList jsonArrayApplies when type supports MULTI_VALUE_ALWAYS |
type | enum | No | data type=string; lov=STATICValid values: delimitedList jsonArrayApplies when type supports MULTI_VALUE_OPTIONALtype supports MULTI_VALUE_OPTIONAL and page_action_on_selection = NONE | |
separator | string | Yes | : | data type=string; maxLen=5Applies when type supports MULTI_VALUE_ALWAYS and type = delimitedListtype supports MULTI_VALUE_OPTIONAL and type = delimitedListtype supports MULTI_VALUE_OPTIONAL and page_action_on_selection = NONE and type = delimitedList |
multipleValues {
type: delimitedList
separator: value
}layout
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
sequence | number | Yes | data type=number; maxLen=22 | |
region | reference | No | data type=reference; lov=COMPONENT; references=regionSelect the region in which the item will be displayed. | |
slot | string | Yes | data type=string; lov=SLOTS | |
alignment | enum | Yes | leftCenter | data type=string; lov=STATICValid values: center centerBottom centerCenter centerTop left leftBottom leftCenter leftTop right rightBottom rightCenter rightTopApplies when type supports ELEMENT |
startNewLayout | boolean | Yes | false | data type=booleanApplies when type supports VISIBLE |
startNewRow | boolean | Yes | true | data type=booleanApplies when type supports VISIBLE and startNewLayout = false |
rowCssClasses | array of strings | No | data type=string; maxLen=255Applies when type supports VISIBLE | |
column | string | No | data type=string; lov=GRID_COLUMNSApplies when type supports VISIBLE | |
newColumn | boolean | Yes | true | data type=booleanApplies when type supports VISIBLE and startNewLayout = false and startNewRow = false |
columnSpan | string | No | data type=string; lov=GRID_COLUMNSApplies when type supports VISIBLE | |
rowSpan | number | No | data type=number; maxLen=22Applies when type supports VISIBLE | |
labelColumnSpan | string | No | data type=string; lov=GRID_COLUMNSApplies when type supports VISIBLE | |
columnCssClasses | array of strings | No | data type=string; maxLen=255Applies when type supports VISIBLE | |
columnAttributes | array of strings | No | data type=string; maxLen=255Applies when type supports VISIBLE |
layout {
sequence: 42
region: @component
slot: value
alignment: center
startNewLayout: false
startNewRow: false
rowCssClasses: [
value
value
]
column: value
newColumn: false
columnSpan: value
rowSpan: 42
labelColumnSpan: value
columnCssClasses: [
value
value
]
columnAttributes: [
value
value
]
}appearance
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
template | reference | No | data type=reference; lov=COMPONENT; references=fieldTemplateApplies when type supports VISIBLE | |
templateOptions | array of strings | No | data type=string; lov=TEMPLATE_OPTIONSApplies when type supports VISIBLE and template is set | |
cssClasses | array of strings | No | data type=string; maxLen=255Applies when type supports VISIBLE and template is setEnter classes to add to this item. You may add multiple classes by separating them with spaces. This property can be used to make style modifications to the item, beyond template options, or to provide a simpler way of selecting this item via JavaScript. Note: To apply CSS classes to the HTML form element tag, please see the CSS Classes property under the Advanced group. | |
icon | string | No | data type=string; maxLen=255Applies when type supports ICONEnter the classes for the icon you want to add to the component. You may add multiple classes by separating them with spaces. If your theme uses Font APEX then review the Universal Theme Sample Application to view available icons and modifiers. Note: This icon will be displayed inside of the item, not as part of the label. | |
formatMask | string | No | data type=string; maxLen=255Applies when type supports FORMAT_MASK_ALL | |
formatMask | string | No | data type=string; maxLen=255Applies when type supports FORMAT_MASK_DATE | |
formatMask | string | No | data type=string; maxLen=255Applies when type supports FORMAT_MASK_NUMBER | |
width | number | No | data type=number; maxLen=22Applies when type supports WIDTH | |
height | number | No | data type=number; maxLen=22Applies when type supports HEIGHT | |
valuePlaceholder | string | No | data type=string; maxLen=255Applies when type supports PLACEHOLDER |
appearance {
template: @component
templateOptions: [
value
value
]
cssClasses: [
value
value
]
icon: value
formatMask: value
width: 42
height: 42
valuePlaceholder: value
}validation
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
valueRequired | boolean | Yes | false | data type=booleanApplies when type supports SESSION_STATE |
maxLength | number | No | data type=number; maxLen=22Applies when type supports WIDTH |
validation {
valueRequired: false
maxLength: 42
}advanced
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
cssClasses | array of strings | No | data type=string; maxLen=255Applies when type supports ELEMENTEnter classes to add to this component. You may add multiple classes by separating them with spaces. Note: These CSS classes will be applied to the HTML form element tag. | |
customAttributes | string | No | data type=string; maxLen=2000Applies when type supports ELEMENTEnter additional attributes to be included in the form element HTML tag. The size and id HTML attributes are generated and therefore should not be supplied. For the class HTML attribute it is better to use the dedicated CSS Classes attribute instead. | |
optionHtmlAttributes | array of strings | No | data type=string; maxLen=255Applies when type supports ELEMENT_OPTION | |
preText | multiline string | No | data type=multiline string; maxLen=4000Applies when type supports ELEMENT | |
postText | multiline string | No | data type=multiline string; maxLen=4000Applies when type supports ELEMENT | |
warnOnUnsavedChanges | enum | No | data type=string; lov=STATICValid values: ignore | |
initJavaScriptFunction | multiline string | No | data type=multiline string; maxLen=4000Applies when type supports INIT_JAVASCRIPT_CODE |
advanced {
cssClasses: [
value
value
]
customAttributes: value
optionHtmlAttributes: [
value
value
]
preText: ```html
value
```
postText: ```html
value
```
warnOnUnsavedChanges: ignore
initJavaScriptFunction: ```javascript-browser
value
```
}source
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
formRegion | reference | No | data type=reference; lov=COMPONENT; references=regionApplies when type supports SOURCE | |
column | string | Yes | data type=string; maxLen=128Applies when type supports SOURCE and formRegion is set | |
dataType | enum | Yes | data type=string; maxLen=128; lov=STATICValid values: varchar2 number date timestamp timestampWithTimeZone timestampWithLocalTimeZone intervalYearToMonth intervalDayToSecond clob blob boolean rowid bfile sdoGeometryApplies when type supports SOURCE and formRegion is set | |
queryOnly | boolean | Yes | false | data type=booleanApplies when type supports SOURCE and formRegion is set |
primaryKey | boolean | Yes | false | data type=booleanApplies when type supports SOURCE and formRegion is set |
type | enum | Yes | null | data type=string; lov=STATICValid values: staticValue databaseColumn item sqlQuerySingleValue sqlQueryMultipleValues expression functionBody preference nullApplies when type supports SOURCE |
staticValue | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports SOURCE and type = staticValue | |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports SOURCE and type = sqlQuerySingleValue | |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports SOURCE and type = sqlQueryMultipleValues | |
item | string | Yes | data type=string; maxLen=255; textCase=UPPERApplies when type supports SOURCE and type = item | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: sql plsql javaScript-mleApplies when type supports SOURCE and type = expression |
sqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports SOURCE and type = expression and language = sql | |
plsqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports SOURCE and type = expression and language = plsql | |
javaScriptExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports SOURCE and type = expression and language = javaScript-mle | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when type supports SOURCE and type = functionBody |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports SOURCE and type = functionBody and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports SOURCE and type = functionBody and language = javaScript-mle | |
databaseColumn | string | Yes | data type=string; maxLen=128Applies when type supports SOURCE and type = databaseColumn | |
preference | string | Yes | data type=string; maxLen=255Applies when type supports SOURCE and type = preference | |
used | enum | Yes | onlyWhenSessionStateIsNull | data type=string; lov=STATICValid values: always onlyWhenSessionStateIsNullApplies when type supports SOURCE |
postCalculationComputation | multiline string | No | data type=multiline string; maxLen=4000Applies when type supports SOURCE |
source {
formRegion: @component
column: value
dataType: varchar2
queryOnly: false
primaryKey: false
type: staticValue
staticValue: ```
value
```
sqlQuery: ```sql
value
```
item: value
language: sql
sqlExpression: ```sql
value
```
plsqlExpression: ```plsql
value
```
javaScriptExpression: ```javascript-mle
value
```
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
databaseColumn: value
preference: value
used: always
postCalculationComputation: ```plsql
value
```
}default
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
type | enum | No | data type=string; lov=STATICValid values: static item sqlQuerySingleValue sqlQueryMultipleValues expression functionBody sequenceApplies when type supports SOURCE | |
staticValue | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports SOURCE and type = static | |
item | string | Yes | data type=string; maxLen=32767; textCase=UPPERApplies when type supports SOURCE and type = item | |
sqlQuerySingleValue | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports SOURCE and type = sqlQuerySingleValue | |
sqlQueryMultipleValues | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports SOURCE and type = sqlQueryMultipleValues | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: sql plsql javaScript-mleApplies when type supports SOURCE and type = expression |
sqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports SOURCE and type = expression and language = sql | |
plsqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports SOURCE and type = expression and language = plsql | |
javaScriptExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports SOURCE and type = expression and language = javaScript-mle | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when type supports SOURCE and type = functionBody |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports SOURCE and type = functionBody and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports SOURCE and type = functionBody and language = javaScript-mle | |
sequence | string | Yes | data type=string; maxLen=128Applies when type supports SOURCE and type = sequence |
default {
type: static
staticValue: ```
value
```
item: value
sqlQuerySingleValue: ```sql
value
```
sqlQueryMultipleValues: ```sql
value
```
language: sql
sqlExpression: ```sql
value
```
plsqlExpression: ```plsql
value
```
javaScriptExpression: ```javascript-mle
value
```
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
sequence: value
}sessionState
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
dataType | enum | Yes | varchar2 | data type=string; maxLen=128; lov=STATICValid values: varchar2 clob boolean number |
storage | enum | Yes | session | data type=string; lov=STATICValid values: request session userApplies when type supports SOURCE |
storage | enum | Yes | request | data type=string; lov=STATICValid values: request sessionApplies when type supports SOURCE and formRegion is set |
sessionState {
dataType: varchar2
storage: request
}quickPicks
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
type | enum | No | data type=string; lov=STATICValid values: static sharedLov sqlQueryApplies when type supports QUICKPICK | |
label1 | string | No | data type=string; maxLen=255Applies when type supports QUICKPICK and type = static | |
value1 | string | No | data type=string; maxLen=255Applies when type supports QUICKPICK and type = static | |
label2 | string | No | data type=string; maxLen=255Applies when type supports QUICKPICK and type = static | |
value2 | string | No | data type=string; maxLen=255Applies when type supports QUICKPICK and type = static | |
label3 | string | No | data type=string; maxLen=255Applies when type supports QUICKPICK and type = static | |
value3 | string | No | data type=string; maxLen=255Applies when type supports QUICKPICK and type = static | |
label4 | string | No | data type=string; maxLen=255Applies when type supports QUICKPICK and type = static | |
value4 | string | No | data type=string; maxLen=255Applies when type supports QUICKPICK and type = static | |
label5 | string | No | data type=string; maxLen=255Applies when type supports QUICKPICK and type = static | |
value5 | string | No | data type=string; maxLen=255Applies when type supports QUICKPICK and type = static | |
label6 | string | No | data type=string; maxLen=255Applies when type supports QUICKPICK and type = static | |
value6 | string | No | data type=string; maxLen=255Applies when type supports QUICKPICK and type = static | |
label7 | string | No | data type=string; maxLen=255Applies when type supports QUICKPICK and type = static | |
value7 | string | No | data type=string; maxLen=255Applies when type supports QUICKPICK and type = static | |
label8 | string | No | data type=string; maxLen=255Applies when type supports QUICKPICK and type = static | |
value8 | string | No | data type=string; maxLen=255Applies when type supports QUICKPICK and type = static | |
label9 | string | No | data type=string; maxLen=255Applies when type supports QUICKPICK and type = static | |
value9 | string | No | data type=string; maxLen=255Applies when type supports QUICKPICK and type = static | |
label10 | string | No | data type=string; maxLen=255Applies when type supports QUICKPICK and type = static | |
value10 | string | No | data type=string; maxLen=255Applies when type supports QUICKPICK and type = static | |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports QUICKPICK and type = sqlQuery | |
maxDisplayedEntries | integer | No | data type=integer; maxLen=32767Applies when type supports QUICKPICK and type in (sharedLov)type supports QUICKPICK and type in (sqlQuery) | |
linkAttributes | string | No | data type=string; maxLen=255Applies when type supports QUICKPICK and type is set |
quickPicks {
type: static
label1: value
value1: value
label2: value
value2: value
label3: value
value3: value
label4: value
value4: value
label5: value
value5: value
label6: value
value6: value
label7: value
value7: value
label8: value
value8: value
label9: value
value9: value
label10: value
value10: value
sqlQuery: ```sql
value
```
maxDisplayedEntries: 42
linkAttributes: 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 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) |
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
]
}readOnly
| 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 neverApplies when type supports READONLYSelect a condition type that must be met in order for this component to render as read-only. Not selecting a condition causes the item to render normally. A read-only item is rendered with the same settings as a Display Only item. Note: Set the condition type to Never to always render the item as an enterable field. This setting overwrites any read-only condition setting on the region or page level. | |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports READONLY and type in (rowsReturned)type supports READONLY and type in (noRowsReturned) | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: sql plsql javaScript-mleApplies when type supports READONLY and type = expression |
sqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports READONLY and type = expression and language = sql | |
plsqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports READONLY and type = expression and language = plsql | |
javaScriptExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports READONLY and type = expression and language = javaScript-mle | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when type supports READONLY and type = functionBody |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports READONLY and type = functionBody and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports READONLY and type = functionBody and language = javaScript-mle | |
value | string | Yes | data type=string; maxLen=4000Applies when type supports READONLY and type in (request=Value)type supports READONLY and type in (request!=Value)type supports READONLY and type in (requestIsContainedInValue)type supports READONLY and type in (requestIsNotContainedInValue)type supports READONLY and type in (currentLanguageIsContainedInValue)type supports READONLY and type in (currentLanguageIsNotContainedInValue)type supports READONLY and type in (currentLanguage!=value)type supports READONLY and type in (currentLanguage=value)type supports READONLY and type in (cgiEnvDadName=value)type supports READONLY and type in (cgiEnvDadName!=value)type supports READONLY and type in (cgiEnvServerName=value)type supports READONLY and type in (cgiEnvServerName!=value)type supports READONLY and type in (cgiEnvHttpHost=value)type supports READONLY and type in (cgiEnvHttpHost!=value) | |
item | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when type supports READONLY and type in (item=value)type supports READONLY and type in (item!=value)type supports READONLY and type in (VALUE_OF_ITEM_IN_COND_1_EQ_COND_2)type supports READONLY and type in (VALUE_OF_ITEM_IN_COND_1_NOT_EQ_COND_2)type supports READONLY and type in (itemIsNull)type supports READONLY and type in (itemIsNotNull)type supports READONLY and type in (itemIsZero)type supports READONLY and type in (itemIsNotZero)type supports READONLY and type in (itemIsNullOrZero)type supports READONLY and type in (itemIsNotNullAndNotZero)type supports READONLY and type in (itemContainsNoSpaces)type supports READONLY and type in (itemIsNumeric)type supports READONLY and type in (itemIsNotNumeric)type supports READONLY and type in (itemIsAlphanumeric)type supports READONLY and type in (itemIsInColonDelimitedList)type supports READONLY and type in (itemIsNotInColonDelimitedList) | |
preference | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when type supports READONLY and type in (userPreference=value)type supports READONLY and type in (userPreference!=value) | |
page | integer | Yes | data type=integer; maxLen=4000Applies when type supports READONLY and type in (currentPage=page)type supports READONLY and type in (currentPage!=page) | |
pages | array of integers | Yes | data type=integer; maxLen=4000Applies when type supports READONLY and type in (currentPageInList)type supports READONLY and type in (currentPageNotInList) | |
text | string | Yes | data type=string; maxLen=4000Applies when type supports READONLY and type in (textIsContainedInItem)type supports READONLY and type in (textIsContainedInValue)type supports READONLY and type in (textIsNotContainedInValue)type supports READONLY and type in (text=value)type supports READONLY and type in (text!=value) | |
value | string | Yes | data type=string; maxLen=4000Applies when type supports READONLY and type in (item=value)type supports READONLY and type in (item!=value)type supports READONLY and type in (VALUE_OF_ITEM_IN_COND_1_EQ_COND_2)type supports READONLY and type in (VALUE_OF_ITEM_IN_COND_1_NOT_EQ_COND_2)type supports READONLY and type in (userPreference=value)type supports READONLY and type in (userPreference!=value) | |
list | array of strings | Yes | data type=string; maxLen=4000Applies when type supports READONLY and type in (itemIsInColonDelimitedList)type supports READONLY and type in (itemIsNotInColonDelimitedList) | |
item | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when type supports READONLY and type = textIsContainedInItem | |
value | string | Yes | data type=string; maxLen=4000Applies when type supports READONLY and type in (textIsContainedInValue)type supports READONLY and type in (textIsNotContainedInValue)type supports READONLY and type in (text=value)type supports READONLY and type in (text!=value) | |
readOnlyHtmlAttributes | string | No | data type=string; maxLen=4000Applies when type supports READONLY and type is set |
readOnly {
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
]
readOnlyHtmlAttributes: value
}security
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
authorizationScheme | enum | No | data type=reference; lov=COMPONENT; references=authorizationValid values: mustNotBePublicUser | |
sessionStateProtection | enum | Yes | unrestricted | data type=string; lov=STATICValid values: unrestricted checksumRequiredAppLevel checksumRequiredUserLevel checksumRequiredSessionLevel restricted |
encryptSessionState | boolean | Yes | true | data type=booleanApplies when type supports ENCRYPT |
escapeSpecialChars | boolean | Yes | true | data type=booleanApplies when type supports ESCAPE_OUTPUT |
restrictedChars | enum | No | data type=string; lov=STATICValid values: alphanumWithSpace webSafe noSpecialChar noSpecialCharNoNewline workspaceSchema workspaceUserSchema workspaceUserSchemaId |
security {
authorizationScheme: mustNotBePublicUser
sessionStateProtection: unrestricted
encryptSessionState: false
escapeSpecialChars: false
restrictedChars: alphanumWithSpace
}help
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
inlineHelpText | multiline string | No | data type=multiline string; maxLen=4000 | |
helpText | multiline string | No | data type=multiline string; maxLen=4000Enter help text for this item. The help text may be used to provide field level context sensitive help. |
help {
inlineHelpText: ```html
value
```
helpText: ```html
value
```
}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
pageItem sample (
name: value
type: textarea
settings {
resizable: false
autoHeight: false
charCounter: false
trimSpaces: leading
}
label {
label: value
alignment: above
tableCellAttributes: [
value
value
]
}
lov {
type: sharedComponent
lov: @component
sqlQuery: ```sql
value
```
staticValues: ```
value
```
language: plsql
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
displayExtraValues: false
displayNullValue: false
nullDisplayValue: value
nullReturnValue: value
}
cascadingLov {
parentItems: [
value
value
]
itemsToSubmit: [
value
value
]
parentRequired: false
}
genAI {
enabled: false
agent: @component
service: @component
systemPrompt: ```
value
```
welcomeMessage: ```html
value
```
}
multipleValues {
type: delimitedList
separator: value
}
layout {
sequence: 42
region: @component
slot: value
alignment: center
startNewLayout: false
startNewRow: false
rowCssClasses: [
value
value
]
column: value
newColumn: false
columnSpan: value
rowSpan: 42
labelColumnSpan: value
columnCssClasses: [
value
value
]
columnAttributes: [
value
value
]
}
appearance {
template: @component
templateOptions: [
value
value
]
cssClasses: [
value
value
]
icon: value
formatMask: value
width: 42
height: 42
valuePlaceholder: value
}
validation {
valueRequired: false
maxLength: 42
}
advanced {
cssClasses: [
value
value
]
customAttributes: value
optionHtmlAttributes: [
value
value
]
preText: ```html
value
```
postText: ```html
value
```
warnOnUnsavedChanges: ignore
initJavaScriptFunction: ```javascript-browser
value
```
}
source {
formRegion: @component
column: value
dataType: varchar2
queryOnly: false
primaryKey: false
type: staticValue
staticValue: ```
value
```
sqlQuery: ```sql
value
```
item: value
language: sql
sqlExpression: ```sql
value
```
plsqlExpression: ```plsql
value
```
javaScriptExpression: ```javascript-mle
value
```
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
databaseColumn: value
preference: value
used: always
postCalculationComputation: ```plsql
value
```
}
default {
type: static
staticValue: ```
value
```
item: value
sqlQuerySingleValue: ```sql
value
```
sqlQueryMultipleValues: ```sql
value
```
language: sql
sqlExpression: ```sql
value
```
plsqlExpression: ```plsql
value
```
javaScriptExpression: ```javascript-mle
value
```
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
sequence: value
}
sessionState {
dataType: varchar2
storage: request
}
quickPicks {
type: static
label1: value
value1: value
label2: value
value2: value
label3: value
value3: value
label4: value
value4: value
label5: value
value5: value
label6: value
value6: value
label7: value
value7: value
label8: value
value8: value
label9: value
value9: value
label10: value
value10: value
sqlQuery: ```sql
value
```
maxDisplayedEntries: 42
linkAttributes: 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
]
}
readOnly {
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
]
readOnlyHtmlAttributes: value
}
security {
authorizationScheme: mustNotBePublicUser
sessionStateProtection: unrestricted
encryptSessionState: false
escapeSpecialChars: false
restrictedChars: alphanumWithSpace
}
help {
inlineHelpText: ```html
value
```
helpText: ```html
value
```
}
config {
buildOption: @component
}
comments {
comments: ```
value
```
}
)