column (selectOne)

Parent: column

Applies whentype = selectOne

Direct Properties:

PropertyTypeRequiredDefault ValueDetails
columnNamestringYesdata type=string; maxLen=128
typeenumYesdata type=string; lov=PLUGINS
Valid values: selectOne

Select 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#

Property Groups:

  • search
  • settings
  • messages
  • heading
  • lov
  • cascadingLov
  • multipleValues
  • layout
  • accessibility
  • appearance
  • validation
  • link
  • source
  • masterDetail
  • default
  • sessionState
  • columnFilter
  • exportPrinting
  • enableUsersTo
  • advanced
  • serverSideCondition
  • readOnly
  • security
  • help
  • config
  • comments
search
PropertyTypeRequiredDefault ValueDetails
matchTypeenumYescontainsdata type=string; maxLen=4000; lov=STATIC
Valid values: startsWith contains
caseSensitivebooleanYesfalsedata type=boolean
minCharsintegerYes0data type=integer; maxLen=2
search {
  matchType: startsWith
  caseSensitive: false
  minChars: 42
}
settings
PropertyTypeRequiredDefault ValueDetails
valueHtmlExpressionstringNodata type=string; maxLen=4000
fetchOnSearchbooleanYesfalsedata type=boolean
maxValuesInListintegerNodata type=integer; maxLen=3
Applies wheninfinite_scroll = N
useCachebooleanYestruedata type=boolean
Applies whenfetch_on_search = Y
infiniteScrollbooleanYestruedata type=boolean
settings {
  valueHtmlExpression: value
  fetchOnSearch: false
  maxValuesInList: 42
  useCache: false
  infiniteScroll: false
}
messages
PropertyTypeRequiredDefault ValueDetails
noDataFoundMessagestringNodata type=string; maxLen=255
messages {
  noDataFoundMessage: value
}
heading
PropertyTypeRequiredDefault ValueDetails
headingstringNodata type=string; maxLen=4000
Enter 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.
alignmentenumYesstartdata type=string; lov=STATIC
Valid values: start center end
alternativeLabelstringNodata type=string; maxLen=4000
heading {
  heading: value
  alignment: start
  alternativeLabel: value
}
lov
PropertyTypeRequiredDefault ValueDetails
typeenumNodata type=string; lov=STATIC
Valid values: sharedComponent sqlQuery staticValues functionBody
lovreferenceYesdata type=reference; lov=COMPONENT; references=lov
Applies whentype = sharedComponent
sqlQuerymultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = sqlQuery

Enter 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.

staticValuesmultiline stringYesSTATIC:Display1;Return1,Display2;Return2data type=multiline string; maxLen=4000
Applies whentype = staticValues
languageenumYesplsqldata type=string; lov=STATIC
Valid values: plsql javaScript-mle
Applies whentype = functionBody
plsqlFunctionBodymultiline stringYesdata type=multiline string; maxLen=32767
Applies whentype = functionBody and language = plsql
javaScriptFunctionBodymultiline stringYesdata type=multiline string; maxLen=32767
Applies whentype = functionBody and language = javaScript-mle
displayExtraValuesbooleanYestruedata type=boolean
Applies whentype is set
displayNullValuebooleanYestruedata type=boolean
Applies whentype is set
nullDisplayValuestringNodata type=string; maxLen=255
Applies whentype is set and displayNullValue = true
nullReturnValuestringNodata type=string; maxLen=255
Applies whentype 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
PropertyTypeRequiredDefault ValueDetails
parentColumnsarray of stringsNodata type=string; maxLen=255; textCase=UPPER
Applies whentype is set
itemsToSubmitarray of stringsNodata type=string; maxLen=4000; textCase=UPPER
Applies whentype is set and parentColumns is set
parentRequiredbooleanYestruedata type=boolean
Applies whentype is set and parentColumns is set
cascadingLov {
  parentColumns: [
    value
    value
  ]
  itemsToSubmit: [
    value
    value
  ]
  parentRequired: false
}
multipleValues
PropertyTypeRequiredDefault ValueDetails
typeenumYesdelimitedListdata type=string; lov=STATIC
Valid values: delimitedList jsonArray
typeenumNodata type=string; lov=STATIC
Valid values: delimitedList jsonArray
separatorstringYes:data type=string; maxLen=5
Applies whentype = delimitedList
multipleValues {
  type: delimitedList
  separator: value
}
layout
PropertyTypeRequiredDefault ValueDetails
sequencenumberYesdata type=number; maxLen=22

Enter 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.

columnAlignmentenumYesstartdata type=string; lov=STATIC
Valid values: start center end
groupreferenceNodata type=reference; lov=COMPONENT; references=columnGroup
useGroupForenumYesbothdata type=string; lov=STATIC
Valid values: both singleRowView heading
Applies whengroup is set
stretchenumNodata type=string; lov=STATIC
Valid values: never always
layout {
  sequence: 42
  columnAlignment: start
  group: @component
  useGroupFor: both
  stretch: never
}
accessibility
PropertyTypeRequiredDefault ValueDetails
valueIdentifiesRowbooleanYesfalsedata type=boolean
accessibility {
  valueIdentifiesRow: false
}
appearance
PropertyTypeRequiredDefault ValueDetails
cssClassesarray of stringsNodata type=string; maxLen=255

Enter 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.

iconstringNodata type=string; maxLen=255

Enter 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.

formatMaskstringNodata type=string; maxLen=255
formatMaskstringNodata type=string; maxLen=255
formatMaskstringNodata type=string; maxLen=255
widthnumberNodata type=number; maxLen=22
heightnumberNodata type=number; maxLen=22
valuePlaceholderstringNodata type=string; maxLen=255
appearance {
  cssClasses: [
    value
    value
  ]
  icon: value
  formatMask: value
  width: 42
  height: 42
  valuePlaceholder: value
}
validation
PropertyTypeRequiredDefault ValueDetails
valueRequiredbooleanYesfalsedata type=boolean
maxLengthnumberNodata type=number; maxLen=22
validation {
  valueRequired: false
  maxLength: 42
}
link
PropertyTypeRequiredDefault ValueDetails
targetcomplexNodata type=complex; maxLen=32767
linkTextstringNodata type=string; maxLen=4000
Applies whentarget is set
linkAttributesstringNodata type=string; maxLen=4000
Applies whentarget 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
PropertyTypeRequiredDefault ValueDetails
typeenumYesdatabaseColumndata type=string; lov=STATIC
Valid values: databaseColumn sqlExpression none
databaseColumnstringYesdata type=string; maxLen=128
Applies whentype = databaseColumn
sqlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = sqlExpression
dataTypeenumYesdata type=string; maxLen=128; lov=STATIC
Valid values: varchar2 number date timestamp timestampWithTimeZone timestampWithLocalTimeZone intervalYearToMonth intervalDayToSecond clob blob boolean rowid bfile sdoGeometry
Applies whentype in (databaseColumn)type in (sqlExpression)
queryOnlybooleanYesfalsedata type=boolean
Applies whentype = databaseColumn and type in (databaseColumn)type = databaseColumn and type in (sqlExpression)
primaryKeybooleanYesfalsedata type=boolean
Applies whentype = databaseColumn
source {
  type: databaseColumn
  databaseColumn: value
  sqlExpression: ```sql
    value
  ```
  dataType: varchar2
  queryOnly: false
  primaryKey: false
}
masterDetail
PropertyTypeRequiredDefault ValueDetails
masterColumnreferenceNodata type=reference; lov=COMPONENT; references=column
Applies whentype = 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
PropertyTypeRequiredDefault ValueDetails
typeenumNodata type=string; lov=STATIC
Valid values: static item sqlQuerySingleValue sqlQueryMultipleValues expression functionBody sequence
Applies whentype = 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)
staticValuemultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = 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
itemstringYesdata type=string; maxLen=32767; textCase=UPPER
Applies whentype = 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
sqlQuerySingleValuemultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = 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
sqlQueryMultipleValuesmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = 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
languageenumYesplsqldata type=string; lov=STATIC
Valid values: sql plsql javaScript-mle
Applies whentype = 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
sqlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = 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
plsqlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = 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
javaScriptExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = 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
languageenumYesplsqldata type=string; lov=STATIC
Valid values: plsql javaScript-mle
Applies whentype = 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
plsqlFunctionBodymultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = 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
javaScriptFunctionBodymultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = 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
sequencestringYesdata type=string; maxLen=128
Applies whentype = 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
duplicateCopiesExistingValuebooleanYestruedata type=boolean
Applies whentype = 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
PropertyTypeRequiredDefault ValueDetails
dataTypeenumYesvarchar2data type=string; maxLen=128; lov=STATIC
Valid values: varchar2 clob boolean
sessionState {
  dataType: varchar2
}
columnFilter
PropertyTypeRequiredDefault ValueDetails
enabledbooleanYestruedata type=boolean
Applies whentype is set
performanceImpactingOperatorsarray of enumsNodata type=string; lov=STATIC
Valid values: contains startsWith caseInsensitive regexp
Applies whentype 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)
textCaseenumYesmixeddata type=string; lov=STATIC
Valid values: upper lower mixed
Applies whentype 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
lovTypeenumYesdistinctColumndata type=string; lov=STATIC
Valid values: none distinctColumn sqlQuery sharedComponent staticValues functionBody useLov
Applies whentype is set and enabled = true
dateRangesenumYesalldata type=string; lov=STATIC
Valid values: all past future
Applies whentype 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)
sqlQuerymultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype is set and enabled = true and lovType = sqlQuery
namedLovreferenceYesdata type=reference; lov=COMPONENT; references=lov
Applies whentype is set and enabled = true and lovType = sharedComponent
staticValuesmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype is set and enabled = true and lovType = staticValues
languageenumYesplsqldata type=string; lov=STATIC
Valid values: plsql javaScript-mle
Applies whentype is set and enabled = true and lovType = functionBody
plsqlFunctionBodymultiline stringYesdata type=multiline string; maxLen=32767
Applies whentype is set and enabled = true and lovType = functionBody and language = plsql
javaScriptFunctionBodymultiline stringYesdata type=multiline string; maxLen=32767
Applies whentype is set and enabled = true and lovType = functionBody and language = javaScript-mle
exactMatchbooleanYestruedata type=boolean
Applies whentype 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
PropertyTypeRequiredDefault ValueDetails
includeInExportPrintbooleanYestruedata type=boolean
exportPrinting {
  includeInExportPrint: false
}
enableUsersTo
PropertyTypeRequiredDefault ValueDetails
sortbooleanYestruedata type=boolean
Applies whentype 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
controlBreakAggregatebooleanYestruedata type=boolean
Applies whentype 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
hidebooleanYestruedata type=boolean
enableUsersTo {
  sort: false
  controlBreakAggregate: false
  hide: false
}
advanced
PropertyTypeRequiredDefault ValueDetails
htmlDomIdstringNodata type=string; maxLen=255
Enter 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.
cssClassesarray of stringsNodata type=string; maxLen=255

Enter 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.

customAttributesstringNodata type=string; maxLen=2000
Enter 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.
columnInitJavaScriptFunctionmultiline stringNodata type=multiline string; maxLen=4000
Enter 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.
initJavaScriptFunctionmultiline stringNodata type=multiline string; maxLen=4000
advanced {
  htmlDomId: value
  cssClasses: [
    value
    value
  ]
  customAttributes: value
  columnInitJavaScriptFunction: ```javascript-browser
    value
  ```
  initJavaScriptFunction: ```javascript-browser
    value
  ```
}
serverSideCondition
PropertyTypeRequiredDefault ValueDetails
typeenumNodata type=string; lov=STATIC
Valid 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
sqlQuerymultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype in (rowsReturned)type in (noRowsReturned)
languageenumYesplsqldata type=string; lov=STATIC
Valid values: sql plsql javaScript-mle
Applies whentype = expression
sqlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = expression and language = sql
plsqlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = expression and language = plsql
javaScriptExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = expression and language = javaScript-mle
languageenumYesplsqldata type=string; lov=STATIC
Valid values: plsql javaScript-mle
Applies whentype = functionBody
plsqlFunctionBodymultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = functionBody and language = plsql
javaScriptFunctionBodymultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = functionBody and language = javaScript-mle
valuestringYesdata type=string; maxLen=4000
Applies whentype 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)
itemstringYesdata type=string; maxLen=4000; textCase=UPPER
Applies whentype 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)
preferencestringYesdata type=string; maxLen=4000; textCase=UPPER
Applies whentype in (userPreference=value)type in (userPreference!=value)
pageintegerYesdata type=integer; maxLen=4000
Applies whentype in (currentPage=page)type in (currentPage!=page)
pagesarray of integersYesdata type=integer; maxLen=4000
Applies whentype in (currentPageInList)type in (currentPageNotInList)
textstringYesdata type=string; maxLen=4000
Applies whentype in (textIsContainedInItem)type in (textIsContainedInValue)type in (textIsNotContainedInValue)type in (text=value)type in (text!=value)
valuestringYesdata type=string; maxLen=4000
Applies whentype 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)
listarray of stringsYesdata type=string; maxLen=4000
Applies whentype in (itemIsInColonDelimitedList)type in (itemIsNotInColonDelimitedList)
itemstringYesdata type=string; maxLen=4000; textCase=UPPER
Applies whentype = textIsContainedInItem
valuestringYesdata type=string; maxLen=4000
Applies whentype 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
PropertyTypeRequiredDefault ValueDetails
typeenumNodata type=string; lov=STATIC
Valid 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

Select 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.

sqlQuerymultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype in (rowsReturned)type in (noRowsReturned)
languageenumYesplsqldata type=string; lov=STATIC
Valid values: sql plsql javaScript-mle
Applies whentype = expression
sqlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = expression and language = sql
plsqlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = expression and language = plsql
javaScriptExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = expression and language = javaScript-mle
languageenumYesplsqldata type=string; lov=STATIC
Valid values: plsql javaScript-mle
Applies whentype = functionBody
plsqlFunctionBodymultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = functionBody and language = plsql
javaScriptFunctionBodymultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = functionBody and language = javaScript-mle
valuestringYesdata type=string; maxLen=4000
Applies whentype 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)
itemstringYesdata type=string; maxLen=4000; textCase=UPPER
Applies whentype 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)
preferencestringYesdata type=string; maxLen=4000; textCase=UPPER
Applies whentype in (userPreference=value)type in (userPreference!=value)
pageintegerYesdata type=integer; maxLen=4000
Applies whentype in (currentPage=page)type in (currentPage!=page)
pagesarray of integersYesdata type=integer; maxLen=4000
Applies whentype in (currentPageInList)type in (currentPageNotInList)
textstringYesdata type=string; maxLen=4000
Applies whentype in (textIsContainedInItem)type in (textIsContainedInValue)type in (textIsNotContainedInValue)type in (text=value)type in (text!=value)
valuestringYesdata type=string; maxLen=4000
Applies whentype 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)
listarray of stringsYesdata type=string; maxLen=4000
Applies whentype in (itemIsInColonDelimitedList)type in (itemIsNotInColonDelimitedList)
itemstringYesdata type=string; maxLen=4000; textCase=UPPER
Applies whentype = textIsContainedInItem
valuestringYesdata type=string; maxLen=4000
Applies whentype in (textIsContainedInValue)type in (textIsNotContainedInValue)type in (text=value)type in (text!=value)
executeenumYesoncedata type=string; lov=STATIC
Valid values: forEachRow once
Applies whentype 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
PropertyTypeRequiredDefault ValueDetails
authorizationSchemeenumNodata type=reference; lov=COMPONENT; references=authorization
Valid values: mustNotBePublicUser
escapeSpecialCharsbooleanYestruedata type=boolean
security {
  authorizationScheme: mustNotBePublicUser
  escapeSpecialChars: false
}
help
PropertyTypeRequiredDefault ValueDetails
helpTextmultiline stringNodata type=multiline string; maxLen=4000
Enter help text for this column.
help {
  helpText: ```html
    value
  ```
}
config
PropertyTypeRequiredDefault ValueDetails
buildOptionreferenceNodata type=reference; lov=COMPONENT; references=buildOption
config {
  buildOption: @component
}
comments
PropertyTypeRequiredDefault ValueDetails
commentsmultiline stringNodata type=multiline string; maxLen=4000
comments {
  comments: ```
    value
  ```
}

APEXlang Example

column sample (
    columnName: value
    type: selectOne
    search {
        matchType: startsWith
        caseSensitive: false
        minChars: 42
    }
    settings {
        valueHtmlExpression: value
        fetchOnSearch: false
        maxValuesInList: 42
        useCache: false
        infiniteScroll: false
    }
    messages {
        noDataFoundMessage: value
    }
    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
        ```
    }
)