column (stopAndStartGridLayout)
type = stopAndStartGridLayout| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
columnName | string | Yes | data type=string; maxLen=128 | |
type | enum | Yes | data type=string; lov=PLUGINSValid values: stopAndStartGridLayoutSelect how this column is rendered. The following column types are supported: #NATIVE_PLUGINS#Depending on your application configuration, you may also have additional column type plug-ins available here. These display as <My Plug-in> [Plug-in]. The following plug-ins are installed in this application's shared components: #CUSTOM_PLUGINS# |
heading
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
heading | string | No | data type=string; maxLen=4000Enter the report column heading text. For a hidden column,
the header text will only be used when the report is exported to CSV or printed. | |
alignment | enum | Yes | start | data type=string; lov=STATICValid values: start center end |
alternativeLabel | string | No | data type=string; maxLen=4000 |
heading {
heading: value
alignment: start
alternativeLabel: value
}lov
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
type | enum | No | data type=string; lov=STATICValid values: sharedComponent sqlQuery staticValues functionBody | |
lov | reference | Yes | data type=reference; lov=COMPONENT; references=lovApplies when type = sharedComponent | |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=4000Applies when 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 = staticValues |
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=32767Applies when type = functionBody and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=32767Applies when type = functionBody and language = javaScript-mle | |
displayExtraValues | boolean | Yes | true | data type=booleanApplies when type is set |
displayNullValue | boolean | Yes | true | data type=booleanApplies when type is set |
nullDisplayValue | string | No | data type=string; maxLen=255Applies when type is set and displayNullValue = true | |
nullReturnValue | string | No | data type=string; maxLen=255Applies when 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 |
|---|---|---|---|---|
parentColumns | array of strings | No | data type=string; maxLen=255; textCase=UPPERApplies when type is set | |
itemsToSubmit | array of strings | No | data type=string; maxLen=4000; textCase=UPPERApplies when type is set and parentColumns is set | |
parentRequired | boolean | Yes | true | data type=booleanApplies when type is set and parentColumns is set |
cascadingLov {
parentColumns: [
value
value
]
itemsToSubmit: [
value
value
]
parentRequired: false
}multipleValues
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
type | enum | Yes | delimitedList | data type=string; lov=STATICValid values: delimitedList jsonArray |
type | enum | No | data type=string; lov=STATICValid values: delimitedList jsonArray | |
separator | string | Yes | : | data type=string; maxLen=5Applies when type = delimitedList |
multipleValues {
type: delimitedList
separator: value
}layout
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
sequence | number | Yes | data type=number; maxLen=22Enter the display sequence for this column. The sequence setting determines where this column is displayed in relation to other columns within the region. Note: If two columns, within the same region, have the same sequence value then they may be displayed in a different order when the application is exported and imported into another environment, such as a test or production environment. To ensure consistency, Oracle recommends you specify unique sequence numbers for every item, or at least for those within the same region. | |
columnAlignment | enum | Yes | start | data type=string; lov=STATICValid values: start center end |
group | reference | No | data type=reference; lov=COMPONENT; references=columnGroup | |
useGroupFor | enum | Yes | both | data type=string; lov=STATICValid values: both singleRowView headingApplies when group is set |
stretch | enum | No | data type=string; lov=STATICValid values: never always |
layout {
sequence: 42
columnAlignment: start
group: @component
useGroupFor: both
stretch: never
}accessibility
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
valueIdentifiesRow | boolean | Yes | false | data type=boolean |
accessibility {
valueIdentifiesRow: false
}appearance
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
cssClasses | array of strings | No | data type=string; maxLen=255Enter 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 cells in the Interactive Grid. To apply CSS classes to the corresponding item, please see the CSS Classes property under the Advanced group. | |
icon | string | No | data type=string; maxLen=255Enter 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=255 | |
formatMask | string | No | data type=string; maxLen=255 | |
formatMask | string | No | data type=string; maxLen=255 | |
width | number | No | data type=number; maxLen=22 | |
height | number | No | data type=number; maxLen=22 | |
valuePlaceholder | string | No | data type=string; maxLen=255 |
appearance {
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=boolean |
maxLength | number | No | data type=number; maxLen=22 |
validation {
valueRequired: false
maxLength: 42
}link
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
target | complex | No | data type=complex; maxLen=32767 | |
linkText | string | No | data type=string; maxLen=4000Applies when target is set | |
linkAttributes | string | No | data type=string; maxLen=4000Applies when target is set |
link {
target: {
type: in_app
url: value
app: value
page: value
items: [
value
value
]
clearCache: value
action: value
request: value
anchor: value
session: "&SESSION."
debug: "&DEBUG."
printerFriendly: N
otherArgs: value
}
linkText: value
linkAttributes: value
}source
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
type | enum | Yes | databaseColumn | data type=string; lov=STATICValid values: databaseColumn sqlExpression none |
databaseColumn | string | Yes | data type=string; maxLen=128Applies when type = databaseColumn | |
sqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = sqlExpression | |
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 in (databaseColumn)type in (sqlExpression) | |
queryOnly | boolean | Yes | false | data type=booleanApplies when type = databaseColumn and type in (databaseColumn)type = databaseColumn and type in (sqlExpression) |
primaryKey | boolean | Yes | false | data type=booleanApplies when type = databaseColumn |
source {
type: databaseColumn
databaseColumn: value
sqlExpression: ```sql
value
```
dataType: varchar2
queryOnly: false
primaryKey: false
}masterDetail
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
masterColumn | reference | No | data type=reference; lov=COMPONENT; references=columnApplies when type = databaseColumn and type in (databaseColumn) and dataType in (varchar2)type = databaseColumn and type in (databaseColumn) and dataType in (number)type = databaseColumn and type in (databaseColumn) and dataType in (date)type = databaseColumn and type in (databaseColumn) and dataType in (timestamp)type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone)type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone)type = databaseColumn and type in (sqlExpression) and dataType in (varchar2)type = databaseColumn and type in (sqlExpression) and dataType in (number)type = databaseColumn and type in (sqlExpression) and dataType in (date)type = databaseColumn and type in (sqlExpression) and dataType in (timestamp)type = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone)type = databaseColumn and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone) |
masterDetail {
masterColumn: @component
}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 = databaseColumn and type in (databaseColumn) and dataType in (varchar2)type = databaseColumn and type in (databaseColumn) and dataType in (number)type = databaseColumn and type in (databaseColumn) and dataType in (date)type = databaseColumn and type in (databaseColumn) and dataType in (timestamp)type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone)type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone)type = databaseColumn and type in (sqlExpression) and dataType in (varchar2)type = databaseColumn and type in (sqlExpression) and dataType in (number)type = databaseColumn and type in (sqlExpression) and dataType in (date)type = databaseColumn and type in (sqlExpression) and dataType in (timestamp)type = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone)type = databaseColumn and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone) | |
staticValue | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = databaseColumn and type in (databaseColumn) and dataType in (varchar2) and type = statictype = databaseColumn and type in (databaseColumn) and dataType in (number) and type = statictype = databaseColumn and type in (databaseColumn) and dataType in (date) and type = statictype = databaseColumn and type in (databaseColumn) and dataType in (timestamp) and type = statictype = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone) and type = statictype = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type = statictype = databaseColumn and type in (sqlExpression) and dataType in (varchar2) and type = statictype = databaseColumn and type in (sqlExpression) and dataType in (number) and type = statictype = databaseColumn and type in (sqlExpression) and dataType in (date) and type = statictype = databaseColumn and type in (sqlExpression) and dataType in (timestamp) and type = statictype = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone) and type = statictype = databaseColumn and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone) and type = static | |
item | string | Yes | data type=string; maxLen=32767; textCase=UPPERApplies when type = databaseColumn and type in (databaseColumn) and dataType in (varchar2) and type = itemtype = databaseColumn and type in (databaseColumn) and dataType in (number) and type = itemtype = databaseColumn and type in (databaseColumn) and dataType in (date) and type = itemtype = databaseColumn and type in (databaseColumn) and dataType in (timestamp) and type = itemtype = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone) and type = itemtype = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type = itemtype = databaseColumn and type in (sqlExpression) and dataType in (varchar2) and type = itemtype = databaseColumn and type in (sqlExpression) and dataType in (number) and type = itemtype = databaseColumn and type in (sqlExpression) and dataType in (date) and type = itemtype = databaseColumn and type in (sqlExpression) and dataType in (timestamp) and type = itemtype = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone) and type = itemtype = databaseColumn and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone) and type = item | |
sqlQuerySingleValue | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = databaseColumn and type in (databaseColumn) and dataType in (varchar2) and type = sqlQuerySingleValuetype = databaseColumn and type in (databaseColumn) and dataType in (number) and type = sqlQuerySingleValuetype = databaseColumn and type in (databaseColumn) and dataType in (date) and type = sqlQuerySingleValuetype = databaseColumn and type in (databaseColumn) and dataType in (timestamp) and type = sqlQuerySingleValuetype = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone) and type = sqlQuerySingleValuetype = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type = sqlQuerySingleValuetype = databaseColumn and type in (sqlExpression) and dataType in (varchar2) and type = sqlQuerySingleValuetype = databaseColumn and type in (sqlExpression) and dataType in (number) and type = sqlQuerySingleValuetype = databaseColumn and type in (sqlExpression) and dataType in (date) and type = sqlQuerySingleValuetype = databaseColumn and type in (sqlExpression) and dataType in (timestamp) and type = sqlQuerySingleValuetype = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone) and type = sqlQuerySingleValuetype = databaseColumn and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone) and type = sqlQuerySingleValue | |
sqlQueryMultipleValues | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = databaseColumn and type in (databaseColumn) and dataType in (varchar2) and type = sqlQueryMultipleValuestype = databaseColumn and type in (databaseColumn) and dataType in (number) and type = sqlQueryMultipleValuestype = databaseColumn and type in (databaseColumn) and dataType in (date) and type = sqlQueryMultipleValuestype = databaseColumn and type in (databaseColumn) and dataType in (timestamp) and type = sqlQueryMultipleValuestype = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone) and type = sqlQueryMultipleValuestype = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type = sqlQueryMultipleValuestype = databaseColumn and type in (sqlExpression) and dataType in (varchar2) and type = sqlQueryMultipleValuestype = databaseColumn and type in (sqlExpression) and dataType in (number) and type = sqlQueryMultipleValuestype = databaseColumn and type in (sqlExpression) and dataType in (date) and type = sqlQueryMultipleValuestype = databaseColumn and type in (sqlExpression) and dataType in (timestamp) and type = sqlQueryMultipleValuestype = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone) and type = sqlQueryMultipleValuestype = databaseColumn and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone) and type = sqlQueryMultipleValues | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: sql plsql javaScript-mleApplies when type = databaseColumn and type in (databaseColumn) and dataType in (varchar2) and type = expressiontype = databaseColumn and type in (databaseColumn) and dataType in (number) and type = expressiontype = databaseColumn and type in (databaseColumn) and dataType in (date) and type = expressiontype = databaseColumn and type in (databaseColumn) and dataType in (timestamp) and type = expressiontype = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone) and type = expressiontype = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type = expressiontype = databaseColumn and type in (sqlExpression) and dataType in (varchar2) and type = expressiontype = databaseColumn and type in (sqlExpression) and dataType in (number) and type = expressiontype = databaseColumn and type in (sqlExpression) and dataType in (date) and type = expressiontype = databaseColumn and type in (sqlExpression) and dataType in (timestamp) and type = expressiontype = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone) and type = expressiontype = databaseColumn and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone) and type = expression |
sqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = databaseColumn and type in (databaseColumn) and dataType in (varchar2) and type = expression and language = sqltype = databaseColumn and type in (databaseColumn) and dataType in (number) and type = expression and language = sqltype = databaseColumn and type in (databaseColumn) and dataType in (date) and type = expression and language = sqltype = databaseColumn and type in (databaseColumn) and dataType in (timestamp) and type = expression and language = sqltype = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone) and type = expression and language = sqltype = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type = expression and language = sqltype = databaseColumn and type in (sqlExpression) and dataType in (varchar2) and type = expression and language = sqltype = databaseColumn and type in (sqlExpression) and dataType in (number) and type = expression and language = sqltype = databaseColumn and type in (sqlExpression) and dataType in (date) and type = expression and language = sqltype = databaseColumn and type in (sqlExpression) and dataType in (timestamp) and type = expression and language = sqltype = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone) and type = expression and language = sqltype = databaseColumn and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone) and type = expression and language = sql | |
plsqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = databaseColumn and type in (databaseColumn) and dataType in (varchar2) and type = expression and language = plsqltype = databaseColumn and type in (databaseColumn) and dataType in (number) and type = expression and language = plsqltype = databaseColumn and type in (databaseColumn) and dataType in (date) and type = expression and language = plsqltype = databaseColumn and type in (databaseColumn) and dataType in (timestamp) and type = expression and language = plsqltype = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone) and type = expression and language = plsqltype = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type = expression and language = plsqltype = databaseColumn and type in (sqlExpression) and dataType in (varchar2) and type = expression and language = plsqltype = databaseColumn and type in (sqlExpression) and dataType in (number) and type = expression and language = plsqltype = databaseColumn and type in (sqlExpression) and dataType in (date) and type = expression and language = plsqltype = databaseColumn and type in (sqlExpression) and dataType in (timestamp) and type = expression and language = plsqltype = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone) and type = expression and language = plsqltype = databaseColumn and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone) and type = expression and language = plsql | |
javaScriptExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = databaseColumn and type in (databaseColumn) and dataType in (varchar2) and type = expression and language = javaScript-mletype = databaseColumn and type in (databaseColumn) and dataType in (number) and type = expression and language = javaScript-mletype = databaseColumn and type in (databaseColumn) and dataType in (date) and type = expression and language = javaScript-mletype = databaseColumn and type in (databaseColumn) and dataType in (timestamp) and type = expression and language = javaScript-mletype = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone) and type = expression and language = javaScript-mletype = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type = expression and language = javaScript-mletype = databaseColumn and type in (sqlExpression) and dataType in (varchar2) and type = expression and language = javaScript-mletype = databaseColumn and type in (sqlExpression) and dataType in (number) and type = expression and language = javaScript-mletype = databaseColumn and type in (sqlExpression) and dataType in (date) and type = expression and language = javaScript-mletype = databaseColumn and type in (sqlExpression) and dataType in (timestamp) and type = expression and language = javaScript-mletype = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone) and type = expression and language = javaScript-mletype = databaseColumn and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone) and type = expression and language = javaScript-mle | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when type = databaseColumn and type in (databaseColumn) and dataType in (varchar2) and type = functionBodytype = databaseColumn and type in (databaseColumn) and dataType in (number) and type = functionBodytype = databaseColumn and type in (databaseColumn) and dataType in (date) and type = functionBodytype = databaseColumn and type in (databaseColumn) and dataType in (timestamp) and type = functionBodytype = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone) and type = functionBodytype = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type = functionBodytype = databaseColumn and type in (sqlExpression) and dataType in (varchar2) and type = functionBodytype = databaseColumn and type in (sqlExpression) and dataType in (number) and type = functionBodytype = databaseColumn and type in (sqlExpression) and dataType in (date) and type = functionBodytype = databaseColumn and type in (sqlExpression) and dataType in (timestamp) and type = functionBodytype = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone) and type = functionBodytype = databaseColumn and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone) and type = functionBody |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = databaseColumn and type in (databaseColumn) and dataType in (varchar2) and type = functionBody and language = plsqltype = databaseColumn and type in (databaseColumn) and dataType in (number) and type = functionBody and language = plsqltype = databaseColumn and type in (databaseColumn) and dataType in (date) and type = functionBody and language = plsqltype = databaseColumn and type in (databaseColumn) and dataType in (timestamp) and type = functionBody and language = plsqltype = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone) and type = functionBody and language = plsqltype = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type = functionBody and language = plsqltype = databaseColumn and type in (sqlExpression) and dataType in (varchar2) and type = functionBody and language = plsqltype = databaseColumn and type in (sqlExpression) and dataType in (number) and type = functionBody and language = plsqltype = databaseColumn and type in (sqlExpression) and dataType in (date) and type = functionBody and language = plsqltype = databaseColumn and type in (sqlExpression) and dataType in (timestamp) and type = functionBody and language = plsqltype = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone) and type = functionBody and language = plsqltype = databaseColumn and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone) and type = functionBody and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = databaseColumn and type in (databaseColumn) and dataType in (varchar2) and type = functionBody and language = javaScript-mletype = databaseColumn and type in (databaseColumn) and dataType in (number) and type = functionBody and language = javaScript-mletype = databaseColumn and type in (databaseColumn) and dataType in (date) and type = functionBody and language = javaScript-mletype = databaseColumn and type in (databaseColumn) and dataType in (timestamp) and type = functionBody and language = javaScript-mletype = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone) and type = functionBody and language = javaScript-mletype = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type = functionBody and language = javaScript-mletype = databaseColumn and type in (sqlExpression) and dataType in (varchar2) and type = functionBody and language = javaScript-mletype = databaseColumn and type in (sqlExpression) and dataType in (number) and type = functionBody and language = javaScript-mletype = databaseColumn and type in (sqlExpression) and dataType in (date) and type = functionBody and language = javaScript-mletype = databaseColumn and type in (sqlExpression) and dataType in (timestamp) and type = functionBody and language = javaScript-mletype = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone) and type = functionBody and language = javaScript-mletype = databaseColumn and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone) and type = functionBody and language = javaScript-mle | |
sequence | string | Yes | data type=string; maxLen=128Applies when type = databaseColumn and type in (databaseColumn) and dataType in (varchar2) and type = sequencetype = databaseColumn and type in (databaseColumn) and dataType in (number) and type = sequencetype = databaseColumn and type in (databaseColumn) and dataType in (date) and type = sequencetype = databaseColumn and type in (databaseColumn) and dataType in (timestamp) and type = sequencetype = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone) and type = sequencetype = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type = sequencetype = databaseColumn and type in (sqlExpression) and dataType in (varchar2) and type = sequencetype = databaseColumn and type in (sqlExpression) and dataType in (number) and type = sequencetype = databaseColumn and type in (sqlExpression) and dataType in (date) and type = sequencetype = databaseColumn and type in (sqlExpression) and dataType in (timestamp) and type = sequencetype = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone) and type = sequencetype = databaseColumn and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone) and type = sequence | |
duplicateCopiesExistingValue | boolean | Yes | true | data type=booleanApplies when type = databaseColumn and primaryKey = false and type in (databaseColumn) and queryOnly = false and dataType in (varchar2)type = databaseColumn and primaryKey = false and type in (databaseColumn) and queryOnly = false and dataType in (number)type = databaseColumn and primaryKey = false and type in (databaseColumn) and queryOnly = false and dataType in (date)type = databaseColumn and primaryKey = false and type in (databaseColumn) and queryOnly = false and dataType in (timestamp)type = databaseColumn and primaryKey = false and type in (databaseColumn) and queryOnly = false and dataType in (timestampWithTimeZone)type = databaseColumn and primaryKey = false and type in (databaseColumn) and queryOnly = false and dataType in (timestampWithLocalTimeZone)type = databaseColumn and primaryKey = false and type in (databaseColumn) and queryOnly = false and type in (sqlExpression) and dataType in (varchar2)type = databaseColumn and primaryKey = false and type in (databaseColumn) and queryOnly = false and type in (sqlExpression) and dataType in (number)type = databaseColumn and primaryKey = false and type in (databaseColumn) and queryOnly = false and type in (sqlExpression) and dataType in (date)type = databaseColumn and primaryKey = false and type in (databaseColumn) and queryOnly = false and type in (sqlExpression) and dataType in (timestamp)type = databaseColumn and primaryKey = false and type in (databaseColumn) and queryOnly = false and type in (sqlExpression) and dataType in (timestampWithTimeZone)type = databaseColumn and primaryKey = false and type in (databaseColumn) and queryOnly = false and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone)type = databaseColumn and primaryKey = false and type in (sqlExpression) and queryOnly = false and type in (databaseColumn) and dataType in (varchar2)type = databaseColumn and primaryKey = false and type in (sqlExpression) and queryOnly = false and type in (databaseColumn) and dataType in (number)type = databaseColumn and primaryKey = false and type in (sqlExpression) and queryOnly = false and type in (databaseColumn) and dataType in (date)type = databaseColumn and primaryKey = false and type in (sqlExpression) and queryOnly = false and type in (databaseColumn) and dataType in (timestamp)type = databaseColumn and primaryKey = false and type in (sqlExpression) and queryOnly = false and type in (databaseColumn) and dataType in (timestampWithTimeZone)type = databaseColumn and primaryKey = false and type in (sqlExpression) and queryOnly = false and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone)type = databaseColumn and primaryKey = false and type in (sqlExpression) and queryOnly = false and dataType in (varchar2)type = databaseColumn and primaryKey = false and type in (sqlExpression) and queryOnly = false and dataType in (number)type = databaseColumn and primaryKey = false and type in (sqlExpression) and queryOnly = false and dataType in (date)type = databaseColumn and primaryKey = false and type in (sqlExpression) and queryOnly = false and dataType in (timestamp)type = databaseColumn and primaryKey = false and type in (sqlExpression) and queryOnly = false and dataType in (timestampWithTimeZone)type = databaseColumn and primaryKey = false and type in (sqlExpression) and queryOnly = false and dataType in (timestampWithLocalTimeZone) |
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
duplicateCopiesExistingValue: false
}sessionState
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
dataType | enum | Yes | varchar2 | data type=string; maxLen=128; lov=STATICValid values: varchar2 clob boolean |
sessionState {
dataType: varchar2
}columnFilter
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
enabled | boolean | Yes | true | data type=booleanApplies when type is set |
performanceImpactingOperators | array of enums | No | data type=string; lov=STATICValid values: contains startsWith caseInsensitive regexpApplies when type is set and enabled = truetype is set and enabled = true and type in (databaseColumn) and dataType in (varchar2)type is set and enabled = true and type in (databaseColumn) and dataType in (clob)type is set and enabled = true and type in (sqlExpression) and dataType in (varchar2)type is set and enabled = true and type in (sqlExpression) and dataType in (clob) | |
textCase | enum | Yes | mixed | data type=string; lov=STATICValid values: upper lower mixedApplies when type is set and enabled = truetype is set and enabled = true and type in (databaseColumn) and dataType = varchar2type is set and enabled = true and type in (sqlExpression) and dataType = varchar2 |
lovType | enum | Yes | distinctColumn | data type=string; lov=STATICValid values: none distinctColumn sqlQuery sharedComponent staticValues functionBody useLovApplies when type is set and enabled = true |
dateRanges | enum | Yes | all | data type=string; lov=STATICValid values: all past futureApplies when type is set and enabled = true and lovType = distinctColumn and type in (databaseColumn) and dataType in (date)type is set and enabled = true and lovType = distinctColumn and type in (databaseColumn) and dataType in (timestamp)type is set and enabled = true and lovType = distinctColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone)type is set and enabled = true and lovType = distinctColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone)type is set and enabled = true and lovType = distinctColumn and type in (sqlExpression) and dataType in (date)type is set and enabled = true and lovType = distinctColumn and type in (sqlExpression) and dataType in (timestamp)type is set and enabled = true and lovType = distinctColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone)type is set and enabled = true and lovType = distinctColumn and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone) |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type is set and enabled = true and lovType = sqlQuery | |
namedLov | reference | Yes | data type=reference; lov=COMPONENT; references=lovApplies when type is set and enabled = true and lovType = sharedComponent | |
staticValues | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type is set and enabled = true and lovType = staticValues | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when type is set and enabled = true and lovType = functionBody |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=32767Applies when type is set and enabled = true and lovType = functionBody and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=32767Applies when type is set and enabled = true and lovType = functionBody and language = javaScript-mle | |
exactMatch | boolean | Yes | true | data type=booleanApplies when type is set and enabled = truetype is set and enabled = true and type in (databaseColumn) and dataType = varchar2type is set and enabled = true and type in (sqlExpression) and dataType = varchar2 |
columnFilter {
enabled: false
performanceImpactingOperators: [
contains
startsWith
]
textCase: upper
lovType: none
dateRanges: all
sqlQuery: ```sql
value
```
namedLov: @component
staticValues: ```
value
```
language: plsql
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
exactMatch: false
}exportPrinting
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
includeInExportPrint | boolean | Yes | true | data type=boolean |
exportPrinting {
includeInExportPrint: false
}enableUsersTo
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
sort | boolean | Yes | true | data type=booleanApplies when type in (databaseColumn) and dataType in (varchar2) and type is settype in (databaseColumn) and dataType in (number) and type is settype in (databaseColumn) and dataType in (date) and type is settype in (databaseColumn) and dataType in (timestamp) and type is settype in (databaseColumn) and dataType in (timestampWithTimeZone) and type is settype in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type is settype in (databaseColumn) and dataType in (intervalDayToSecond) and type is settype in (databaseColumn) and dataType in (intervalYearToMonth) and type is settype in (sqlExpression) and dataType in (varchar2) and type is settype in (sqlExpression) and dataType in (number) and type is settype in (sqlExpression) and dataType in (date) and type is settype in (sqlExpression) and dataType in (timestamp) and type is settype in (sqlExpression) and dataType in (timestampWithTimeZone) and type is settype in (sqlExpression) and dataType in (timestampWithLocalTimeZone) and type is settype in (sqlExpression) and dataType in (intervalDayToSecond) and type is settype in (sqlExpression) and dataType in (intervalYearToMonth) and type is set |
controlBreakAggregate | boolean | Yes | true | data type=booleanApplies when type in (databaseColumn) and dataType in (varchar2) and type is set and sort = truetype in (databaseColumn) and dataType in (number) and type is set and sort = truetype in (databaseColumn) and dataType in (date) and type is set and sort = truetype in (databaseColumn) and dataType in (timestamp) and type is set and sort = truetype in (databaseColumn) and dataType in (timestampWithTimeZone) and type is set and sort = truetype in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type is set and sort = truetype in (databaseColumn) and dataType in (intervalDayToSecond) and type is set and sort = truetype in (databaseColumn) and dataType in (intervalYearToMonth) and type is set and sort = truetype in (sqlExpression) and dataType in (varchar2) and type is set and sort = truetype in (sqlExpression) and dataType in (number) and type is set and sort = truetype in (sqlExpression) and dataType in (date) and type is set and sort = truetype in (sqlExpression) and dataType in (timestamp) and type is set and sort = truetype in (sqlExpression) and dataType in (timestampWithTimeZone) and type is set and sort = truetype in (sqlExpression) and dataType in (timestampWithLocalTimeZone) and type is set and sort = truetype in (sqlExpression) and dataType in (intervalDayToSecond) and type is set and sort = truetype in (sqlExpression) and dataType in (intervalYearToMonth) and type is set and sort = true |
hide | boolean | Yes | true | data type=boolean |
enableUsersTo {
sort: false
controlBreakAggregate: false
hide: false
}advanced
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
htmlDomId | string | No | data type=string; maxLen=255Enter the DOM ID for the column. The DOM ID can be useful when developing custom JavaScript behavior, or custom style for the column item. If the DOM ID is not defined, an internal ID is used for the column item ID. | |
cssClasses | array of strings | No | data type=string; maxLen=255Enter classes to add to this component. You may add multiple classes by separating them with spaces. Note: This property can be used to make style modifications to the corresponding item when the Interactive Grid is editable. | |
customAttributes | string | No | data type=string; maxLen=2000Enter 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. | |
columnInitJavaScriptFunction | multiline string | No | data type=multiline string; maxLen=4000Enter a JavaScript function that takes a configuration object for the column, modifies the object, and returns it. This allows advanced customization of the column appearance, features, and behavior. | |
initJavaScriptFunction | multiline string | No | data type=multiline string; maxLen=4000 |
advanced {
htmlDomId: value
cssClasses: [
value
value
]
customAttributes: value
columnInitJavaScriptFunction: ```javascript-browser
value
```
initJavaScriptFunction: ```javascript-browser
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 neverSelect 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 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)type in (userPreference=value)type in (userPreference!=value) | |
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) | |
execute | enum | Yes | once | data type=string; lov=STATICValid values: forEachRow onceApplies when 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
]
execute: forEachRow
}security
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
authorizationScheme | enum | No | data type=reference; lov=COMPONENT; references=authorizationValid values: mustNotBePublicUser | |
escapeSpecialChars | boolean | Yes | true | data type=boolean |
security {
authorizationScheme: mustNotBePublicUser
escapeSpecialChars: false
}help
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
helpText | multiline string | No | data type=multiline string; maxLen=4000Enter help text for this column. |
help {
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
column sample (
columnName: value
type: stopAndStartGridLayout
heading {
heading: value
alignment: start
alternativeLabel: 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 {
parentColumns: [
value
value
]
itemsToSubmit: [
value
value
]
parentRequired: false
}
multipleValues {
type: delimitedList
separator: value
}
layout {
sequence: 42
columnAlignment: start
group: @component
useGroupFor: both
stretch: never
}
accessibility {
valueIdentifiesRow: false
}
appearance {
cssClasses: [
value
value
]
icon: value
formatMask: value
width: 42
height: 42
valuePlaceholder: value
}
validation {
valueRequired: false
maxLength: 42
}
link {
target: {
type: in_app
url: value
app: value
page: value
items: [
value
value
]
clearCache: value
action: value
request: value
anchor: value
session: "&SESSION."
debug: "&DEBUG."
printerFriendly: N
otherArgs: value
}
linkText: value
linkAttributes: value
}
source {
type: databaseColumn
databaseColumn: value
sqlExpression: ```sql
value
```
dataType: varchar2
queryOnly: false
primaryKey: false
}
masterDetail {
masterColumn: @component
}
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
duplicateCopiesExistingValue: false
}
sessionState {
dataType: varchar2
}
columnFilter {
enabled: false
performanceImpactingOperators: [
contains
startsWith
]
textCase: upper
lovType: none
dateRanges: all
sqlQuery: ```sql
value
```
namedLov: @component
staticValues: ```
value
```
language: plsql
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
exactMatch: false
}
exportPrinting {
includeInExportPrint: false
}
enableUsersTo {
sort: false
controlBreakAggregate: false
hide: false
}
advanced {
htmlDomId: value
cssClasses: [
value
value
]
customAttributes: value
columnInitJavaScriptFunction: ```javascript-browser
value
```
initJavaScriptFunction: ```javascript-browser
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
]
execute: forEachRow
}
security {
authorizationScheme: mustNotBePublicUser
escapeSpecialChars: false
}
help {
helpText: ```html
value
```
}
config {
buildOption: @component
}
comments {
comments: ```
value
```
}
)