column

Parent: region

Applies whentype supports SOURCE_LOCATION and location is set

Direct Properties:

PropertyTypeRequiredDefault ValueDetails
namestringYesdata type=string; maxLen=128; textCase=UPPER

Property Groups:

  • layout
  • source
  • lov
  • accessibility
  • appearance
  • serverSideCondition
  • security
  • config
  • comments
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.

 
layout {
  sequence: 42
}
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
primaryKeybooleanYesfalsedata type=boolean
Applies whentype = databaseColumn
availableOnClientbooleanYesfalsedata type=boolean
Applies whentype = databaseColumn and primaryKey = false
valueProtectedbooleanYestruedata type=boolean
Applies whentype = databaseColumn and primaryKey = false and availableOnClient = true
 
source {
  type: databaseColumn
  databaseColumn: value
  sqlExpression: ```sql
    value
  ```
  dataType: varchar2
  primaryKey: false
  availableOnClient: false
  valueProtected: false
}
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
 
lov {
  type: sharedComponent
  lov: @component
  sqlQuery: ```sql
    value
  ```
  staticValues: ```
    value
  ```
  language: plsql
  plsqlFunctionBody: ```plsql
    value
  ```
  javaScriptFunctionBody: ```javascript-mle
    value
  ```
  displayExtraValues: false
}
accessibility
PropertyTypeRequiredDefault ValueDetails
valueIdentifiesRowbooleanYesfalsedata type=boolean
Applies whendisplay = report
 
accessibility {
  valueIdentifiesRow: false
}
appearance
PropertyTypeRequiredDefault ValueDetails
formatMaskstringNodata type=string; maxLen=255
Applies whendataType in (date)dataType in (timestamp)dataType in (timestampWithTimeZone)dataType in (timestampWithLocalTimeZone)
formatMaskstringNodata type=string; maxLen=255
Applies whendataType = number
groupbooleanYesfalsedata type=boolean
Applies whentype supports SUPPORTS_GROUPS and dataType in (varchar2) and type in (databaseColumn)type supports SUPPORTS_GROUPS and dataType in (varchar2) and type in (sqlExpression)type supports SUPPORTS_GROUPS and dataType in (number) and type in (databaseColumn)type supports SUPPORTS_GROUPS and dataType in (number) and type in (sqlExpression)type supports SUPPORTS_GROUPS and dataType in (date) and type in (databaseColumn)type supports SUPPORTS_GROUPS and dataType in (date) and type in (sqlExpression)type supports SUPPORTS_GROUPS and dataType in (timestamp) and type in (databaseColumn)type supports SUPPORTS_GROUPS and dataType in (timestamp) and type in (sqlExpression)type supports SUPPORTS_GROUPS and dataType in (timestampWithTimeZone) and type in (databaseColumn)type supports SUPPORTS_GROUPS and dataType in (timestampWithTimeZone) and type in (sqlExpression)type supports SUPPORTS_GROUPS and dataType in (timestampWithLocalTimeZone) and type in (databaseColumn)type supports SUPPORTS_GROUPS and dataType in (timestampWithLocalTimeZone) and type in (sqlExpression)type supports SUPPORTS_GROUPS and dataType in (intervalYearToMonth) and type in (databaseColumn)type supports SUPPORTS_GROUPS and dataType in (intervalYearToMonth) and type in (sqlExpression)
 
appearance {
  formatMask: value
  group: false
}
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
  ]
}
security
PropertyTypeRequiredDefault ValueDetails
authorizationSchemeenumNodata type=reference; lov=COMPONENT; references=authorization
Valid values: mustNotBePublicUser
 
security {
  authorizationScheme: mustNotBePublicUser
}
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 (
    name: value
    layout {
        sequence: 42
    }
    source {
        type: databaseColumn
        databaseColumn: value
        sqlExpression: ```sql
          value
        ```
        dataType: varchar2
        primaryKey: false
        availableOnClient: false
        valueProtected: false
    }
    lov {
        type: sharedComponent
        lov: @component
        sqlQuery: ```sql
          value
        ```
        staticValues: ```
          value
        ```
        language: plsql
        plsqlFunctionBody: ```plsql
          value
        ```
        javaScriptFunctionBody: ```javascript-mle
          value
        ```
        displayExtraValues: false
    }
    accessibility {
        valueIdentifiesRow: false
    }
    appearance {
        formatMask: value
        group: false
    }
    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
        ]
    }
    security {
        authorizationScheme: mustNotBePublicUser
    }
    config {
        buildOption: @component
    }
    comments {
        comments: ```
          value
        ```
    }
)