column
type = interactiveGrid| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
columnName | string | Yes | data type=string; maxLen=128 | |
type | enum | Yes | data type=string; lov=PLUGINSValid values: actionsMenu checkbox checkboxGroup colorPicker datePicker datePickerJquery displayOnly hidden htmlExpression link markdownEditor numberField password percentGraph popupLov radioGroup richTextEditor rowSelector selectList shuttle starRating switch textField textFieldWithAutocomplete textareaSelect 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 endApplies when type supports VISIBLE |
alternativeLabel | string | No | data type=string; maxLen=4000Applies when type supports VISIBLE |
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 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 |
|---|---|---|---|---|
parentColumns | 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 parentColumns is set | |
parentRequired | boolean | Yes | true | data type=booleanApplies when type supports CASCADING_LOV and type supports LOV and 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 jsonArrayApplies when type supports MULTI_VALUE_ALWAYS |
type | enum | No | data type=string; lov=STATICValid values: delimitedList jsonArrayApplies when type supports MULTI_VALUE_OPTIONAL | |
separator | string | Yes | : | data type=string; maxLen=5Applies when type supports MULTI_VALUE_ALWAYS and type = delimitedListtype supports MULTI_VALUE_OPTIONAL and 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 endApplies when type supports VISIBLE |
group | reference | No | data type=reference; lov=COMPONENT; references=columnGroupApplies when type supports VISIBLE | |
useGroupFor | enum | Yes | both | data type=string; lov=STATICValid values: both singleRowView headingApplies when type supports VISIBLE and group is set |
stretch | enum | No | data type=string; lov=STATICValid values: never alwaysApplies when type supports VISIBLE |
layout {
sequence: 42
columnAlignment: start
group: @component
useGroupFor: both
stretch: never
}accessibility
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
valueIdentifiesRow | boolean | Yes | false | data type=booleanApplies when type supports SOURCE |
accessibility {
valueIdentifiesRow: false
}appearance
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
cssClasses | array of strings | No | data type=string; maxLen=255Applies when type supports VISIBLEEnter 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=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 {
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
}link
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
target | complex | No | data type=complex; maxLen=32767Applies when type supports link | |
linkText | string | No | data type=string; maxLen=4000Applies when type supports link and target is set | |
linkAttributes | string | No | data type=string; maxLen=4000Applies when type supports link and 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 noneApplies when type supports SOURCE |
databaseColumn | string | Yes | data type=string; maxLen=128Applies when type supports SOURCE and type = databaseColumn | |
sqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports SOURCE and 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 supports SOURCE and type in (databaseColumn)type supports SOURCE and type in (sqlExpression) | |
queryOnly | boolean | Yes | false | data type=booleanApplies when type supports SOURCE and type = databaseColumn and type in (databaseColumn)type supports SOURCE and type = databaseColumn and type in (sqlExpression) |
primaryKey | boolean | Yes | false | data type=booleanApplies when type supports SOURCE and 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 supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (varchar2)type supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (number)type supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (date)type supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestamp)type supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone)type supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone)type supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (varchar2)type supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (number)type supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (date)type supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestamp)type supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone)type supports SOURCE and 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 supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (varchar2)type supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (number)type supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (date)type supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestamp)type supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone)type supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone)type supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (varchar2)type supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (number)type supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (date)type supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestamp)type supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone)type supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone) | |
staticValue | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (varchar2) and type = statictype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (number) and type = statictype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (date) and type = statictype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestamp) and type = statictype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone) and type = statictype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type = statictype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (varchar2) and type = statictype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (number) and type = statictype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (date) and type = statictype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestamp) and type = statictype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone) and type = statictype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone) and type = static | |
item | string | Yes | data type=string; maxLen=32767; textCase=UPPERApplies when type supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (varchar2) and type = itemtype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (number) and type = itemtype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (date) and type = itemtype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestamp) and type = itemtype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone) and type = itemtype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type = itemtype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (varchar2) and type = itemtype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (number) and type = itemtype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (date) and type = itemtype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestamp) and type = itemtype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone) and type = itemtype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone) and type = item | |
sqlQuerySingleValue | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (varchar2) and type = sqlQuerySingleValuetype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (number) and type = sqlQuerySingleValuetype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (date) and type = sqlQuerySingleValuetype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestamp) and type = sqlQuerySingleValuetype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone) and type = sqlQuerySingleValuetype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type = sqlQuerySingleValuetype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (varchar2) and type = sqlQuerySingleValuetype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (number) and type = sqlQuerySingleValuetype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (date) and type = sqlQuerySingleValuetype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestamp) and type = sqlQuerySingleValuetype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone) and type = sqlQuerySingleValuetype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone) and type = sqlQuerySingleValue | |
sqlQueryMultipleValues | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (varchar2) and type = sqlQueryMultipleValuestype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (number) and type = sqlQueryMultipleValuestype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (date) and type = sqlQueryMultipleValuestype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestamp) and type = sqlQueryMultipleValuestype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone) and type = sqlQueryMultipleValuestype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type = sqlQueryMultipleValuestype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (varchar2) and type = sqlQueryMultipleValuestype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (number) and type = sqlQueryMultipleValuestype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (date) and type = sqlQueryMultipleValuestype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestamp) and type = sqlQueryMultipleValuestype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone) and type = sqlQueryMultipleValuestype supports SOURCE and type = 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 supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (varchar2) and type = expressiontype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (number) and type = expressiontype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (date) and type = expressiontype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestamp) and type = expressiontype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone) and type = expressiontype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type = expressiontype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (varchar2) and type = expressiontype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (number) and type = expressiontype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (date) and type = expressiontype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestamp) and type = expressiontype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone) and type = expressiontype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone) and type = expression |
sqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (varchar2) and type = expression and language = sqltype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (number) and type = expression and language = sqltype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (date) and type = expression and language = sqltype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestamp) and type = expression and language = sqltype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone) and type = expression and language = sqltype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type = expression and language = sqltype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (varchar2) and type = expression and language = sqltype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (number) and type = expression and language = sqltype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (date) and type = expression and language = sqltype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestamp) and type = expression and language = sqltype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone) and type = expression and language = sqltype supports SOURCE and type = 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 supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (varchar2) and type = expression and language = plsqltype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (number) and type = expression and language = plsqltype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (date) and type = expression and language = plsqltype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestamp) and type = expression and language = plsqltype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone) and type = expression and language = plsqltype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type = expression and language = plsqltype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (varchar2) and type = expression and language = plsqltype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (number) and type = expression and language = plsqltype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (date) and type = expression and language = plsqltype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestamp) and type = expression and language = plsqltype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone) and type = expression and language = plsqltype supports SOURCE and type = 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 supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (varchar2) and type = expression and language = javaScript-mletype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (number) and type = expression and language = javaScript-mletype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (date) and type = expression and language = javaScript-mletype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestamp) and type = expression and language = javaScript-mletype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone) and type = expression and language = javaScript-mletype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type = expression and language = javaScript-mletype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (varchar2) and type = expression and language = javaScript-mletype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (number) and type = expression and language = javaScript-mletype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (date) and type = expression and language = javaScript-mletype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestamp) and type = expression and language = javaScript-mletype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone) and type = expression and language = javaScript-mletype supports SOURCE and type = 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 supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (varchar2) and type = functionBodytype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (number) and type = functionBodytype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (date) and type = functionBodytype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestamp) and type = functionBodytype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone) and type = functionBodytype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type = functionBodytype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (varchar2) and type = functionBodytype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (number) and type = functionBodytype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (date) and type = functionBodytype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestamp) and type = functionBodytype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone) and type = functionBodytype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone) and type = functionBody |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (varchar2) and type = functionBody and language = plsqltype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (number) and type = functionBody and language = plsqltype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (date) and type = functionBody and language = plsqltype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestamp) and type = functionBody and language = plsqltype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone) and type = functionBody and language = plsqltype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type = functionBody and language = plsqltype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (varchar2) and type = functionBody and language = plsqltype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (number) and type = functionBody and language = plsqltype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (date) and type = functionBody and language = plsqltype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestamp) and type = functionBody and language = plsqltype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone) and type = functionBody and language = plsqltype supports SOURCE and type = 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 supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (varchar2) and type = functionBody and language = javaScript-mletype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (number) and type = functionBody and language = javaScript-mletype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (date) and type = functionBody and language = javaScript-mletype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestamp) and type = functionBody and language = javaScript-mletype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone) and type = functionBody and language = javaScript-mletype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type = functionBody and language = javaScript-mletype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (varchar2) and type = functionBody and language = javaScript-mletype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (number) and type = functionBody and language = javaScript-mletype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (date) and type = functionBody and language = javaScript-mletype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestamp) and type = functionBody and language = javaScript-mletype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone) and type = functionBody and language = javaScript-mletype supports SOURCE and type = 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 supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (varchar2) and type = sequencetype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (number) and type = sequencetype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (date) and type = sequencetype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestamp) and type = sequencetype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone) and type = sequencetype supports SOURCE and type = databaseColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type = sequencetype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (varchar2) and type = sequencetype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (number) and type = sequencetype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (date) and type = sequencetype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestamp) and type = sequencetype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone) and type = sequencetype supports SOURCE and type = databaseColumn and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone) and type = sequence | |
duplicateCopiesExistingValue | boolean | Yes | true | data type=booleanApplies when type supports SOURCE and type = databaseColumn and primaryKey = false and type in (databaseColumn) and queryOnly = false and dataType in (varchar2)type supports SOURCE and type = databaseColumn and primaryKey = false and type in (databaseColumn) and queryOnly = false and dataType in (number)type supports SOURCE and type = databaseColumn and primaryKey = false and type in (databaseColumn) and queryOnly = false and dataType in (date)type supports SOURCE and type = databaseColumn and primaryKey = false and type in (databaseColumn) and queryOnly = false and dataType in (timestamp)type supports SOURCE and type = databaseColumn and primaryKey = false and type in (databaseColumn) and queryOnly = false and dataType in (timestampWithTimeZone)type supports SOURCE and type = databaseColumn and primaryKey = false and type in (databaseColumn) and queryOnly = false and dataType in (timestampWithLocalTimeZone)type supports SOURCE and type = databaseColumn and primaryKey = false and type in (databaseColumn) and queryOnly = false and type in (sqlExpression) and dataType in (varchar2)type supports SOURCE and type = databaseColumn and primaryKey = false and type in (databaseColumn) and queryOnly = false and type in (sqlExpression) and dataType in (number)type supports SOURCE and type = databaseColumn and primaryKey = false and type in (databaseColumn) and queryOnly = false and type in (sqlExpression) and dataType in (date)type supports SOURCE and type = databaseColumn and primaryKey = false and type in (databaseColumn) and queryOnly = false and type in (sqlExpression) and dataType in (timestamp)type supports SOURCE and type = databaseColumn and primaryKey = false and type in (databaseColumn) and queryOnly = false and type in (sqlExpression) and dataType in (timestampWithTimeZone)type supports SOURCE and type = databaseColumn and primaryKey = false and type in (databaseColumn) and queryOnly = false and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone)type supports SOURCE and type = databaseColumn and primaryKey = false and type in (sqlExpression) and queryOnly = false and type in (databaseColumn) and dataType in (varchar2)type supports SOURCE and type = databaseColumn and primaryKey = false and type in (sqlExpression) and queryOnly = false and type in (databaseColumn) and dataType in (number)type supports SOURCE and type = databaseColumn and primaryKey = false and type in (sqlExpression) and queryOnly = false and type in (databaseColumn) and dataType in (date)type supports SOURCE and type = databaseColumn and primaryKey = false and type in (sqlExpression) and queryOnly = false and type in (databaseColumn) and dataType in (timestamp)type supports SOURCE and type = databaseColumn and primaryKey = false and type in (sqlExpression) and queryOnly = false and type in (databaseColumn) and dataType in (timestampWithTimeZone)type supports SOURCE and type = databaseColumn and primaryKey = false and type in (sqlExpression) and queryOnly = false and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone)type supports SOURCE and type = databaseColumn and primaryKey = false and type in (sqlExpression) and queryOnly = false and dataType in (varchar2)type supports SOURCE and type = databaseColumn and primaryKey = false and type in (sqlExpression) and queryOnly = false and dataType in (number)type supports SOURCE and type = databaseColumn and primaryKey = false and type in (sqlExpression) and queryOnly = false and dataType in (date)type supports SOURCE and type = databaseColumn and primaryKey = false and type in (sqlExpression) and queryOnly = false and dataType in (timestamp)type supports SOURCE and type = databaseColumn and primaryKey = false and type in (sqlExpression) and queryOnly = false and dataType in (timestampWithTimeZone)type supports SOURCE and 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 supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set |
performanceImpactingOperators | array of enums | No | data type=string; lov=STATICValid values: contains startsWith caseInsensitive regexpApplies when type supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and type supports JOIN_LOVtype supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and type in (databaseColumn) and dataType in (varchar2)type supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and type in (databaseColumn) and dataType in (clob)type supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and type in (sqlExpression) and dataType in (varchar2)type supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and 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 supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and type supports JOIN_LOVtype supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and type in (databaseColumn) and dataType = varchar2type supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type 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 supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true |
dateRanges | enum | Yes | all | data type=string; lov=STATICValid values: all past futureApplies when type supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and lovType = distinctColumn and type in (databaseColumn) and dataType in (date)type supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and lovType = distinctColumn and type in (databaseColumn) and dataType in (date) and type does not support JOIN_LOVtype supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and lovType = distinctColumn and type in (databaseColumn) and dataType in (timestamp)type supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and lovType = distinctColumn and type in (databaseColumn) and dataType in (timestamp) and type does not support JOIN_LOVtype supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and lovType = distinctColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone)type supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and lovType = distinctColumn and type in (databaseColumn) and dataType in (timestampWithTimeZone) and type does not support JOIN_LOVtype supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and lovType = distinctColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone)type supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and lovType = distinctColumn and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type does not support JOIN_LOVtype supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and lovType = distinctColumn and type in (sqlExpression) and dataType in (date)type supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and lovType = distinctColumn and type in (sqlExpression) and dataType in (date) and type does not support JOIN_LOVtype supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and lovType = distinctColumn and type in (sqlExpression) and dataType in (timestamp)type supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and lovType = distinctColumn and type in (sqlExpression) and dataType in (timestamp) and type does not support JOIN_LOVtype supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and lovType = distinctColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone)type supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and lovType = distinctColumn and type in (sqlExpression) and dataType in (timestampWithTimeZone) and type does not support JOIN_LOVtype supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and lovType = distinctColumn and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone)type supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and lovType = distinctColumn and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone) and type does not support JOIN_LOV |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and lovType = sqlQuery | |
namedLov | reference | Yes | data type=reference; lov=COMPONENT; references=lovApplies when type supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and lovType = sharedComponent | |
staticValues | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and lovType = staticValues | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when type supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and lovType = functionBody |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=32767Applies when type supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and lovType = functionBody and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=32767Applies when type supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and lovType = functionBody and language = javaScript-mle | |
exactMatch | boolean | Yes | true | data type=booleanApplies when type supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and type supports JOIN_LOVtype supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type is set and enabled = true and type in (databaseColumn) and dataType = varchar2type supports FILTER and type supports SOURCE and type supports CASCADING_LOV and type supports LOV and type 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=booleanApplies when type supports SOURCE |
exportPrinting {
includeInExportPrint: false
}enableUsersTo
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
sort | boolean | Yes | true | data type=booleanApplies when type supports SOURCE and type in (databaseColumn) and dataType in (varchar2) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLEtype supports SOURCE and type in (databaseColumn) and dataType in (number) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLEtype supports SOURCE and type in (databaseColumn) and dataType in (date) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLEtype supports SOURCE and type in (databaseColumn) and dataType in (timestamp) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLEtype supports SOURCE and type in (databaseColumn) and dataType in (timestampWithTimeZone) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLEtype supports SOURCE and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLEtype supports SOURCE and type in (databaseColumn) and dataType in (intervalDayToSecond) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLEtype supports SOURCE and type in (databaseColumn) and dataType in (intervalYearToMonth) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLEtype supports SOURCE and type in (sqlExpression) and dataType in (varchar2) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLEtype supports SOURCE and type in (sqlExpression) and dataType in (number) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLEtype supports SOURCE and type in (sqlExpression) and dataType in (date) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLEtype supports SOURCE and type in (sqlExpression) and dataType in (timestamp) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLEtype supports SOURCE and type in (sqlExpression) and dataType in (timestampWithTimeZone) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLEtype supports SOURCE and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLEtype supports SOURCE and type in (sqlExpression) and dataType in (intervalDayToSecond) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLEtype supports SOURCE and type in (sqlExpression) and dataType in (intervalYearToMonth) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLE |
controlBreakAggregate | boolean | Yes | true | data type=booleanApplies when type supports SOURCE and type in (databaseColumn) and dataType in (varchar2) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLE and sort = truetype supports SOURCE and type in (databaseColumn) and dataType in (number) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLE and sort = truetype supports SOURCE and type in (databaseColumn) and dataType in (date) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLE and sort = truetype supports SOURCE and type in (databaseColumn) and dataType in (timestamp) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLE and sort = truetype supports SOURCE and type in (databaseColumn) and dataType in (timestampWithTimeZone) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLE and sort = truetype supports SOURCE and type in (databaseColumn) and dataType in (timestampWithLocalTimeZone) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLE and sort = truetype supports SOURCE and type in (databaseColumn) and dataType in (intervalDayToSecond) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLE and sort = truetype supports SOURCE and type in (databaseColumn) and dataType in (intervalYearToMonth) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLE and sort = truetype supports SOURCE and type in (sqlExpression) and dataType in (varchar2) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLE and sort = truetype supports SOURCE and type in (sqlExpression) and dataType in (number) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLE and sort = truetype supports SOURCE and type in (sqlExpression) and dataType in (date) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLE and sort = truetype supports SOURCE and type in (sqlExpression) and dataType in (timestamp) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLE and sort = truetype supports SOURCE and type in (sqlExpression) and dataType in (timestampWithTimeZone) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLE and sort = truetype supports SOURCE and type in (sqlExpression) and dataType in (timestampWithLocalTimeZone) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLE and sort = truetype supports SOURCE and type in (sqlExpression) and dataType in (intervalDayToSecond) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLE and sort = truetype supports SOURCE and type in (sqlExpression) and dataType in (intervalYearToMonth) and type supports CASCADING_LOV and type supports LOV and type is set and type supports VISIBLE and sort = true |
hide | boolean | Yes | true | data type=booleanApplies when type supports VISIBLE |
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=255Applies when type supports ELEMENTEnter 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=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. | |
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=4000Applies when type supports INIT_JAVASCRIPT_CODE |
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 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) | |
execute | enum | Yes | once | data type=string; lov=STATICValid values: forEachRow onceApplies 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
]
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=booleanApplies when type supports ESCAPE_OUTPUT |
security {
authorizationScheme: mustNotBePublicUser
escapeSpecialChars: false
}help
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
helpText | multiline string | No | data type=multiline string; maxLen=4000Applies when type supports VISIBLEEnter 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: actionsMenu
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
```
}
)