column

Parent: region

Applies whentype supports COLUMNS

Direct Properties:

PropertyTypeRequiredDefault ValueDetails
columnNamestringYesdata type=string; maxLen=128
showbooleanYestruedata type=boolean

Property Groups:

  • source
  • heading
  • layout
  • appearance
  • advanced
  • serverSideCondition
  • security
  • config
  • comments
source
PropertyTypeRequiredDefault ValueDetails
dataTypestringYesdata type=string; maxLen=255
source {
  dataType: value
}
heading
PropertyTypeRequiredDefault ValueDetails
headingstringNodata type=string; maxLen=4000
Applies whentype supports COLUMN_HEADING and show = true
alignmentenumYesstartdata type=string; lov=STATIC
Valid values: start center end
Applies whentype supports HEADING_ALIGNMENT and show = true
heading {
  heading: value
  alignment: start
}
layout
PropertyTypeRequiredDefault ValueDetails
sequencenumberYesdata type=number; maxLen=22
columnAlignmentenumYesstartdata type=string; lov=STATIC
Valid values: start center end
Applies whentype supports VALUE_ALIGNMENT and show = true
layout {
  sequence: 42
  columnAlignment: start
}
appearance
PropertyTypeRequiredDefault ValueDetails
formatMaskstringNodata type=string; maxLen=255
Applies whendataType in (DATE)dataType in (TIMESTAMP)dataType in (TIMESTAMP_TZ)dataType in (TIMESTAMP_LTZ)
formatMaskstringNodata type=string; maxLen=255
Applies whendataType = NUMBER
cssClassesarray of stringsNodata type=string; maxLen=255
Applies whentype supports VALUE_CSS and show = true
appearance {
  formatMask: value
  cssClasses: [
    value
    value
  ]
}
advanced
PropertyTypeRequiredDefault ValueDetails
customAttributesstringNodata type=string; maxLen=2000
Applies whentype supports VALUE_ATTRIBUTE and show = true
advanced {
  customAttributes: 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
Applies whenshow = true
sqlQuerymultiline stringYesdata type=multiline string; maxLen=4000
Applies whenshow = true and type in (rowsReturned)show = true and type in (noRowsReturned)
languageenumYesplsqldata type=string; lov=STATIC
Valid values: sql plsql javaScript-mle
Applies whenshow = true and type = expression
sqlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whenshow = true and type = expression and language = sql
plsqlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whenshow = true and type = expression and language = plsql
javaScriptExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whenshow = true and type = expression and language = javaScript-mle
languageenumYesplsqldata type=string; lov=STATIC
Valid values: plsql javaScript-mle
Applies whenshow = true and type = functionBody
plsqlFunctionBodymultiline stringYesdata type=multiline string; maxLen=4000
Applies whenshow = true and type = functionBody and language = plsql
javaScriptFunctionBodymultiline stringYesdata type=multiline string; maxLen=4000
Applies whenshow = true and type = functionBody and language = javaScript-mle
valuestringYesdata type=string; maxLen=4000
Applies whenshow = true and type in (request=Value)show = true and type in (request!=Value)show = true and type in (requestIsContainedInValue)show = true and type in (requestIsNotContainedInValue)show = true and type in (currentLanguageIsContainedInValue)show = true and type in (currentLanguageIsNotContainedInValue)show = true and type in (currentLanguage!=value)show = true and type in (currentLanguage=value)show = true and type in (cgiEnvDadName=value)show = true and type in (cgiEnvDadName!=value)show = true and type in (cgiEnvServerName=value)show = true and type in (cgiEnvServerName!=value)show = true and type in (cgiEnvHttpHost=value)show = true and type in (cgiEnvHttpHost!=value)
itemstringYesdata type=string; maxLen=4000; textCase=UPPER
Applies whenshow = true and type in (item=value)show = true and type in (item!=value)show = true and type in (VALUE_OF_ITEM_IN_COND_1_EQ_COND_2)show = true and type in (VALUE_OF_ITEM_IN_COND_1_NOT_EQ_COND_2)show = true and type in (itemIsNull)show = true and type in (itemIsNotNull)show = true and type in (itemIsZero)show = true and type in (itemIsNotZero)show = true and type in (itemIsNullOrZero)show = true and type in (itemIsNotNullAndNotZero)show = true and type in (itemContainsNoSpaces)show = true and type in (itemIsNumeric)show = true and type in (itemIsNotNumeric)show = true and type in (itemIsAlphanumeric)show = true and type in (itemIsInColonDelimitedList)show = true and type in (itemIsNotInColonDelimitedList)
preferencestringYesdata type=string; maxLen=4000; textCase=UPPER
Applies whenshow = true and type in (userPreference=value)show = true and type in (userPreference!=value)
pageintegerYesdata type=integer; maxLen=4000
Applies whenshow = true and type in (currentPage=page)show = true and type in (currentPage!=page)
pagesarray of integersYesdata type=integer; maxLen=4000
Applies whenshow = true and type in (currentPageInList)show = true and type in (currentPageNotInList)
textstringYesdata type=string; maxLen=4000
Applies whenshow = true and type in (textIsContainedInItem)show = true and type in (textIsContainedInValue)show = true and type in (textIsNotContainedInValue)show = true and type in (text=value)show = true and type in (text!=value)
valuestringYesdata type=string; maxLen=4000
Applies whenshow = true and type in (item=value)show = true and type in (item!=value)show = true and type in (VALUE_OF_ITEM_IN_COND_1_EQ_COND_2)show = true and type in (VALUE_OF_ITEM_IN_COND_1_NOT_EQ_COND_2)
listarray of stringsYesdata type=string; maxLen=4000
Applies whenshow = true and type in (itemIsInColonDelimitedList)show = true and type in (itemIsNotInColonDelimitedList)
itemstringYesdata type=string; maxLen=4000; textCase=UPPER
Applies whenshow = true and type = textIsContainedInItem
valuestringYesdata type=string; maxLen=4000
Applies whenshow = true and type in (textIsContainedInValue)show = true and type in (textIsNotContainedInValue)show = true and type in (text=value)show = true and 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
Applies whenshow = true
escapeSpecialCharsbooleanYestruedata type=boolean
Applies whentype supports VALUE_ESCAPE_OUTPUT
security {
  authorizationScheme: mustNotBePublicUser
  escapeSpecialChars: false
}
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
    show: false
    source {
        dataType: value
    }
    heading {
        heading: value
        alignment: start
    }
    layout {
        sequence: 42
        columnAlignment: start
    }
    appearance {
        formatMask: value
        cssClasses: [
          value
          value
        ]
    }
    advanced {
        customAttributes: 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 {
        authorizationScheme: mustNotBePublicUser
        escapeSpecialChars: false
    }
    config {
        buildOption: @component
    }
    comments {
        comments: ```
          value
        ```
    }
)