region (dataUploadColMapping)

Parent: region

Applies whentype = dataUploadColMapping

Direct Properties:

PropertyTypeRequiredDefault ValueDetails
namestringYesdata type=string; maxLen=255
Enter a region name. The region name is required, it is used by Page Designer to identify the region on the tree view and the grid layout view. The region name is used as the runtime region title, if the title attribute is empty.
titlestringNodata type=string; maxLen=255
Enter a region title. The region title is optional, it only displays when it is defined in the region template.
typeenumYesdata type=string; lov=PLUGINS
Valid values: dataUploadColMapping

Property Groups:

  • chart
  • componentAppearance
  • edit
  • link
  • map
  • output
  • page
  • reportLayout
  • title
  • chartAppearance
  • card
  • source
  • controls
  • editAuthorization
  • pageHeader
  • chartLayout
  • initialPositionAndZoom
  • performance
  • pagination
  • gauge
  • columnHeadings
  • subtitle
  • messages
  • toolbar
  • body
  • breakFormatting
  • columns
  • dataCursor
  • enableUsersTo
  • boundingBox
  • multiSeriesChartData
  • secondaryBody
  • pageFooter
  • download
  • settings
  • iconAndBadge
  • componentAdvanced
  • singleRowView
  • heading
  • iconView
  • media
  • legend
  • overview
  • printing
  • externalProcessing
  • genAI
  • value
  • attributes
  • searchBar
  • orderBy
  • blobAttributes
  • detailView
  • actionsMenu
  • dataProfile
  • animation
  • restSynchronization
  • tooltip
  • externalFilterAndOrderBy
  • advanced
  • help
  • localPostProcessing
  • autoRefresh
  • remoteCache
  • layout
  • description
  • appearance
  • accessibility
  • image
  • masterDetail
  • headerAndFooter
  • serverSideCondition
  • readOnly
  • security
  • serverCache
  • customization
  • config
  • comments
  • rowSelection
  • entityTitle
chart
PropertyTypeRequiredDefault ValueDetails
typeenumYesbardata type=string; lov=STATIC
Valid values: area bar boxPlot bubble combination statusMeterGauge donut funnel gantt line lineWithArea pie polar pyramid radar range scatter stock
chart {
  type: area
}
componentAppearance
PropertyTypeRequiredDefault ValueDetails
displayenumYesdata type=string; lov=STATIC
Valid values: report partial regionOnly
layoutenumYesgriddata type=string; lov=STATIC
Valid values: grid float horizontal
gridColumnsenumNodata type=string; lov=STATIC
Valid values: 2 3 4 5
Applies whenlayout = grid
listTemplatereferenceYesdata type=reference; lov=COMPONENT; references=listTemplate
breadcrumbTemplatereferenceYesdata type=reference; lov=COMPONENT; references=breadcrumbTemplate
cssClassesarray of stringsNodata type=string; maxLen=255
Applies whentemplateType = theme
templateOptionsarray of stringsNodata type=string; lov=TEMPLATE_OPTIONS
Applies whenbreadcrumbTemplate is setlistTemplate is settemplateType = theme and template is set
templateTypeenumYesthemedata type=string; lov=STATIC
Valid values: theme predefined
templatereferenceYesdata type=reference; lov=COMPONENT; references=classicReportTemplate
Applies whentemplateType = theme
templateenumYeshtmldata type=string; lov=STATIC
Valid values: html verticalReport csv xml
Applies whentemplateType = predefined
customAttributesstringNodata type=string; maxLen=2000
The report template substitution string #REPORT_ATTRIBUTES# is replaced with this value. The #REPORT_ATTRIBUTES# substitution string is only replaced in the before rows attribute of the report template.
showNullValuesAsstringNodata type=string; maxLen=255
selectFirstRowbooleanYestruedata type=boolean
fixedRowHeightbooleanYestruedata type=boolean
componentAppearance {
  display: report
  layout: grid
  gridColumns: "2"
  listTemplate: @component
  breadcrumbTemplate: @component
  cssClasses: [
    value
    value
  ]
  templateOptions: [
    value
    value
  ]
  templateType: theme
  template: @component
  customAttributes: value
  showNullValuesAs: value
  selectFirstRow: false
  fixedRowHeight: false
}
edit
PropertyTypeRequiredDefault ValueDetails
enabledbooleanYesfalsedata type=boolean
allowedOperationsarray of enumsNodata type=string; lov=STATIC
Valid values: add update delete
Applies whenenabled = true
allowedRowOperationsColumnstringNodata type=string; maxLen=32767
Applies whenenabled = true and allowedOperations in (update)enabled = true and allowedOperations in (delete)
lostUpdateTypeenumYesrowValuesdata type=string; lov=STATIC
Valid values: rowValues rowVersionColumn
Applies whenenabled = true
rowVersionColumnstringYesdata type=string; maxLen=32767
Applies whenenabled = true and lostUpdateType = rowVersionColumn
addRowIfEmptybooleanYestruedata type=boolean
Applies whenenabled = true and allowedOperations = add
edit {
  enabled: false
  allowedOperations: [
    add
    update
  ]
  allowedRowOperationsColumn: value
  lostUpdateType: rowValues
  rowVersionColumn: value
  addRowIfEmpty: false
}
link
PropertyTypeRequiredDefault ValueDetails
linkColumnenumYesexcludedata type=string; lov=STATIC
Valid values: singleRowView customTarget exclude
uniquelyIdentifyRowsByenumYesrowiddata type=string; lov=STATIC
Valid values: rowid uniqueColumn
Applies whenlinkColumn = singleRowView
uniqueColumnstringYesdata type=string; maxLen=32767
Applies whenlinkColumn = singleRowView and uniquelyIdentifyRowsBy = uniqueColumn
targetcomplexYesdata type=complex; maxLen=32767
Applies whenlinkColumn = customTarget
linkIconmultiline stringNodata type=multiline string; maxLen=4000
Applies whenlinkColumn in (singleRowView)linkColumn in (customTarget)
linkAttributesstringNodata type=string; maxLen=4000
Applies whenlinkColumn in (singleRowView)linkColumn in (customTarget)
authorizationSchemeenumNodata type=reference; lov=COMPONENT; references=authorization
Valid values: mustNotBePublicUser
Applies whenlinkColumn in (singleRowView)linkColumn in (customTarget)
conditionTypeenumNodata 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 whenlinkColumn in (singleRowView)linkColumn in (customTarget)
sqlQuerymultiline stringYesdata type=multiline string; maxLen=4000
Applies whenlinkColumn in (singleRowView) and conditionType in (rowsReturned)linkColumn in (singleRowView) and conditionType in (noRowsReturned)linkColumn in (customTarget) and conditionType in (rowsReturned)linkColumn in (customTarget) and conditionType in (noRowsReturned)
languageenumYesplsqldata type=string; lov=STATIC
Valid values: sql plsql javaScript-mle
Applies whenlinkColumn in (singleRowView) and conditionType = expressionlinkColumn in (customTarget) and conditionType = expression
sqlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whenlinkColumn in (singleRowView) and conditionType = expression and language = sqllinkColumn in (customTarget) and conditionType = expression and language = sql
plsqlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whenlinkColumn in (singleRowView) and conditionType = expression and language = plsqllinkColumn in (customTarget) and conditionType = expression and language = plsql
javaScriptExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whenlinkColumn in (singleRowView) and conditionType = expression and language = javaScript-mlelinkColumn in (customTarget) and conditionType = expression and language = javaScript-mle
languageenumYesplsqldata type=string; lov=STATIC
Valid values: plsql javaScript-mle
Applies whenlinkColumn in (singleRowView) and conditionType = functionBodylinkColumn in (customTarget) and conditionType = functionBody
plsqlFunctionBodymultiline stringYesdata type=multiline string; maxLen=4000
Applies whenlinkColumn in (singleRowView) and conditionType = functionBody and language = plsqllinkColumn in (customTarget) and conditionType = functionBody and language = plsql
javaScriptFunctionBodymultiline stringYesdata type=multiline string; maxLen=4000
Applies whenlinkColumn in (singleRowView) and conditionType = functionBody and language = javaScript-mlelinkColumn in (customTarget) and conditionType = functionBody and language = javaScript-mle
valuestringYesdata type=string; maxLen=4000
Applies whenlinkColumn in (singleRowView) and conditionType in (request=Value)linkColumn in (singleRowView) and conditionType in (request!=Value)linkColumn in (singleRowView) and conditionType in (requestIsContainedInValue)linkColumn in (singleRowView) and conditionType in (requestIsNotContainedInValue)linkColumn in (singleRowView) and conditionType in (currentLanguageIsContainedInValue)linkColumn in (singleRowView) and conditionType in (currentLanguageIsNotContainedInValue)linkColumn in (singleRowView) and conditionType in (currentLanguage!=value)linkColumn in (singleRowView) and conditionType in (currentLanguage=value)linkColumn in (singleRowView) and conditionType in (cgiEnvDadName=value)linkColumn in (singleRowView) and conditionType in (cgiEnvDadName!=value)linkColumn in (singleRowView) and conditionType in (cgiEnvServerName=value)linkColumn in (singleRowView) and conditionType in (cgiEnvServerName!=value)linkColumn in (singleRowView) and conditionType in (cgiEnvHttpHost=value)linkColumn in (singleRowView) and conditionType in (cgiEnvHttpHost!=value)linkColumn in (customTarget) and conditionType in (request=Value)linkColumn in (customTarget) and conditionType in (request!=Value)linkColumn in (customTarget) and conditionType in (requestIsContainedInValue)linkColumn in (customTarget) and conditionType in (requestIsNotContainedInValue)linkColumn in (customTarget) and conditionType in (currentLanguageIsContainedInValue)linkColumn in (customTarget) and conditionType in (currentLanguageIsNotContainedInValue)linkColumn in (customTarget) and conditionType in (currentLanguage!=value)linkColumn in (customTarget) and conditionType in (currentLanguage=value)linkColumn in (customTarget) and conditionType in (cgiEnvDadName=value)linkColumn in (customTarget) and conditionType in (cgiEnvDadName!=value)linkColumn in (customTarget) and conditionType in (cgiEnvServerName=value)linkColumn in (customTarget) and conditionType in (cgiEnvServerName!=value)linkColumn in (customTarget) and conditionType in (cgiEnvHttpHost=value)linkColumn in (customTarget) and conditionType in (cgiEnvHttpHost!=value)
itemstringYesdata type=string; maxLen=4000; textCase=UPPER
Applies whenlinkColumn in (singleRowView) and conditionType in (item=value)linkColumn in (singleRowView) and conditionType in (item!=value)linkColumn in (singleRowView) and conditionType in (VALUE_OF_ITEM_IN_COND_1_EQ_COND_2)linkColumn in (singleRowView) and conditionType in (VALUE_OF_ITEM_IN_COND_1_NOT_EQ_COND_2)linkColumn in (singleRowView) and conditionType in (itemIsNull)linkColumn in (singleRowView) and conditionType in (itemIsNotNull)linkColumn in (singleRowView) and conditionType in (itemIsZero)linkColumn in (singleRowView) and conditionType in (itemIsNotZero)linkColumn in (singleRowView) and conditionType in (itemIsNullOrZero)linkColumn in (singleRowView) and conditionType in (itemIsNotNullAndNotZero)linkColumn in (singleRowView) and conditionType in (itemContainsNoSpaces)linkColumn in (singleRowView) and conditionType in (itemIsNumeric)linkColumn in (singleRowView) and conditionType in (itemIsNotNumeric)linkColumn in (singleRowView) and conditionType in (itemIsAlphanumeric)linkColumn in (singleRowView) and conditionType in (itemIsInColonDelimitedList)linkColumn in (singleRowView) and conditionType in (itemIsNotInColonDelimitedList)linkColumn in (customTarget) and conditionType in (item=value)linkColumn in (customTarget) and conditionType in (item!=value)linkColumn in (customTarget) and conditionType in (VALUE_OF_ITEM_IN_COND_1_EQ_COND_2)linkColumn in (customTarget) and conditionType in (VALUE_OF_ITEM_IN_COND_1_NOT_EQ_COND_2)linkColumn in (customTarget) and conditionType in (itemIsNull)linkColumn in (customTarget) and conditionType in (itemIsNotNull)linkColumn in (customTarget) and conditionType in (itemIsZero)linkColumn in (customTarget) and conditionType in (itemIsNotZero)linkColumn in (customTarget) and conditionType in (itemIsNullOrZero)linkColumn in (customTarget) and conditionType in (itemIsNotNullAndNotZero)linkColumn in (customTarget) and conditionType in (itemContainsNoSpaces)linkColumn in (customTarget) and conditionType in (itemIsNumeric)linkColumn in (customTarget) and conditionType in (itemIsNotNumeric)linkColumn in (customTarget) and conditionType in (itemIsAlphanumeric)linkColumn in (customTarget) and conditionType in (itemIsInColonDelimitedList)linkColumn in (customTarget) and conditionType in (itemIsNotInColonDelimitedList)
preferencestringYesdata type=string; maxLen=4000; textCase=UPPER
Applies whenlinkColumn in (singleRowView) and conditionType in (userPreference=value)linkColumn in (singleRowView) and conditionType in (userPreference!=value)linkColumn in (customTarget) and conditionType in (userPreference=value)linkColumn in (customTarget) and conditionType in (userPreference!=value)
pageintegerYesdata type=integer; maxLen=4000
Applies whenlinkColumn in (singleRowView) and conditionType in (currentPage=page)linkColumn in (singleRowView) and conditionType in (currentPage!=page)linkColumn in (customTarget) and conditionType in (currentPage=page)linkColumn in (customTarget) and conditionType in (currentPage!=page)
pagesarray of integersYesdata type=integer; maxLen=4000
Applies whenlinkColumn in (singleRowView) and conditionType in (currentPageInList)linkColumn in (singleRowView) and conditionType in (currentPageNotInList)linkColumn in (customTarget) and conditionType in (currentPageInList)linkColumn in (customTarget) and conditionType in (currentPageNotInList)
textstringYesdata type=string; maxLen=4000
Applies whenlinkColumn in (singleRowView) and conditionType in (textIsContainedInItem)linkColumn in (singleRowView) and conditionType in (textIsContainedInValue)linkColumn in (singleRowView) and conditionType in (textIsNotContainedInValue)linkColumn in (singleRowView) and conditionType in (text=value)linkColumn in (singleRowView) and conditionType in (text!=value)linkColumn in (customTarget) and conditionType in (textIsContainedInItem)linkColumn in (customTarget) and conditionType in (textIsContainedInValue)linkColumn in (customTarget) and conditionType in (textIsNotContainedInValue)linkColumn in (customTarget) and conditionType in (text=value)linkColumn in (customTarget) and conditionType in (text!=value)
valuestringYesdata type=string; maxLen=4000
Applies whenlinkColumn in (singleRowView) and conditionType in (item=value)linkColumn in (singleRowView) and conditionType in (item!=value)linkColumn in (singleRowView) and conditionType in (VALUE_OF_ITEM_IN_COND_1_EQ_COND_2)linkColumn in (singleRowView) and conditionType in (VALUE_OF_ITEM_IN_COND_1_NOT_EQ_COND_2)linkColumn in (singleRowView) and conditionType in (userPreference=value)linkColumn in (singleRowView) and conditionType in (userPreference!=value)linkColumn in (customTarget) and conditionType in (item=value)linkColumn in (customTarget) and conditionType in (item!=value)linkColumn in (customTarget) and conditionType in (VALUE_OF_ITEM_IN_COND_1_EQ_COND_2)linkColumn in (customTarget) and conditionType in (VALUE_OF_ITEM_IN_COND_1_NOT_EQ_COND_2)linkColumn in (customTarget) and conditionType in (userPreference=value)linkColumn in (customTarget) and conditionType in (userPreference!=value)
listarray of stringsYesdata type=string; maxLen=4000
Applies whenlinkColumn in (singleRowView) and conditionType in (itemIsInColonDelimitedList)linkColumn in (singleRowView) and conditionType in (itemIsNotInColonDelimitedList)linkColumn in (customTarget) and conditionType in (itemIsInColonDelimitedList)linkColumn in (customTarget) and conditionType in (itemIsNotInColonDelimitedList)
itemstringYesdata type=string; maxLen=4000; textCase=UPPER
Applies whenlinkColumn in (singleRowView) and conditionType = textIsContainedInItemlinkColumn in (customTarget) and conditionType = textIsContainedInItem
valuestringYesdata type=string; maxLen=4000
Applies whenlinkColumn in (singleRowView) and conditionType in (textIsContainedInValue)linkColumn in (singleRowView) and conditionType in (textIsNotContainedInValue)linkColumn in (singleRowView) and conditionType in (text=value)linkColumn in (singleRowView) and conditionType in (text!=value)linkColumn in (customTarget) and conditionType in (textIsContainedInValue)linkColumn in (customTarget) and conditionType in (textIsNotContainedInValue)linkColumn in (customTarget) and conditionType in (text=value)linkColumn in (customTarget) and conditionType in (text!=value)
link {
  linkColumn: singleRowView
  uniquelyIdentifyRowsBy: rowid
  uniqueColumn: value
  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
  }
  linkIcon: ```
    value
  ```
  linkAttributes: value
  authorizationScheme: mustNotBePublicUser
  conditionType: 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
  ]
}
map
PropertyTypeRequiredDefault ValueDetails
backgroundenumYesdefaultdata type=string; lov=STATIC
Valid values: default builtIn sharedComponent
standardenumYesopenstreetmapPositrondata type=string; lov=STATIC
Valid values: openstreetmapPositron openstreetmapDark openstreetmapBright oracleWorldMap oracleBiWorldMap
Applies whenbackground = builtIn
darkModeenumNodata type=string; lov=STATIC
Valid values: openstreetmapDark openstreetmapPositron openstreetmapBright oracleWorldMap oracleBiWorldMap
Applies whenbackground = builtIn
standardreferenceYesdata type=reference; lov=COMPONENT; references=mapBackground
Applies whenbackground = sharedComponent
darkModereferenceNodata type=reference; lov=COMPONENT; references=mapBackground
Applies whenbackground = sharedComponent
heightnumberYes640data type=number; maxLen=22
map {
  background: default
  standard: openstreetmapPositron
  darkMode: openstreetmapDark
  height: 42
}
output
PropertyTypeRequiredDefault ValueDetails
layoutreferenceNodata type=reference; lov=COMPONENT; references=reportLayout
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = true
linkTextstringNodata type=string; maxLen=255
Applies whenenabled = true
formatenumNodata type=string; lov=STATIC
Valid values: pdf word excel html xml
Applies whenenabled = true
viewFileAsenumYesattachmentdata type=string; lov=STATIC
Valid values: attachment inline
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = true
formatItemstringYesdata type=string; maxLen=255; textCase=UPPER
Applies whenenabled = true
fileNamestringNodata type=string; maxLen=255
Applies whenenabled = true
output {
  layout: @component
  linkText: value
  format: pdf
  viewFileAs: attachment
  formatItem: value
  fileName: value
}
page
PropertyTypeRequiredDefault ValueDetails
sizeenumYesletterdata type=string; lov=STATIC
Valid values: letter legal tabloid a4 a3 custom
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
orientationenumYeslandscapedata type=string; lov=STATIC
Valid values: portrait landscape
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
unitsenumYesinchesdata type=string; lov=STATIC
Valid values: inches millimeters centimeters points
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
widthnumberYes11data type=number; maxLen=22
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
heightnumberYes8.5data type=number; maxLen=22
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
borderWidthnumberNodata type=number; maxLen=255
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
borderColorstringNodata type=string; maxLen=255
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
page {
  size: letter
  orientation: portrait
  units: inches
  width: 42
  height: 42
  borderWidth: 42
  borderColor: value
}
reportLayout
PropertyTypeRequiredDefault ValueDetails
numberOfRowsTypeenumYesstaticValuedata type=string; lov=STATIC
Valid values: staticValue itemValue
numberOfRowsintegerYes15data type=integer; maxLen=32767
Applies whennumberOfRowsType = staticValue
itemstringYesdata type=string; maxLen=255; textCase=UPPER
Applies whennumberOfRowsType = itemValue
reportLayout {
  numberOfRowsType: staticValue
  numberOfRows: 42
  item: value
}
title
PropertyTypeRequiredDefault ValueDetails
titlestringNodata type=string; maxLen=255
advancedFormattingbooleanYesfalsedata type=boolean
columnstringNodata type=string; maxLen=32767
Applies whenadvancedFormatting = false
htmlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whenadvancedFormatting = true
cssClassesarray of stringsNodata type=string; maxLen=255
Applies whenadvancedFormatting = false
title {
  title: value
  advancedFormatting: false
  column: value
  htmlExpression: ```html
    value
  ```
  cssClasses: [
    value
    value
  ]
}
chartAppearance
PropertyTypeRequiredDefault ValueDetails
orientationenumYesverticaldata type=string; lov=STATIC
Valid values: vertical horizontal
Applies whentype in (area)type in (bar)type in (combination)type in (funnel)type in (line)type in (lineWithArea)type in (boxPlot)type in (range)
stackbooleanYesoffdata type=boolean
Applies whentype in (area)type in (bar)type in (line)type in (lineWithArea)type in (combination)type in (polar)type in (radar)
stackLabelbooleanYesoffdata type=boolean
Applies whentype = bar and type in (area) and stack = ontype = bar and type in (bar) and stack = ontype = bar and type in (line) and stack = ontype = bar and type in (lineWithArea) and stack = ontype = bar and type in (combination) and stack = ontype = bar and type in (polar) and stack = ontype = bar and type in (radar) and stack = on
fontFamilyenumNodata type=string; lov=STATIC
Valid values: arial arialBlack bookman comicSansMs courier courierNew garamond georgia helvetica impact palatino times timesNewRoman trebuchetMs verdana
Applies whentype = bar and type in (area) and stack = on and stackLabel = ontype = bar and type in (bar) and stack = on and stackLabel = ontype = bar and type in (line) and stack = on and stackLabel = ontype = bar and type in (lineWithArea) and stack = on and stackLabel = ontype = bar and type in (combination) and stack = on and stackLabel = ontype = bar and type in (polar) and stack = on and stackLabel = ontype = bar and type in (radar) and stack = on and stackLabel = on
fontStyleenumNodata type=string; lov=STATIC
Valid values: normal italic oblique
Applies whentype = bar and type in (area) and stack = on and stackLabel = ontype = bar and type in (bar) and stack = on and stackLabel = ontype = bar and type in (line) and stack = on and stackLabel = ontype = bar and type in (lineWithArea) and stack = on and stackLabel = ontype = bar and type in (combination) and stack = on and stackLabel = ontype = bar and type in (polar) and stack = on and stackLabel = ontype = bar and type in (radar) and stack = on and stackLabel = on
fontSizeenumNodata type=string; lov=STATIC
Valid values: 8 10 12 14 16 18 20 22
Applies whentype = bar and type in (area) and stack = on and stackLabel = ontype = bar and type in (bar) and stack = on and stackLabel = ontype = bar and type in (line) and stack = on and stackLabel = ontype = bar and type in (lineWithArea) and stack = on and stackLabel = ontype = bar and type in (combination) and stack = on and stackLabel = ontype = bar and type in (polar) and stack = on and stackLabel = ontype = bar and type in (radar) and stack = on and stackLabel = on
fontColorstringNodata type=string; maxLen=255
Applies whentype = bar and type in (area) and stack = on and stackLabel = ontype = bar and type in (bar) and stack = on and stackLabel = ontype = bar and type in (line) and stack = on and stackLabel = ontype = bar and type in (lineWithArea) and stack = on and stackLabel = ontype = bar and type in (combination) and stack = on and stackLabel = ontype = bar and type in (polar) and stack = on and stackLabel = ontype = bar and type in (radar) and stack = on and stackLabel = on
chartAppearance {
  orientation: vertical
  stack: false
  stackLabel: false
  fontFamily: arial
  fontStyle: normal
  fontSize: "8"
  fontColor: value
}
card
PropertyTypeRequiredDefault ValueDetails
cssClassesarray of stringsNodata type=string; maxLen=255
primaryKeyColumn1stringNodata type=string; maxLen=32767
primaryKeyColumn2stringNodata type=string; maxLen=32767
Applies whenprimaryKeyColumn1 is set
card {
  cssClasses: [
    value
    value
  ]
  primaryKeyColumn1: value
  primaryKeyColumn2: value
}
source
PropertyTypeRequiredDefault ValueDetails
sqlQuerymultiline stringNodata type=multiline string; maxLen=32767
plsqlCodemultiline stringNodata type=multiline string; maxLen=32767
Enter the PL/SQL code to generate the HTML output.
plsqlFunctionBodymultiline stringNodata type=multiline string; maxLen=32767
htmlCodemultiline stringNodata type=multiline string; maxLen=32767
textmultiline stringNodata type=multiline string; maxLen=32767
languageenumYesplsqldata type=string; lov=STATIC
Valid values: plsql javaScript-mle
plsqlFunctionBodymultiline stringYesdata type=multiline string; maxLen=32767
Applies whenlanguage = plsql
javaScriptFunctionBodymultiline stringYesdata type=multiline string; maxLen=32767
Applies whenlanguage = javaScript-mle
locationenumNolocalDatabasedata type=string; lov=STATIC
Valid values: localDatabase restEnabledSql restSource jsonDualityView jsonSource sampleData
remoteServerreferenceYesdata type=reference; lov=COMPONENT; references=restEnabledSqlDatabase
Applies whenlocation = restEnabledSql
sampleDataenumYesdata type=string; lov=STATIC
Valid values: employees tasks products projects
Applies whenlocation = sampleData
typeenumYestableViewdata type=string; lov=STATIC
Valid values: tableView sqlQuery functionBody propertyGraph
Applies whenlocation in (localDatabase)location in (restEnabledSql)
tableOwnerstringNodata type=string; maxLen=32767
Applies whenlocation in (localDatabase) and type = tableViewlocation in (restEnabledSql) and type = tableView
tableNamestringYesdata type=string; maxLen=128
Applies whenlocation in (localDatabase) and type = tableViewlocation in (restEnabledSql) and type = tableView
includeRowidColumnbooleanYesfalsedata type=boolean
Applies whenlocation in (localDatabase) and type = tableView and location = restEnabledSql and remoteServer supports IS_ORACLElocation in (restEnabledSql) and type = tableView and location = restEnabledSql and remoteServer supports IS_ORACLE
whereClausemultiline stringNodata type=multiline string; maxLen=4000
Applies whenlocation in (localDatabase) and type = tableViewlocation in (restEnabledSql) and type = tableView
graphOwnerstringNodata type=string; maxLen=32767
Applies whenlocation in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type = propertyGraph
graphNamestringYesdata type=string; maxLen=32767
Applies whenlocation in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type = propertyGraph
matchClausemultiline stringYesdata type=multiline string; maxLen=4000
Applies whenlocation in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type = propertyGraph
columnsClausemultiline stringYesdata type=multiline string; maxLen=4000
Applies whenlocation in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type = propertyGraph
whereClausemultiline stringNodata type=multiline string; maxLen=4000
Applies whenlocation in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type = propertyGraph
orderByClausemultiline stringNodata type=multiline string; maxLen=255
Applies whenlocation in (localDatabase) and type = tableViewlocation in (restEnabledSql) and type = tableView
orderByClausemultiline stringNodata type=multiline string; maxLen=255
Applies whenlocation in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type = propertyGraph
sqlQuerymultiline stringYesdata type=multiline string; maxLen=32767
Applies whenlocation in (localDatabase) and type = sqlQuerylocation in (restEnabledSql) and type = sqlQuery
languageenumYesplsqldata type=string; lov=STATIC
Valid values: plsql javaScript-mle
Applies whenlocation in (localDatabase) and type = functionBodylocation in (restEnabledSql) and type = functionBody
plsqlFunctionBodymultiline stringYesdata type=multiline string; maxLen=32767
Applies whenlocation in (localDatabase) and type = functionBody and language = plsqllocation in (restEnabledSql) and type = functionBody and language = plsql
javaScriptFunctionBodymultiline stringYesdata type=multiline string; maxLen=32767
Applies whenlocation in (localDatabase) and type = functionBody and language = javaScript-mlelocation in (restEnabledSql) and type = functionBody and language = javaScript-mle
restSourcereferenceYesdata type=reference; lov=COMPONENT; references=restDataSource
Applies whenlocation = restSource
jsonDualityViewreferenceYesdata type=reference; lov=COMPONENT; references=jsonDualityView
Applies whenlocation = jsonDualityView
jsonSourcereferenceYesdata type=reference; lov=COMPONENT; references=jsonSource
Applies whenlocation = jsonSource
listreferenceYesdata type=reference; lov=COMPONENT; references=list
breadcrumbreferenceYesdata type=reference; lov=COMPONENT; references=breadcrumb
filteredRegionreferenceYesdata type=reference; lov=COMPONENT; references=region
pageItemsToSubmitarray of stringsNodata type=string; maxLen=4000; textCase=UPPER
optimizerHintstringNodata type=string; maxLen=255
Applies whenlocation in (localDatabase)location in (restEnabledSql)location in (restSource)location in (jsonDualityView)location in (jsonSource)
useGenericColumnNamesbooleanYesDERIVED_REPORT_COLUMNSdata type=boolean
Applies whenlocation in (localDatabase) and type = functionBodylocation in (restEnabledSql) and type = functionBody
genericColumnCountintegerYesdata type=integer; maxLen=3
Applies whenlocation in (localDatabase) and type = functionBody and useGenericColumnNames = GENERIC_REPORT_COLUMNSlocation in (restEnabledSql) and type = functionBody and useGenericColumnNames = GENERIC_REPORT_COLUMNS
source {
  plsqlCode: ```plsql
    value
  ```
  htmlCode: ```html
    value
  ```
  text: ```
    value
  ```
  language: plsql
  plsqlFunctionBody: ```plsql
    value
  ```
  javaScriptFunctionBody: ```javascript-mle
    value
  ```
  location: localDatabase
  remoteServer: @component
  sampleData: employees
  type: tableView
  tableOwner: value
  tableName: value
  includeRowidColumn: false
  whereClause: ```sql
    value
  ```
  graphOwner: value
  graphName: value
  matchClause: ```
    value
  ```
  columnsClause: ```
    value
  ```
  orderByClause: ```sql
    value
  ```
  sqlQuery: ```sql
    value
  ```
  restSource: @component
  jsonDualityView: @component
  jsonSource: @component
  list: @component
  breadcrumb: @component
  filteredRegion: @component
  pageItemsToSubmit: [
    value
    value
  ]
  optimizerHint: value
  useGenericColumnNames: false
  genericColumnCount: 42
}
controls
PropertyTypeRequiredDefault ValueDetails
navigationBarenumYeszoomAndCompassdata type=string; lov=STATIC
Valid values: none zoomOnly zoomAndCompass
navigationBarPositionenumYesenddata type=string; lov=STATIC
Valid values: start end
optionsarray of enumsNodata type=string; lov=STATIC
Valid values: mousewheelZoom rectangleZoom scaleBar overviewMap infiniteMap getBrowserLocation circleTool distanceTool
controls {
  navigationBar: none
  navigationBarPosition: start
  options: [
    mousewheelZoom
    rectangleZoom
  ]
}
editAuthorization
PropertyTypeRequiredDefault ValueDetails
addenumNodata type=reference; lov=COMPONENT; references=authorization
Valid values: mustNotBePublicUser
Applies whenenabled = true and allowedOperations = add
updateenumNodata type=reference; lov=COMPONENT; references=authorization
Valid values: mustNotBePublicUser
Applies whenenabled = true and allowedOperations = update
deleteenumNodata type=reference; lov=COMPONENT; references=authorization
Valid values: mustNotBePublicUser
Applies whenenabled = true and allowedOperations = delete
editAuthorization {
  add: mustNotBePublicUser
  update: mustNotBePublicUser
  delete: mustNotBePublicUser
}
pageHeader
PropertyTypeRequiredDefault ValueDetails
fontenumYeshelveticadata type=string; lov=STATIC
Valid values: helvetica times courier
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
fontWeightenumYesnormaldata type=string; lov=STATIC
Valid values: normal bold
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
fontSizeintegerYes12data type=integer; maxLen=32767
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
fontColorstringYes#000000data type=string; maxLen=255
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
alignmentenumYescenterdata type=string; lov=STATIC
Valid values: start center end
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
pageHeaderTextmultiline stringNodata type=multiline string; maxLen=4000
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
pageHeader {
  font: helvetica
  fontWeight: normal
  fontSize: 42
  fontColor: value
  alignment: start
  pageHeaderText: ```
    value
  ```
}
chartLayout
PropertyTypeRequiredDefault ValueDetails
maxWidthintegerNodata type=integer; maxLen=32767
heightintegerNodata type=integer; maxLen=32767
chartLayout {
  maxWidth: 42
  height: 42
}
initialPositionAndZoom
PropertyTypeRequiredDefault ValueDetails
getPositionFromBrowserbooleanYesfalsedata type=boolean
Applies whenoptions = getBrowserLocation
typeenumYesbasedOnSpatialResultsdata type=string; lov=STATIC
Valid values: staticValues sqlQuery basedOnSpatialResults
sqlQuerymultiline stringYesdata type=multiline string; maxLen=32767
Applies whentype = sqlQuery
geometryColumnDataTypeenumYesdata type=string; lov=STATIC
Valid values: sdoGeometry geojson longitudeLatitude
Applies whentype = sqlQuery
initialLongitudeColumnstringYesdata type=string; maxLen=32767
Applies whentype = sqlQuery and geometryColumnDataType = longitudeLatitude
initialLatitudeColumnstringYesdata type=string; maxLen=32767
Applies whentype = sqlQuery and geometryColumnDataType = longitudeLatitude
geometryColumnstringYesdata type=string; maxLen=32767
Applies whentype = sqlQuery and geometryColumnDataType = sdoGeometry
geojsonColumnstringYesdata type=string; maxLen=32767
Applies whentype = sqlQuery and geometryColumnDataType = geojson
initialZoomlevelColumnstringNodata type=string; maxLen=32767
Applies whentype = sqlQuery
longitudestringYesdata type=string; maxLen=32767
Applies whentype = staticValues
latitudestringYesdata type=string; maxLen=32767
Applies whentype = staticValues
zoomLevelstringNodata type=string; maxLen=32767
Applies whentype in (staticValues)type in (basedOnSpatialResults)
initialPositionAndZoom {
  getPositionFromBrowser: false
  type: staticValues
  sqlQuery: ```sql
    value
  ```
  geometryColumnDataType: sdoGeometry
  initialLongitudeColumn: value
  initialLatitudeColumn: value
  geometryColumn: value
  geojsonColumn: value
  initialZoomlevelColumn: value
  longitude: value
  latitude: value
  zoomLevel: value
}
performance
PropertyTypeRequiredDefault ValueDetails
lazyLoadingbooleanYesfalsedata type=boolean
Applies whenpartialPageRefresh = truelocation is set
maxRowsToProcessintegerNodata type=integer; maxLen=32767
lazyLoadingbooleanYesfalsedata type=boolean
performance {
  lazyLoading: false
  maxRowsToProcess: 42
}
pagination
PropertyTypeRequiredDefault ValueDetails
typeenumYesnextAndPreviousLinksdata type=string; lov=STATIC
Valid values: showAll rowRangesXToYNoPagination rowRangesXToYOfZNoPagination rowRangesXToYOfZWithPagination setPaginationLinks setPaginationSelectList setPaginationSearchEngine externalPaginationButtons nextAndPreviousLinks
displayPositionenumYesbottomRightdata type=string; lov=STATIC
Valid values: bottomLeft bottomRight topLeft topRight topAndBottomLeft topAndBottomRight
Applies whentype is set
partialPageRefreshbooleanYestruedata type=boolean
typeenumYesscrolldata type=string; lov=STATIC
Valid values: page scroll
Applies whendisplay = report
showTotalCountbooleanYestruedata type=boolean
Applies whendisplay = report
typeenumNodata type=string; lov=STATIC
Valid values: rowRangesXToYOfZ rowRangesXToY
maxRowsToDisplaystringNodata type=string; maxLen=32767
cardsPerPageintegerYes15data type=integer; maxLen=32767
Applies whentype = page
entitiesPerPageintegerYes15data type=integer; maxLen=32767
Applies whendisplay = report and type = page
initialEntitiesCountintegerNodata type=integer; maxLen=32767
Applies whendisplay = report and type = scroll
pagination {
  type: showAll
  displayPosition: bottomLeft
  partialPageRefresh: false
  showTotalCount: false
  maxRowsToDisplay: value
  cardsPerPage: 42
  entitiesPerPage: 42
  initialEntitiesCount: 42
}
gauge
PropertyTypeRequiredDefault ValueDetails
orientationenumYescirculardata type=string; lov=STATIC
Valid values: circular horizontal vertical
Applies whentype = statusMeterGauge
showPlotAreabooleanYesondata type=boolean
Applies whentype = statusMeterGauge
indicatorSizenumberYes1data type=number; maxLen=22
Applies whentype = statusMeterGauge
innerRadiusnumberYes0.7data type=number; maxLen=22
Applies whentype = statusMeterGauge and orientation = circular
startAnglenumberYes90data type=number; maxLen=22
Applies whentype = statusMeterGauge and orientation = circular
angleExtentnumberYes360data type=number; maxLen=22
Applies whentype = statusMeterGauge and orientation = circular
gauge {
  orientation: circular
  showPlotArea: false
  indicatorSize: 42
  innerRadius: 42
  startAngle: 42
  angleExtent: 42
}
columnHeadings
PropertyTypeRequiredDefault ValueDetails
fontenumYeshelveticadata type=string; lov=STATIC
Valid values: helvetica times courier
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
fontWeightenumYesbolddata type=string; lov=STATIC
Valid values: normal bold
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
fontSizeintegerYes10data type=integer; maxLen=32767
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
fontColorstringYes#000000data type=string; maxLen=255
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
backgroundColorstringYes#EEEEEEdata type=string; maxLen=255
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
columnHeadings {
  font: helvetica
  fontWeight: normal
  fontSize: 42
  fontColor: value
  backgroundColor: value
}
subtitle
PropertyTypeRequiredDefault ValueDetails
advancedFormattingbooleanYesfalsedata type=boolean
columnstringNodata type=string; maxLen=32767
Applies whenadvancedFormatting = false
htmlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whenadvancedFormatting = true
cssClassesarray of stringsNodata type=string; maxLen=255
Applies whenadvancedFormatting = false
subtitle {
  advancedFormatting: false
  column: value
  htmlExpression: ```html
    value
  ```
  cssClasses: [
    value
    value
  ]
}
messages
PropertyTypeRequiredDefault ValueDetails
whenNoDataFoundmultiline stringNodata type=multiline string; maxLen=4000
Applies whendisplay = report
whenMoreDataFoundmultiline stringNodata type=multiline string; maxLen=4000
noDataFoundIconstringNodata type=string; maxLen=4000
Applies whenwhenNoDataFound is setdisplay = report and whenNoDataFound is set
messages {
  whenNoDataFound: ```
    value
  ```
  whenMoreDataFound: ```
    value
  ```
  noDataFoundIcon: value
}
toolbar
PropertyTypeRequiredDefault ValueDetails
showbooleanYestruedata type=boolean
controlsarray of enumsNodata type=string; lov=STATIC
Valid values: searchCol searchField actionsMenu resetButton saveButton
Applies whenshow = true
addButtonLabelstringNodata type=string; maxLen=255
Applies whenshow = true and enabled = true and allowedOperations = add
toolbar {
  show: false
  controls: [
    searchCol
    searchField
  ]
  addButtonLabel: value
}
body
PropertyTypeRequiredDefault ValueDetails
advancedFormattingbooleanYesfalsedata type=boolean
columnstringNodata type=string; maxLen=32767
Applies whenadvancedFormatting = false
htmlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whenadvancedFormatting = true
cssClassesarray of stringsNodata type=string; maxLen=255
Applies whenadvancedFormatting = false
body {
  advancedFormatting: false
  column: value
  htmlExpression: ```html
    value
  ```
  cssClasses: [
    value
    value
  ]
}
breakFormatting
PropertyTypeRequiredDefault ValueDetails
reportSumLabelstringNodata type=string; maxLen=255
breakColumnsenumNodata type=string; lov=STATIC
Valid values: col1 cols1-2 cols1-3
styleenumYesdefaultdata type=string; lov=STATIC
Valid values: repeatHeadings default
Applies whenbreakColumns is set
repeatHeadingFormatmultiline stringNodata type=multiline string; maxLen=4000
Applies whenbreakColumns is set and style = repeatHeadings
reportBreakFormatstringNodata type=string; maxLen=2000
Applies whenbreakColumns is set
beforeRowstringNodata type=string; maxLen=2000
Applies whenbreakColumns is set
columnBreakFormatstringNodata type=string; maxLen=2000
Applies whenbreakColumns is set
afterRowstringNodata type=string; maxLen=2000
Applies whenbreakColumns is set
breakFormatting {
  reportSumLabel: value
  breakColumns: col1
  style: repeatHeadings
  repeatHeadingFormat: ```
    value
  ```
  reportBreakFormat: value
  beforeRow: value
  columnBreakFormat: value
  afterRow: value
}
columns
PropertyTypeRequiredDefault ValueDetails
fontenumYeshelveticadata type=string; lov=STATIC
Valid values: helvetica times courier
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
fontWeightenumYesnormaldata type=string; lov=STATIC
Valid values: normal bold
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
fontSizeintegerYes10data type=integer; maxLen=32767
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
fontColorstringYes#000000data type=string; maxLen=255
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
backgroundColorstringYes#FFFFFFdata type=string; maxLen=255
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
widthUnitsenumYespercentdata type=string; lov=STATIC
Valid values: percent point
Applies whenenabled = true
columns {
  font: helvetica
  fontWeight: normal
  fontSize: 42
  fontColor: value
  backgroundColor: value
  widthUnits: percent
}
dataCursor
PropertyTypeRequiredDefault ValueDetails
cursorenumYesautodata type=string; lov=STATIC
Valid values: auto true false
behaviorenumYesautodata type=string; lov=STATIC
Valid values: auto smooth snap
Applies whencursor in (auto)cursor in (true)
dimOnHoverbooleanYesdimdata type=boolean
dataCursor {
  cursor: auto
  behavior: auto
  dimOnHover: false
}
enableUsersTo
PropertyTypeRequiredDefault ValueDetails
savePublicReportbooleanYesfalsedata type=boolean
savePublicReportAuthorizationenumNodata type=reference; lov=COMPONENT; references=authorization
Valid values: mustNotBePublicUser
Applies whensavePublicReport = true
flashbackbooleanYestruedata type=boolean
defineChartViewbooleanYestruedata type=boolean
downloadbooleanYestruedata type=boolean
enableUsersTo {
  savePublicReport: false
  savePublicReportAuthorization: mustNotBePublicUser
  flashback: false
  defineChartView: false
  download: false
}
boundingBox
PropertyTypeRequiredDefault ValueDetails
typeenumNodata type=string; lov=STATIC
Valid values: staticValues sqlQuery
sqlQuerymultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = sqlQuery
geometryColumnDataTypeenumYessdoGeometrydata type=string; lov=STATIC
Valid values: sdoGeometry longitudeLatitude
Applies whentype = sqlQuery
minLongitudestringYesdata type=string; maxLen=32767
Applies whentype = sqlQuery and geometryColumnDataType = longitudeLatitude
minLatitudestringYesdata type=string; maxLen=32767
Applies whentype = sqlQuery and geometryColumnDataType = longitudeLatitude
maxLongitudestringYesdata type=string; maxLen=32767
Applies whentype = sqlQuery and geometryColumnDataType = longitudeLatitude
maxLatitudestringYesdata type=string; maxLen=32767
Applies whentype = sqlQuery and geometryColumnDataType = longitudeLatitude
geometryColumnstringYesdata type=string; maxLen=32767
Applies whentype = sqlQuery and geometryColumnDataType = sdoGeometry
minLongitudestringYesdata type=string; maxLen=128
Applies whentype = staticValues
minLatitudestringYesdata type=string; maxLen=128
Applies whentype = staticValues
maxLongitudestringYesdata type=string; maxLen=128
Applies whentype = staticValues
maxLatitudestringYesdata type=string; maxLen=128
Applies whentype = staticValues
currentBoundsItemstringNodata type=string; maxLen=32767; textCase=UPPER
boundingBox {
  type: staticValues
  sqlQuery: ```sql
    value
  ```
  geometryColumnDataType: sdoGeometry
  minLongitude: value
  minLatitude: value
  maxLongitude: value
  maxLatitude: value
  geometryColumn: value
  currentBoundsItem: value
}
multiSeriesChartData
PropertyTypeRequiredDefault ValueDetails
fillGapsInChartDatabooleanYestruedata type=boolean
sortOrderenumYeslabelAscdata type=string; lov=STATIC
Valid values: valueAsc valueDesc labelAsc labelDesc
Applies whenfillGapsInChartData = true
renderGapAsZerobooleanYestruedata type=boolean
Applies whentype in (line) and fillGapsInChartData = truetype in (lineWithArea) and fillGapsInChartData = truetype in (area) and fillGapsInChartData = truetype in (scatter) and fillGapsInChartData = truetype in (bar) and fillGapsInChartData = truetype in (combination) and fillGapsInChartData = true
multiSeriesChartData {
  fillGapsInChartData: false
  sortOrder: valueAsc
  renderGapAsZero: false
}
secondaryBody
PropertyTypeRequiredDefault ValueDetails
advancedFormattingbooleanYesfalsedata type=boolean
columnstringNodata type=string; maxLen=32767
Applies whenadvancedFormatting = false
htmlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whenadvancedFormatting = true
cssClassesarray of stringsNodata type=string; maxLen=255
Applies whenadvancedFormatting = false
secondaryBody {
  advancedFormatting: false
  column: value
  htmlExpression: ```html
    value
  ```
  cssClasses: [
    value
    value
  ]
}
pageFooter
PropertyTypeRequiredDefault ValueDetails
fontenumYeshelveticadata type=string; lov=STATIC
Valid values: helvetica times courier
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
fontWeightenumYesnormaldata type=string; lov=STATIC
Valid values: normal bold
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
fontSizeintegerYes12data type=integer; maxLen=32767
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
fontColorstringYes#000000data type=string; maxLen=255
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
alignmentenumYescenterdata type=string; lov=STATIC
Valid values: start center end
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
pageFooterTextmultiline stringNodata type=multiline string; maxLen=4000
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf)
pageFooter {
  font: helvetica
  fontWeight: normal
  fontSize: 42
  fontColor: value
  alignment: start
  pageFooterText: ```
    value
  ```
}
download
PropertyTypeRequiredDefault ValueDetails
authorizationenumNodata type=reference; lov=COMPONENT; references=authorization
Valid values: mustNotBePublicUser
Applies whendownload = trueincludeSearchBar = true and includeActionsMenu = true and download = true
formatsarray of enumsNodata type=string; lov=STATIC
Valid values: csv html pdf excel
Applies whendownload = true
sendAsEmailbooleanYestruedata type=boolean
Applies whendownload = trueincludeSearchBar = true and includeActionsMenu = true and download = true
csvSeparatorstringNodata type=string; maxLen=2
Applies whencsvExportEnabled = truedownload = true and formats = csvincludeSearchBar = true and includeActionsMenu = true and download = true and formats = csv
csvEnclosedBystringNodata type=string; maxLen=1
Applies whencsvExportEnabled = truedownload = true and formats = csvincludeSearchBar = true and includeActionsMenu = true and download = true and formats = csv
csvExportEnabledbooleanYesfalsedata type=boolean
filenamestringNodata type=string; maxLen=255
Applies whencsvExportEnabled = truedownload = trueincludeSearchBar = true and includeActionsMenu = true and download = true
supplementalTextmultiline stringNodata type=multiline string; maxLen=4000
Applies whendownload = true and formats is setincludeSearchBar = true and includeActionsMenu = true and download = true and formats is set
linkTextstringYesDownloaddata type=string; maxLen=255
Applies whencsvExportEnabled = true
formatsarray of enumsYesCSV:HTML:XLSX:PDFdata type=string; lov=STATIC
Valid values: csv html excel pdf
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true
download {
  authorization: mustNotBePublicUser
  sendAsEmail: false
  csvSeparator: value
  csvEnclosedBy: value
  csvExportEnabled: false
  filename: value
  supplementalText: ```
    value
  ```
  linkText: value
  formats: [
    csv
    html
  ]
}
settings
PropertyTypeRequiredDefault ValueDetails
timeAxisTypeenumNodata type=string; lov=STATIC
Valid values: auto disabled enabled mixedFrequency skipGaps
Applies whentype in (area)type in (bar)type in (line)type in (lineWithArea)type in (stock)type in (boxPlot)type in (combination)
zoomAndScrollenumYesfalsedata type=string; lov=STATIC
Valid values: false delayed delayedScrollOnly live liveScrollOnly

Specify the zoom and scroll behavior of the chart. Live behavior means that the chart will be updated continuously as it is being manipulated, while Delayed means that the update will wait until the zoom/scroll action is done. While Live zoom and scroll provides the best end user experience, no guarantees are made about the rendering performance or usability for large data sets or slow client environments. If performance is an issue, Delayed zoom and scroll should be used instead.

zoomDirectionenumYesbothAxesdata type=string; lov=STATIC
Valid values: bothAxes xAxis yAxis
Applies whentype in (bubble)type in (scatter)
initialZoomingenumYesnonedata type=string; lov=STATIC
Valid values: first last none
Applies whentype in (bar)type in (line)type in (area)type in (lineWithArea)type in (combination)type in (stock)
showHorizontalGridenumYesautodata type=string; lov=STATIC
Valid values: auto true false
Applies whentype = gantt
showVerticalGridenumYesautodata type=string; lov=STATIC
Valid values: auto true false
Applies whentype = gantt
showRowAxisbooleanYesondata type=boolean
Applies whentype = gantt
axisPositionenumYestopdata type=string; lov=STATIC
Valid values: top bottom
Applies whentype = gantt
pieSelectionEffectenumYeshighlightdata type=string; lov=STATIC
Valid values: explode highlightAndExplode highlight
Applies whentype in (pie)type in (donut)
renderAsenumYescandlestickdata type=string; lov=STATIC
Valid values: area bar candlestick line lineWithArea
Applies whentype = stock
settings {
  timeAxisType: auto
  zoomAndScroll: false
  zoomDirection: bothAxes
  initialZooming: first
  showHorizontalGrid: auto
  showVerticalGrid: auto
  showRowAxis: false
  axisPosition: top
  pieSelectionEffect: explode
  renderAs: area
}
iconAndBadge
PropertyTypeRequiredDefault ValueDetails
iconSourceenumNodata type=string; lov=STATIC
Valid values: initials iconClass iconClassColumn imageUrl imageBlobColumn
iconColumnstringYesdata type=string; maxLen=32767
Applies wheniconSource in (initials)iconSource in (iconClassColumn)
imageColumnstringYesdata type=string; maxLen=32767
Applies wheniconSource = imageBlobColumn
imageUrlstringYesdata type=string; maxLen=4000
Applies wheniconSource = imageUrl
iconCssClassesstringNodata type=string; maxLen=255
Applies wheniconSource is set
iconPositionenumYesstartdata type=string; lov=STATIC
Valid values: top start end
Applies wheniconSource is set
iconDescriptionstringNodata type=string; maxLen=255
Applies wheniconSource is set
badgeColumnstringNodata type=string; maxLen=32767
badgeLabelstringNodata type=string; maxLen=255
Applies whenbadgeColumn is set
badgeCssClassesarray of stringsNodata type=string; maxLen=255
Applies whenbadgeColumn is set
iconAndBadge {
  iconSource: initials
  iconColumn: value
  imageColumn: value
  imageUrl: value
  iconCssClasses: value
  iconPosition: top
  iconDescription: value
  badgeColumn: value
  badgeLabel: value
  badgeCssClasses: [
    value
    value
  ]
}
componentAdvanced
PropertyTypeRequiredDefault ValueDetails
stripHtmlbooleanYesfalsedata type=boolean
sortNullsenumYeslastdata type=string; lov=STATIC
Valid values: first last
customSvgStylesmultiline stringNodata type=multiline string; maxLen=32767
oracleTextIndexColumnstringNodata type=string; maxLen=32767
emailFromAddressstringNodata type=string; maxLen=255
initJavaScriptFunctionmultiline stringNodata type=multiline string; maxLen=4000
Enter a JavaScript function that takes a configuration object for the Interactive Grid, modifies the object, and returns it. This allows advanced customization of the Interactive Grid appearance, features, and behavior including toolbar, menus, and actions.
regionAliasstringNodata type=string; maxLen=255
reportIdItemstringNodata type=string; maxLen=255; textCase=UPPER
maxRowsPerPageInSelectorstringNodata type=string; maxLen=4000
Applies whenincludeSearchBar = true and includeActionsMenu = true and rowsPerPage = trueincludeSearchBar = true and rowsPerPageSelector = true
componentAdvanced {
  stripHtml: false
  sortNulls: first
  customSvgStyles: ```
    value
  ```
  oracleTextIndexColumn: value
  emailFromAddress: value
  initJavaScriptFunction: ```javascript-browser
    value
  ```
  regionAlias: value
  reportIdItem: value
  maxRowsPerPageInSelector: value
}
singleRowView
PropertyTypeRequiredDefault ValueDetails
excludeNullValuesbooleanYesfalsedata type=boolean
Applies whenlinkColumn = singleRowView
onlyDisplayedColumnsbooleanYesfalsedata type=boolean
Applies whenlinkColumn = singleRowView
singleRowView {
  excludeNullValues: false
  onlyDisplayedColumns: false
}
heading
PropertyTypeRequiredDefault ValueDetails
typeenumYescustomHeadingsdata type=string; lov=STATIC
Valid values: columnNames columnNamesInitcap customHeadings plsqlFunctionBody none
plsqlFunctionBodymultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = plsqlFunctionBody
fixedToenumYespagedata type=string; lov=STATIC
Valid values: none region page
fixedReportHeightintegerYesdata type=integer; maxLen=32767
Applies whenfixedTo = region
maxReportHeightintegerYesdata type=integer; maxLen=32767
Applies whenfixedTo = region
heading {
  type: columnNames
  plsqlFunctionBody: ```plsql
    value
  ```
  fixedTo: none
  fixedReportHeight: 42
  maxReportHeight: 42
}
iconView
PropertyTypeRequiredDefault ValueDetails
showbooleanYesfalsedata type=boolean
Specify whether the Icon View is enabled. Selecting On adds a View Icons icon to the Search bar for interactive reports, or to the interactive grid View button, enabling users to access this view.
custombooleanYesfalsedata type=boolean
Applies whenshow = true
customIconmultiline stringYesdata type=multiline string; maxLen=4000
Applies whenshow = true and custom = true
iconTypeenumYesiconCssClassesdata type=string; lov=STATIC
Valid values: imageInUrl iconCssClasses
Applies whenshow = true and custom = false
iconUrlstringYesdata type=string; maxLen=32767
Applies whenshow = true and custom = false and iconType = imageInUrl
iconstringYesdata type=string; maxLen=32767
Applies whenshow = true and custom = false and iconType = iconCssClasses
iconAttributesstringNodata type=string; maxLen=255
Applies whenshow = true and custom = false and iconType = imageInUrl
linkTargetcomplexNodata type=complex; maxLen=32767
Applies whenshow = true
linkAttributesstringNodata type=string; maxLen=255
Applies whenshow = true and linkTarget is set and custom = false
labelColumnstringYesdata type=string; maxLen=32767
Applies whenshow = true and custom = false
columnsPerRowenumYes6data type=string; lov=STATIC
Valid values: 1 2 3 4 5 6 7 8 9
Applies whenshow = true
linkColumnstringYesdata type=string; maxLen=32767
Applies whenshow = true and custom = false
imageSourceColumnstringYesdata type=string; maxLen=32767
Applies whenshow = true and custom = false
labelColumnstringYesdata type=string; maxLen=32767
Applies whenshow = true and custom = false
imageAttributesstringNodata type=string; maxLen=512
Applies whenshow = true and custom = false
htmlAltTextstringNodata type=string; maxLen=512
Applies whenshow = true and custom = false
htmlTitleTextstringNodata type=string; maxLen=512
Applies whenshow = true and custom = false
customLinkmultiline stringYesdata type=multiline string; maxLen=4000
Applies whenshow = true and custom = true
iconView {
  show: false
  custom: false
  customIcon: ```html
    value
  ```
  iconType: imageInUrl
  iconUrl: value
  icon: value
  iconAttributes: value
  linkTarget: {
    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
  }
  linkAttributes: value
  labelColumn: value
  columnsPerRow: "1"
  linkColumn: value
  imageSourceColumn: value
  imageAttributes: value
  htmlAltText: value
  htmlTitleText: value
  customLink: ```
    value
  ```
}
media
PropertyTypeRequiredDefault ValueDetails
advancedFormattingbooleanYesfalsedata type=boolean
htmlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whenadvancedFormatting = true
sourceenumNodata type=string; lov=STATIC
Valid values: imageUrl urlColumn blobColumn
Applies whenadvancedFormatting = false
urlstringYesdata type=string; maxLen=4000
Applies whenadvancedFormatting = false and source = imageUrl
urlColumnstringYesdata type=string; maxLen=32767
Applies whenadvancedFormatting = false and source = urlColumn
blobColumnstringYesdata type=string; maxLen=32767
Applies whenadvancedFormatting = false and source = blobColumn
positionenumYesbodydata type=string; lov=STATIC
Valid values: first body background
Applies whenadvancedFormatting = false and source is set and advancedFormatting = true and htmlExpression is set
appearanceenumNodata type=string; lov=STATIC
Valid values: square widescreen
Applies whenadvancedFormatting = false and source is set
sizingenumYesfitdata type=string; lov=STATIC
Valid values: fit cover
Applies whenadvancedFormatting = false and source is set
cssClassesarray of stringsNodata type=string; maxLen=255
imageDescriptionstringNodata type=string; maxLen=255
Applies whenadvancedFormatting = false and source is set
media {
  advancedFormatting: false
  htmlExpression: ```html
    value
  ```
  source: imageUrl
  url: value
  urlColumn: value
  blobColumn: value
  position: first
  appearance: square
  sizing: fit
  cssClasses: [
    value
    value
  ]
  imageDescription: value
}
legend
PropertyTypeRequiredDefault ValueDetails
showbooleanYestruedata type=boolean
titlestringNodata type=string; maxLen=255
Applies whenshow = trueshow = on
Specify the title of the legend.
positionenumYesenddata type=string; lov=STATIC
Valid values: start end selector
Applies whenshow = true
selectorstringYesdata type=string; maxLen=32767
Applies whenshow = true and position = selector
cssClassesarray of stringsNodata type=string; maxLen=255
Applies whenshow = true
showbooleanYesondata type=boolean
positionenumYesautodata type=string; lov=STATIC
Valid values: auto start end top bottom
Applies whenshow = on
hideAndShowBehaviorenumYesrescaledata type=string; lov=STATIC
Valid values: none rescale noRescaling
Applies whenshow = on
fontFamilyenumNodata type=string; lov=STATIC
Valid values: arial arialBlack bookman comicSansMs courier courierNew garamond georgia helvetica impact palatino times timesNewRoman trebuchetMs verdana
Applies whenshow = on
fontStyleenumNodata type=string; lov=STATIC
Valid values: normal italic oblique
Applies whenshow = on
fontSizeenumNodata type=string; lov=STATIC
Valid values: 8 10 12 14 16 18 20 22
Applies whenshow = on
fontColorstringNodata type=string; maxLen=255
Applies whenshow = on
legend {
  show: false
  title: value
  position: start
  selector: value
  cssClasses: [
    value
    value
  ]
  hideAndShowBehavior: none
  fontFamily: arial
  fontStyle: normal
  fontSize: "8"
  fontColor: value
}
overview
PropertyTypeRequiredDefault ValueDetails
showbooleanYesondata type=boolean
Applies whentype in (area)type in (bar)type in (line)type in (stock)type in (boxPlot)type in (lineWithArea)type in (combination)
heightstringNodata type=string; maxLen=5
Applies whentype in (area) and show = ontype in (bar) and show = ontype in (line) and show = ontype in (stock) and show = ontype in (boxPlot) and show = ontype in (lineWithArea) and show = ontype in (combination) and show = on
overview {
  show: false
  height: value
}
printing
PropertyTypeRequiredDefault ValueDetails
enabledbooleanYesfalsedata type=boolean
printing {
  enabled: false
}
externalProcessing
PropertyTypeRequiredDefault ValueDetails
enabledbooleanYesfalsedata type=boolean
urlstringYesdata type=string; maxLen=2000
Applies whenenabled = true
linkTextstringYesdata type=string; maxLen=2000
Applies whenenabled = true
externalProcessing {
  enabled: false
  url: value
  linkText: value
}
genAI
PropertyTypeRequiredDefault ValueDetails
naturalLanguageSupportbooleanYesfalsedata type=boolean
defaultSearchModeenumYessearchModeAIdata type=string; lov=STATIC
Valid values: searchModeRow searchModeAI
Applies whennaturalLanguageSupport = true
reportContextmultiline stringNodata type=multiline string; maxLen=32767
Applies whennaturalLanguageSupport = true
enabledbooleanYesfalsedata type=boolean
agentreferenceNodata type=reference; lov=COMPONENT; references=aiAgent
Applies whenenabled = true
servicereferenceNodata type=reference; lov=COMPONENT; references=genAIService
Applies whenenabled = true
systemPromptmultiline stringNodata type=multiline string; maxLen=32767
Applies whenenabled = true
welcomeMessagemultiline stringNodata type=multiline string; maxLen=32767
Applies whenenabled = true
genAI {
  naturalLanguageSupport: false
  defaultSearchMode: searchModeRow
  reportContext: ```
    value
  ```
  enabled: false
  agent: @component
  service: @component
  systemPrompt: ```
    value
  ```
  welcomeMessage: ```html
    value
  ```
}
value
PropertyTypeRequiredDefault ValueDetails
pieChartOtherThresholdnumberYes0data type=number; maxLen=22
Applies whentype in (pie)type in (donut)
minintegerNodata type=integer; maxLen=32767
Applies whentype in (pie)type in (donut)
showbooleanYestruedata type=boolean
Applies whentype = statusMeterGauge
valueTypeenumYesnumberdata type=string; lov=STATIC
Valid values: number percent
Applies whentype = statusMeterGauge
positionenumYesautodata type=string; lov=STATIC
Valid values: auto center insideIndicatorEdge outsideIndicatorEdge outsidePlotArea withLabel
Applies whentype = statusMeterGauge
formatenumNodata type=string; lov=STATIC
Valid values: dateShort dateMedium dateLong dateFull timeShort timeMedium timeLong timeFull datetimeShort datetimeMedium datetimeLong datetimeFull decimal currency percent
Applies whentype in (statusMeterGauge)type in (funnel)type in (pyramid)type in (pie)type in (donut)

Specify the type of formatting to be applied to the value on the chart. The formats Decimal,Percent or Currency only apply to numeric values. The Date,Time and DateTime formats will only apply to values of that data type on the chart.

decimalPlacesintegerNodata type=integer; maxLen=32767
Applies whentype in (statusMeterGauge) and format in (decimal)type in (statusMeterGauge) and format in (currency)type in (statusMeterGauge) and format in (percent)type in (statusMeterGauge) and type in (funnel) and format in (decimal)type in (statusMeterGauge) and type in (funnel) and format in (currency)type in (statusMeterGauge) and type in (funnel) and format in (percent)type in (statusMeterGauge) and type in (pyramid) and format in (decimal)type in (statusMeterGauge) and type in (pyramid) and format in (currency)type in (statusMeterGauge) and type in (pyramid) and format in (percent)type in (statusMeterGauge) and type in (pie) and format in (decimal)type in (statusMeterGauge) and type in (pie) and format in (currency)type in (statusMeterGauge) and type in (pie) and format in (percent)type in (statusMeterGauge) and type in (donut) and format in (decimal)type in (statusMeterGauge) and type in (donut) and format in (currency)type in (statusMeterGauge) and type in (donut) and format in (percent)type in (funnel) and type in (statusMeterGauge) and format in (decimal)type in (funnel) and type in (statusMeterGauge) and format in (currency)type in (funnel) and type in (statusMeterGauge) and format in (percent)type in (funnel) and format in (decimal)type in (funnel) and format in (currency)type in (funnel) and format in (percent)type in (funnel) and type in (pyramid) and format in (decimal)type in (funnel) and type in (pyramid) and format in (currency)type in (funnel) and type in (pyramid) and format in (percent)type in (funnel) and type in (pie) and format in (decimal)type in (funnel) and type in (pie) and format in (currency)type in (funnel) and type in (pie) and format in (percent)type in (funnel) and type in (donut) and format in (decimal)type in (funnel) and type in (donut) and format in (currency)type in (funnel) and type in (donut) and format in (percent)type in (pyramid) and type in (statusMeterGauge) and format in (decimal)type in (pyramid) and type in (statusMeterGauge) and format in (currency)type in (pyramid) and type in (statusMeterGauge) and format in (percent)type in (pyramid) and type in (funnel) and format in (decimal)type in (pyramid) and type in (funnel) and format in (currency)type in (pyramid) and type in (funnel) and format in (percent)type in (pyramid) and format in (decimal)type in (pyramid) and format in (currency)type in (pyramid) and format in (percent)type in (pyramid) and type in (pie) and format in (decimal)type in (pyramid) and type in (pie) and format in (currency)type in (pyramid) and type in (pie) and format in (percent)type in (pyramid) and type in (donut) and format in (decimal)type in (pyramid) and type in (donut) and format in (currency)type in (pyramid) and type in (donut) and format in (percent)type in (pie) and type in (statusMeterGauge) and format in (decimal)type in (pie) and type in (statusMeterGauge) and format in (currency)type in (pie) and type in (statusMeterGauge) and format in (percent)type in (pie) and type in (funnel) and format in (decimal)type in (pie) and type in (funnel) and format in (currency)type in (pie) and type in (funnel) and format in (percent)type in (pie) and type in (pyramid) and format in (decimal)type in (pie) and type in (pyramid) and format in (currency)type in (pie) and type in (pyramid) and format in (percent)type in (pie) and format in (decimal)type in (pie) and format in (currency)type in (pie) and format in (percent)type in (pie) and type in (donut) and format in (decimal)type in (pie) and type in (donut) and format in (currency)type in (pie) and type in (donut) and format in (percent)type in (donut) and type in (statusMeterGauge) and format in (decimal)type in (donut) and type in (statusMeterGauge) and format in (currency)type in (donut) and type in (statusMeterGauge) and format in (percent)type in (donut) and type in (funnel) and format in (decimal)type in (donut) and type in (funnel) and format in (currency)type in (donut) and type in (funnel) and format in (percent)type in (donut) and type in (pyramid) and format in (decimal)type in (donut) and type in (pyramid) and format in (currency)type in (donut) and type in (pyramid) and format in (percent)type in (donut) and type in (pie) and format in (decimal)type in (donut) and type in (pie) and format in (currency)type in (donut) and type in (pie) and format in (percent)type in (donut) and format in (decimal)type in (donut) and format in (currency)type in (donut) and format in (percent)
Specify the number of decimal places to be applied to the numeric value on the chart.
currencystringNodata type=string; maxLen=128
Applies whentype in (statusMeterGauge) and format = currencytype in (statusMeterGauge) and type in (funnel) and format = currencytype in (statusMeterGauge) and type in (pyramid) and format = currencytype in (statusMeterGauge) and type in (pie) and format = currencytype in (statusMeterGauge) and type in (donut) and format = currencytype in (funnel) and type in (statusMeterGauge) and format = currencytype in (funnel) and format = currencytype in (funnel) and type in (pyramid) and format = currencytype in (funnel) and type in (pie) and format = currencytype in (funnel) and type in (donut) and format = currencytype in (pyramid) and type in (statusMeterGauge) and format = currencytype in (pyramid) and type in (funnel) and format = currencytype in (pyramid) and format = currencytype in (pyramid) and type in (pie) and format = currencytype in (pyramid) and type in (donut) and format = currencytype in (pie) and type in (statusMeterGauge) and format = currencytype in (pie) and type in (funnel) and format = currencytype in (pie) and type in (pyramid) and format = currencytype in (pie) and format = currencytype in (pie) and type in (donut) and format = currencytype in (donut) and type in (statusMeterGauge) and format = currencytype in (donut) and type in (funnel) and format = currencytype in (donut) and type in (pyramid) and format = currencytype in (donut) and type in (pie) and format = currencytype in (donut) and format = currency
patternstringNodata type=string; maxLen=30
Applies whentype in (statusMeterGauge) and format in (decimal)type in (statusMeterGauge) and format in (currency)type in (statusMeterGauge) and format in (percent)type in (statusMeterGauge) and type in (funnel) and format in (decimal)type in (statusMeterGauge) and type in (funnel) and format in (currency)type in (statusMeterGauge) and type in (funnel) and format in (percent)type in (statusMeterGauge) and type in (pyramid) and format in (decimal)type in (statusMeterGauge) and type in (pyramid) and format in (currency)type in (statusMeterGauge) and type in (pyramid) and format in (percent)type in (statusMeterGauge) and type in (pie) and format in (decimal)type in (statusMeterGauge) and type in (pie) and format in (currency)type in (statusMeterGauge) and type in (pie) and format in (percent)type in (statusMeterGauge) and type in (donut) and format in (decimal)type in (statusMeterGauge) and type in (donut) and format in (currency)type in (statusMeterGauge) and type in (donut) and format in (percent)type in (funnel) and type in (statusMeterGauge) and format in (decimal)type in (funnel) and type in (statusMeterGauge) and format in (currency)type in (funnel) and type in (statusMeterGauge) and format in (percent)type in (funnel) and format in (decimal)type in (funnel) and format in (currency)type in (funnel) and format in (percent)type in (funnel) and type in (pyramid) and format in (decimal)type in (funnel) and type in (pyramid) and format in (currency)type in (funnel) and type in (pyramid) and format in (percent)type in (funnel) and type in (pie) and format in (decimal)type in (funnel) and type in (pie) and format in (currency)type in (funnel) and type in (pie) and format in (percent)type in (funnel) and type in (donut) and format in (decimal)type in (funnel) and type in (donut) and format in (currency)type in (funnel) and type in (donut) and format in (percent)type in (pyramid) and type in (statusMeterGauge) and format in (decimal)type in (pyramid) and type in (statusMeterGauge) and format in (currency)type in (pyramid) and type in (statusMeterGauge) and format in (percent)type in (pyramid) and type in (funnel) and format in (decimal)type in (pyramid) and type in (funnel) and format in (currency)type in (pyramid) and type in (funnel) and format in (percent)type in (pyramid) and format in (decimal)type in (pyramid) and format in (currency)type in (pyramid) and format in (percent)type in (pyramid) and type in (pie) and format in (decimal)type in (pyramid) and type in (pie) and format in (currency)type in (pyramid) and type in (pie) and format in (percent)type in (pyramid) and type in (donut) and format in (decimal)type in (pyramid) and type in (donut) and format in (currency)type in (pyramid) and type in (donut) and format in (percent)type in (pie) and type in (statusMeterGauge) and format in (decimal)type in (pie) and type in (statusMeterGauge) and format in (currency)type in (pie) and type in (statusMeterGauge) and format in (percent)type in (pie) and type in (funnel) and format in (decimal)type in (pie) and type in (funnel) and format in (currency)type in (pie) and type in (funnel) and format in (percent)type in (pie) and type in (pyramid) and format in (decimal)type in (pie) and type in (pyramid) and format in (currency)type in (pie) and type in (pyramid) and format in (percent)type in (pie) and format in (decimal)type in (pie) and format in (currency)type in (pie) and format in (percent)type in (pie) and type in (donut) and format in (decimal)type in (pie) and type in (donut) and format in (currency)type in (pie) and type in (donut) and format in (percent)type in (donut) and type in (statusMeterGauge) and format in (decimal)type in (donut) and type in (statusMeterGauge) and format in (currency)type in (donut) and type in (statusMeterGauge) and format in (percent)type in (donut) and type in (funnel) and format in (decimal)type in (donut) and type in (funnel) and format in (currency)type in (donut) and type in (funnel) and format in (percent)type in (donut) and type in (pyramid) and format in (decimal)type in (donut) and type in (pyramid) and format in (currency)type in (donut) and type in (pyramid) and format in (percent)type in (donut) and type in (pie) and format in (decimal)type in (donut) and type in (pie) and format in (currency)type in (donut) and type in (pie) and format in (percent)type in (donut) and format in (decimal)type in (donut) and format in (currency)type in (donut) and format in (percent)
Specify the numeric pattern to be applied to the numeric value on the chart.
formatScalingenumYesautodata type=string; lov=STATIC
Valid values: none auto thousand million billion trillion quadrillion
Applies whentype in (statusMeterGauge)type in (funnel)type in (pyramid)type in (pie)type in (donut)
value {
  pieChartOtherThreshold: 42
  min: 42
  show: false
  valueType: number
  position: auto
  format: dateShort
  decimalPlaces: 42
  currency: value
  pattern: value
  formatScaling: none
}
attributes
PropertyTypeRequiredDefault ValueDetails
messagesPositionenumNodata type=string; lov=STATIC
Valid values: above below selector
messageSelectorstringYesdata type=string; maxLen=32767
Applies whenmessagesPosition = selector
unitSystemenumYesmetricdata type=string; lov=STATIC
Valid values: metric imperial deriveFromItem
unitSystemItemstringYesdata type=string; maxLen=32767; textCase=UPPER
Applies whenunitSystem = deriveFromItem
copyrightNoticemultiline stringNodata type=multiline string; maxLen=32767
attributes {
  messagesPosition: above
  messageSelector: value
  unitSystem: metric
  unitSystemItem: value
  copyrightNotice: ```html
    value
  ```
}
searchBar
PropertyTypeRequiredDefault ValueDetails
includeSearchBarbooleanYestruedata type=boolean
searchFieldbooleanYestruedata type=boolean
Applies whenincludeSearchBar = true
finderDropDownbooleanYestruedata type=boolean
Applies whenincludeSearchBar = true and searchField = true
reportsSelectListbooleanYesTABSdata type=boolean
Applies whenincludeSearchBar = true
rowsPerPageSelectorbooleanYesfalsedata type=boolean
Applies whenincludeSearchBar = true
searchButtonLabelstringNodata type=string; maxLen=4000
Applies whenincludeSearchBar = true
searchBar {
  includeSearchBar: false
  searchField: false
  finderDropDown: false
  reportsSelectList: false
  rowsPerPageSelector: false
  searchButtonLabel: value
}
orderBy
PropertyTypeRequiredDefault ValueDetails
typeenumNodata type=string; lov=STATIC
Valid values: staticValue item
Applies whenlocation in (localDatabase) and type in (tableView)location in (localDatabase) and type in (propertyGraph)location in (localDatabase) and type in (sqlQuery)location in (localDatabase) and type in (functionBody)location in (localDatabase) and type in ($NULL$)location in (localDatabase) and location in (restEnabledSql) and type in (tableView)location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph)location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery)location in (localDatabase) and location in (restEnabledSql) and type in (functionBody)location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$)location in (restEnabledSql) and location in (localDatabase) and type in (tableView)location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph)location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery)location in (restEnabledSql) and location in (localDatabase) and type in (functionBody)location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$)location in (restEnabledSql) and type in (tableView)location in (restEnabledSql) and type in (propertyGraph)location in (restEnabledSql) and type in (sqlQuery)location in (restEnabledSql) and type in (functionBody)location in (restEnabledSql) and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (tableView)location in (sampleData) and location in (localDatabase) and type in (propertyGraph)location in (sampleData) and location in (localDatabase) and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$)
orderByClausemultiline stringYesdata type=multiline string; maxLen=4000
Applies whenlocation in (localDatabase) and type in (tableView) and type = staticValuelocation in (localDatabase) and type in (tableView) and type = staticValue and type in (sqlQuery)location in (localDatabase) and type in (tableView) and type = staticValue and type in (functionBody)location in (localDatabase) and type in (tableView) and type = staticValue and type in ($NULL$)location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql)location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type in (functionBody)location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (tableView)location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (sqlQuery)location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (functionBody)location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in ($NULL$)location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in (tableView)location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in (functionBody)location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in (tableView)location in (localDatabase) and type in (sqlQuery) and type = staticValuelocation in (localDatabase) and type in (sqlQuery) and type = staticValue and type in (functionBody)location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in ($NULL$)location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type in (tableView)location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql)location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type in (functionBody)location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)location in (localDatabase) and type in (functionBody) and type = staticValue and type in (tableView)location in (localDatabase) and type in (functionBody) and type = staticValue and type in (sqlQuery)location in (localDatabase) and type in (functionBody) and type = staticValuelocation in (localDatabase) and type in (functionBody) and type = staticValue and type in ($NULL$)location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type in (tableView)location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql)location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (tableView)location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (sqlQuery)location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (functionBody)location in (localDatabase) and type in ($NULL$) and type = staticValuelocation in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type in (tableView)location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type in (functionBody)location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql)location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = staticValuelocation in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in (sqlQuery)location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in (functionBody)location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in ($NULL$)location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (tableView)location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (sqlQuery)location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (functionBody)location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in ($NULL$)location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in (tableView)location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValuelocation in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in (functionBody)location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in ($NULL$)location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in (tableView)location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in (sqlQuery)location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = staticValuelocation in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in ($NULL$)location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (tableView)location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (sqlQuery)location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (functionBody)location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = staticValuelocation in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = staticValuelocation in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = staticValue and type in (sqlQuery)location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = staticValue and type in (functionBody)location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = staticValue and type in ($NULL$)location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (tableView)location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (sqlQuery)location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (functionBody)location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in ($NULL$)location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in (tableView)location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = staticValuelocation in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in (functionBody)location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in ($NULL$)location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = staticValue and type in (tableView)location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = staticValue and type in (sqlQuery)location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = staticValuelocation in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = staticValue and type in ($NULL$)location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (tableView)location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (sqlQuery)location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (functionBody)location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = staticValuelocation in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase)location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type in (sqlQuery)location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type in (functionBody)location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type in ($NULL$)location in (restEnabledSql) and type in (tableView) and type = staticValuelocation in (restEnabledSql) and type in (tableView) and type = staticValue and type in (sqlQuery)location in (restEnabledSql) and type in (tableView) and type = staticValue and type in (functionBody)location in (restEnabledSql) and type in (tableView) and type = staticValue and type in ($NULL$)location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in (tableView)location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in (sqlQuery)location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in (functionBody)location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in ($NULL$)location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (tableView)location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (sqlQuery)location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (functionBody)location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in ($NULL$)location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type in (tableView)location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase)location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type in (functionBody)location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type in ($NULL$)location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in (tableView)location in (restEnabledSql) and type in (sqlQuery) and type = staticValuelocation in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in (functionBody)location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in ($NULL$)location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type in (tableView)location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type in (sqlQuery)location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase)location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type in ($NULL$)location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in (tableView)location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in (sqlQuery)location in (restEnabledSql) and type in (functionBody) and type = staticValuelocation in (restEnabledSql) and type in (functionBody) and type = staticValue and type in ($NULL$)location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type in (tableView)location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type in (sqlQuery)location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type in (functionBody)location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase)location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (tableView)location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (sqlQuery)location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (functionBody)location in (restEnabledSql) and type in ($NULL$) and type = staticValuelocation in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValuelocation in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql)location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (tableView)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in (tableView)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in (tableView)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValuelocation in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type in (tableView)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and type in (tableView)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValuelocation in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type in (tableView)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (tableView)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValuelocation in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type in (tableView)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValuelocation in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValuelocation in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValuelocation in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue
itemcomplexYesdata type=complex; maxLen=32767
Applies whenlocation in (localDatabase) and type in (tableView) and type = itemlocation in (localDatabase) and type in (tableView) and type = item and type in (sqlQuery)location in (localDatabase) and type in (tableView) and type = item and type in (functionBody)location in (localDatabase) and type in (tableView) and type = item and type in ($NULL$)location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql)location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type in (sqlQuery)location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type in (functionBody)location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type in ($NULL$)location in (localDatabase) and type in (propertyGraph) and type = item and type in (tableView)location in (localDatabase) and type in (propertyGraph) and type = item and type in (sqlQuery)location in (localDatabase) and type in (propertyGraph) and type = item and type in (functionBody)location in (localDatabase) and type in (propertyGraph) and type = item and type in ($NULL$)location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in (tableView)location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in (sqlQuery)location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in (functionBody)location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in ($NULL$)location in (localDatabase) and type in (sqlQuery) and type = item and type in (tableView)location in (localDatabase) and type in (sqlQuery) and type = itemlocation in (localDatabase) and type in (sqlQuery) and type = item and type in (functionBody)location in (localDatabase) and type in (sqlQuery) and type = item and type in ($NULL$)location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type in (tableView)location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql)location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type in (functionBody)location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type in ($NULL$)location in (localDatabase) and type in (functionBody) and type = item and type in (tableView)location in (localDatabase) and type in (functionBody) and type = item and type in (sqlQuery)location in (localDatabase) and type in (functionBody) and type = itemlocation in (localDatabase) and type in (functionBody) and type = item and type in ($NULL$)location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type in (tableView)location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type in (sqlQuery)location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql)location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type in ($NULL$)location in (localDatabase) and type in ($NULL$) and type = item and type in (tableView)location in (localDatabase) and type in ($NULL$) and type = item and type in (sqlQuery)location in (localDatabase) and type in ($NULL$) and type = item and type in (functionBody)location in (localDatabase) and type in ($NULL$) and type = itemlocation in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type in (tableView)location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type in (sqlQuery)location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type in (functionBody)location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql)location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = itemlocation in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = item and type in (sqlQuery)location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = item and type in (functionBody)location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = item and type in ($NULL$)location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (tableView)location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (sqlQuery)location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (functionBody)location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in ($NULL$)location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in (tableView)location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = itemlocation in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in (functionBody)location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in ($NULL$)location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = item and type in (tableView)location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = item and type in (sqlQuery)location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = itemlocation in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = item and type in ($NULL$)location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (tableView)location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (sqlQuery)location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (functionBody)location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = itemlocation in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = itemlocation in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = item and type in (sqlQuery)location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = item and type in (functionBody)location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = item and type in ($NULL$)location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = item and type in (tableView)location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = item and type in (sqlQuery)location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = item and type in (functionBody)location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = item and type in ($NULL$)location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = item and type in (tableView)location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = itemlocation in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = item and type in (functionBody)location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = item and type in ($NULL$)location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = item and type in (tableView)location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = item and type in (sqlQuery)location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = itemlocation in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = item and type in ($NULL$)location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = item and type in (tableView)location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = item and type in (sqlQuery)location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = item and type in (functionBody)location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = itemlocation in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase)location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type in (sqlQuery)location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type in (functionBody)location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type in ($NULL$)location in (restEnabledSql) and type in (tableView) and type = itemlocation in (restEnabledSql) and type in (tableView) and type = item and type in (sqlQuery)location in (restEnabledSql) and type in (tableView) and type = item and type in (functionBody)location in (restEnabledSql) and type in (tableView) and type = item and type in ($NULL$)location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in (tableView)location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in (sqlQuery)location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in (functionBody)location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in ($NULL$)location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (tableView)location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (sqlQuery)location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (functionBody)location in (restEnabledSql) and type in (propertyGraph) and type = item and type in ($NULL$)location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type in (tableView)location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase)location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type in (functionBody)location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type in ($NULL$)location in (restEnabledSql) and type in (sqlQuery) and type = item and type in (tableView)location in (restEnabledSql) and type in (sqlQuery) and type = itemlocation in (restEnabledSql) and type in (sqlQuery) and type = item and type in (functionBody)location in (restEnabledSql) and type in (sqlQuery) and type = item and type in ($NULL$)location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type in (tableView)location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type in (sqlQuery)location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase)location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type in ($NULL$)location in (restEnabledSql) and type in (functionBody) and type = item and type in (tableView)location in (restEnabledSql) and type in (functionBody) and type = item and type in (sqlQuery)location in (restEnabledSql) and type in (functionBody) and type = itemlocation in (restEnabledSql) and type in (functionBody) and type = item and type in ($NULL$)location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type in (tableView)location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type in (sqlQuery)location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type in (functionBody)location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase)location in (restEnabledSql) and type in ($NULL$) and type = item and type in (tableView)location in (restEnabledSql) and type in ($NULL$) and type = item and type in (sqlQuery)location in (restEnabledSql) and type in ($NULL$) and type = item and type in (functionBody)location in (restEnabledSql) and type in ($NULL$) and type = itemlocation in (sampleData) and location in (localDatabase) and type in (tableView) and type = itemlocation in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql)location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and type in (tableView)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in (tableView)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and type in (tableView)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = itemlocation in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type in (tableView)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and type in (tableView)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = itemlocation in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type in (tableView)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and type in (tableView)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = itemlocation in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type in (tableView)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = itemlocation in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = itemlocation in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = itemlocation in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item
orderByClausemultiline stringYesdata type=multiline string; maxLen=4000
Applies whenlocation in (localDatabase) and type in (tableView) and type = staticValue and type = propertyGraphlocation in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type = propertyGraphlocation in (localDatabase) and type in (propertyGraph) and type = staticValue and type = propertyGraphlocation in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type = propertyGraphlocation in (localDatabase) and type in (sqlQuery) and type = staticValue and type = propertyGraphlocation in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type = propertyGraphlocation in (localDatabase) and type in (functionBody) and type = staticValue and type = propertyGraphlocation in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type = propertyGraphlocation in (localDatabase) and type in ($NULL$) and type = staticValue and type = propertyGraphlocation in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type = propertyGraphlocation in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type = propertyGraphlocation in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type = propertyGraphlocation in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type = propertyGraphlocation in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type = propertyGraphlocation in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type = propertyGraphlocation in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = staticValue and type = propertyGraphlocation in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type = propertyGraphlocation in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type = propertyGraphlocation in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = staticValue and type = propertyGraphlocation in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type = propertyGraphlocation in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type in (tableView) and type = staticValue and type = propertyGraphlocation in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type = propertyGraphlocation in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type = propertyGraphlocation in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type in (functionBody) and type = staticValue and type = propertyGraphlocation in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type in ($NULL$) and type = staticValue and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type = propertyGraph
itemcomplexYesdata type=complex; maxLen=32767
Applies whenlocation in (localDatabase) and type in (tableView) and type = item and type = propertyGraphlocation in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type = propertyGraphlocation in (localDatabase) and type in (propertyGraph) and type = item and type = propertyGraphlocation in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type = propertyGraphlocation in (localDatabase) and type in (sqlQuery) and type = item and type = propertyGraphlocation in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type = propertyGraphlocation in (localDatabase) and type in (functionBody) and type = item and type = propertyGraphlocation in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type = propertyGraphlocation in (localDatabase) and type in ($NULL$) and type = item and type = propertyGraphlocation in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type = propertyGraphlocation in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = item and type = propertyGraphlocation in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type = propertyGraphlocation in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type = propertyGraphlocation in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = item and type = propertyGraphlocation in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = item and type = propertyGraphlocation in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = item and type = propertyGraphlocation in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = item and type = propertyGraphlocation in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = item and type = propertyGraphlocation in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = item and type = propertyGraphlocation in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = item and type = propertyGraphlocation in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type in (tableView) and type = item and type = propertyGraphlocation in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type in (propertyGraph) and type = item and type = propertyGraphlocation in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type in (sqlQuery) and type = item and type = propertyGraphlocation in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type in (functionBody) and type = item and type = propertyGraphlocation in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type in ($NULL$) and type = item and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and type = propertyGraph
orderBy {
  type: staticValue
  orderByClause: ```sql
    value
  ```
  item: {
    itemName: value
    orderBys: [
      value
      value
    ]
  }
}
blobAttributes
PropertyTypeRequiredDefault ValueDetails
mimeTypeColumnstringNodata type=string; maxLen=32767
Applies wheniconSource = imageBlobColumnadvancedFormatting = false and source = blobColumn
lastUpdatedColumnstringNodata type=string; maxLen=32767
Applies wheniconSource = imageBlobColumnadvancedFormatting = false and source = blobColumn
blobAttributes {
  mimeTypeColumn: value
  lastUpdatedColumn: value
}
detailView
PropertyTypeRequiredDefault ValueDetails
showbooleanYesfalsedata type=boolean
Specify whether the Detail View is enabled. Selecting On adds a View Details icon to the Search bar for interactive reports, or to the interactive grid View button, enabling users to access this view.
beforeRowsmultiline stringNodata type=multiline string; maxLen=4000
Applies whenshow = true
forEachRowmultiline stringDependsdata type=multiline string; maxLen=4000
Applies whenshow = true

Enter the body for report rows in the Detail View.

The following substitution strings are available:

  • &<COLUMN_NAME>. - substitution strings for column names.
  • &<COLUMN_NAME>_LABEL. - substitution strings for column labels.
  • &APEX$ROW_ID. - the record identifier for the row.
  • &APEX$ROW_INDEX. - the record display sequence number.
  • &APEX$ROW_STATE_CLASSES. - the record state such as is-inserted or is-deleted.

afterRowsmultiline stringNodata type=multiline string; maxLen=4000
Applies whenshow = true
detailView {
  show: false
  beforeRows: ```html
    value
  ```
  forEachRow: ```html
    value
  ```
  afterRows: ```html
    value
  ```
}
actionsMenu
PropertyTypeRequiredDefault ValueDetails
includeActionsMenubooleanYestruedata type=boolean
Applies whenincludeSearchBar = true
filterbooleanYestruedata type=boolean
Applies whenincludeSearchBar = true and includeActionsMenu = true
selectColumnsbooleanYestruedata type=boolean
Applies whenincludeSearchBar = true and includeActionsMenu = true
rowsPerPagebooleanYestruedata type=boolean
Applies whenincludeSearchBar = true and includeActionsMenu = true
sortbooleanYestruedata type=boolean
Applies whenincludeSearchBar = true and includeActionsMenu = true
controlBreakbooleanYestruedata type=boolean
Applies whenincludeSearchBar = true and includeActionsMenu = true
highlightbooleanYestruedata type=boolean
Applies whenincludeSearchBar = true and includeActionsMenu = true
computebooleanYestruedata type=boolean
Applies whenincludeSearchBar = true and includeActionsMenu = true
aggregatebooleanYestruedata type=boolean
Applies whenincludeSearchBar = true and includeActionsMenu = true
chartbooleanYestruedata type=boolean
Applies whenincludeSearchBar = true and includeActionsMenu = true
groupBybooleanYestruedata type=boolean
Applies whenincludeSearchBar = true and includeActionsMenu = true
pivotbooleanYestruedata type=boolean
Applies whenincludeSearchBar = true and includeActionsMenu = true
flashbackbooleanYestruedata type=boolean
Applies whenincludeSearchBar = true and includeActionsMenu = true
saveReportbooleanYestruedata type=boolean
Applies whenincludeSearchBar = true and includeActionsMenu = true
savePublicReportbooleanYesfalsedata type=boolean
Applies whenincludeSearchBar = true and includeActionsMenu = true and saveReport = true
savePublicReportAuthorizationenumNodata type=reference; lov=COMPONENT; references=authorization
Valid values: mustNotBePublicUser
Applies whenincludeSearchBar = true and includeActionsMenu = true and saveReport = true and savePublicReport = true
resetbooleanYestruedata type=boolean
Applies whenincludeSearchBar = true and includeActionsMenu = true
helpbooleanYestruedata type=boolean
Applies whenincludeSearchBar = true and includeActionsMenu = true
downloadbooleanYestruedata type=boolean
Applies whenincludeSearchBar = true and includeActionsMenu = true
subscriptionbooleanYestruedata type=boolean
Applies whenincludeSearchBar = true and includeActionsMenu = true and download = true
actionsMenu {
  includeActionsMenu: false
  filter: false
  selectColumns: false
  rowsPerPage: false
  sort: false
  controlBreak: false
  highlight: false
  compute: false
  aggregate: false
  chart: false
  groupBy: false
  pivot: false
  flashback: false
  saveReport: false
  savePublicReport: false
  savePublicReportAuthorization: mustNotBePublicUser
  reset: false
  help: false
  download: false
  subscription: false
}
dataProfile
PropertyTypeRequiredDefault ValueDetails
nestedRowsreferenceNodata type=reference; lov=COMPONENT; references=dataProfileColumn
Applies whenlocation = restSource and restSource supports HAS_ARRAY_COLUMNS
nestedRowsreferenceNodata type=reference; lov=COMPONENT; references=dataProfileColumn
Applies whenlocation = jsonDualityView and jsonDualityView supports HAS_ARRAY_COLUMNS
nestedRowsreferenceNodata type=reference; lov=COMPONENT; references=dataProfileColumn
Applies whenlocation = jsonSource and jsonSource supports HAS_ARRAY_COLUMNS
dataProfile {
  nestedRows: @component
}
animation
PropertyTypeRequiredDefault ValueDetails
onDisplayenumYesautodata type=string; lov=STATIC
Valid values: auto alphaFade zoom none
Applies whenlazyLoading = false
onDataChangeenumYesautodata type=string; lov=STATIC
Valid values: auto slideToLeft slideToRight none
animation {
  onDisplay: auto
  onDataChange: auto
}
restSynchronization
PropertyTypeRequiredDefault ValueDetails
useLocalTablebooleanYesfalsedata type=boolean
Applies whenlocation = restSource and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNSlocation = restSource and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNSlocation = restSource and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED
restSynchronization {
  useLocalTable: false
}
tooltip
PropertyTypeRequiredDefault ValueDetails
showbooleanYestruedata type=boolean
showSeriesNamebooleanYestruedata type=boolean
Applies whenshow = true
showGroupNamebooleanYestruedata type=boolean
Applies whenshow = true
showValuebooleanYestruedata type=boolean
Applies whenshow = true
showRowbooleanYestruedata type=boolean
Applies whenshow = true and type = gantt
showLabelbooleanYestruedata type=boolean
Applies whenshow = true and type = gantt
showStartDatebooleanYestruedata type=boolean
Applies whenshow = true and type = gantt
showEndDatebooleanYestruedata type=boolean
Applies whenshow = true and type = gantt
showProgressbooleanYestruedata type=boolean
Applies whenshow = true and type = gantt
showBaselinebooleanYestruedata type=boolean
Applies whenshow = true and type = gantt
tooltip {
  show: false
  showSeriesName: false
  showGroupName: false
  showValue: false
  showRow: false
  showLabel: false
  showStartDate: false
  showEndDate: false
  showProgress: false
  showBaseline: false
}
externalFilterAndOrderBy
PropertyTypeRequiredDefault ValueDetails
enabledbooleanYesfalsedata type=boolean
Applies whenlocation = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false)location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$)location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in (false)location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in ($NULL$)location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false)location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in ($NULL$)
filtermultiline stringNodata type=multiline string; maxLen=4000
Applies whenlocation = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in (false) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in ($NULL$) and enabled = true
orderByTypeenumNodata type=string; lov=STATIC
Valid values: staticValue item
Applies whenlocation = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in (false) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in ($NULL$) and enabled = true
orderBymultiline stringNodata type=multiline string; maxLen=255
Applies whenlocation = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false) and enabled = true and orderByType = staticValuelocation = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = true and orderByType = staticValuelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in (false) and enabled = true and orderByType = staticValuelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = true and orderByType = staticValuelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false) and enabled = true and orderByType = staticValuelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in ($NULL$) and enabled = true and orderByType = staticValuelocation = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in (false) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in ($NULL$) and enabled = true
itemcomplexYesdata type=complex; maxLen=4000
Applies whenlocation = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false) and enabled = true and orderByType = itemlocation = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = true and orderByType = itemlocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in (false) and enabled = true and orderByType = itemlocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = true and orderByType = itemlocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false) and enabled = true and orderByType = itemlocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in ($NULL$) and enabled = true and orderByType = item
externalFilterAndOrderBy {
  enabled: false
  filter: ```
    value
  ```
  orderByType: staticValue
  orderBy: ```
    value
  ```
  item: {
    itemName: value
    orderBys: [
      value
      value
    ]
  }
}
advanced
PropertyTypeRequiredDefault ValueDetails
savedReportMappingIdentifierstringNodata type=string; maxLen=32767
htmlDomIdstringNodata type=string; maxLen=255

Enter the DOM ID for this region. If defined, this is used as the ID for the region, using the substitution string #DOM_ID#, which can be useful if developing custom JavaScript behavior for the region. If this is not defined, the region generates an internal ID.

Note: The template must include the #DOM_ID# substitution string, in order for the region to utilize the DOM ID entered.

customAttributesstringNodata type=string; maxLen=2000
Enter the value substituted into region attributes. Region templates that contain the substitution string #REGION_ATTRIBUTES# are substituted with this value.
regionImagestringNodata type=string; maxLen=255
Applies whentemplate supports NOT_REGION_IMAGE_URL
imageTagAttributesstringNodata type=string; maxLen=255
Applies whentemplate supports NOT_REGION_IMAGE_URL and regionImage is set
staticIdstringYesdata type=string; maxLen=255
regionDisplaySelectorbooleanYesfalsedata type=boolean
Applies whentemplate is set
excludeTitleFromTranslationbooleanYesfalsedata type=boolean
schemaOverrideItemstringNodata type=string; maxLen=4000; textCase=UPPER
advanced {
  savedReportMappingIdentifier: value
  htmlDomId: value
  customAttributes: value
  regionImage: value
  imageTagAttributes: value
  staticId: value
  regionDisplaySelector: false
  excludeTitleFromTranslation: false
  schemaOverrideItem: value
}
help
PropertyTypeRequiredDefault ValueDetails
helpTextmultiline stringNodata type=multiline string; maxLen=4000

Use this attribute to enter help text for the interactive grid. The entered help text will display along with the default help content under Actions Menu help.

help {
  helpText: ```html
    value
  ```
}
localPostProcessing
PropertyTypeRequiredDefault ValueDetails
typeenumNodata type=string; lov=STATIC
Valid values: whereOrderByClause sqlQuery plsqlFunctionBody
Applies whenlocation = restSource and restSource is set
whereClausemultiline stringNodata type=multiline string; maxLen=4000
Applies whenlocation = restSource and restSource is set and type = whereOrderByClause
sqlQuerymultiline stringYesdata type=multiline string; maxLen=32767
Applies whenlocation = restSource and restSource is set and type = sqlQuery
languageenumYesplsqldata type=string; lov=STATIC
Valid values: plsql javaScript-mle
Applies whenlocation = restSource and restSource is set and type = plsqlFunctionBody
plsqlFunctionBodymultiline stringYesdata type=multiline string; maxLen=32767
Applies whenlocation = restSource and restSource is set and type = plsqlFunctionBody and language = plsql
javaScriptFunctionBodymultiline stringYesdata type=multiline string; maxLen=32767
Applies whenlocation = restSource and restSource is set and type = plsqlFunctionBody and language = javaScript-mle
orderByTypeenumNodata type=string; lov=STATIC
Valid values: staticValue item
Applies whenlocation = restSource and restSource is set and type = whereOrderByClause
orderByClausemultiline stringYesdata type=multiline string; maxLen=255
Applies whenlocation = restSource and restSource is set and type = whereOrderByClause and orderByType = staticValue
itemcomplexYesdata type=complex; maxLen=32767
Applies whenlocation = restSource and restSource is set and type = whereOrderByClause and orderByType = item
orderByItemcomplexNodata type=complex; maxLen=32767
Applies whenlocation = restSource and restSource is set and type in (sqlQuery)location = restSource and restSource is set and type in (plsqlFunctionBody)
typeenumNodata type=string; lov=STATIC
Valid values: whereOrderByClause sqlQuery plsqlFunctionBody
Applies whenlocation = jsonDualityView and jsonDualityView is set
whereClausemultiline stringNodata type=multiline string; maxLen=4000
Applies whenlocation = jsonDualityView and jsonDualityView is set and type = whereOrderByClause
sqlQuerymultiline stringYesdata type=multiline string; maxLen=32767
Applies whenlocation = jsonDualityView and jsonDualityView is set and type = sqlQuery
languageenumYesplsqldata type=string; lov=STATIC
Valid values: plsql javaScript-mle
Applies whenlocation = jsonDualityView and jsonDualityView is set and type = plsqlFunctionBody
plsqlFunctionBodymultiline stringYesdata type=multiline string; maxLen=32767
Applies whenlocation = jsonDualityView and jsonDualityView is set and type = plsqlFunctionBody and language = plsql
javaScriptFunctionBodymultiline stringYesdata type=multiline string; maxLen=32767
Applies whenlocation = jsonDualityView and jsonDualityView is set and type = plsqlFunctionBody and language = javaScript-mle
orderByTypeenumNodata type=string; lov=STATIC
Valid values: staticValue item
Applies whenlocation = jsonDualityView and jsonDualityView is set and type = whereOrderByClause
orderByClausemultiline stringYesdata type=multiline string; maxLen=255
Applies whenlocation = jsonDualityView and jsonDualityView is set and type = whereOrderByClause and orderByType = staticValue
itemcomplexYesdata type=complex; maxLen=32767
Applies whenlocation = jsonDualityView and jsonDualityView is set and type = whereOrderByClause and orderByType = item
orderByItemcomplexNodata type=complex; maxLen=32767
Applies whenlocation = jsonDualityView and jsonDualityView is set and type in (sqlQuery)location = jsonDualityView and jsonDualityView is set and type in (plsqlFunctionBody)
typeenumNodata type=string; lov=STATIC
Valid values: whereOrderByClause sqlQuery plsqlFunctionBody
Applies whenlocation = jsonSource and jsonSource is set
whereClausemultiline stringNodata type=multiline string; maxLen=4000
Applies whenlocation = jsonSource and jsonSource is set and type = whereOrderByClause
sqlQuerymultiline stringYesdata type=multiline string; maxLen=32767
Applies whenlocation = jsonSource and jsonSource is set and type = sqlQuery
languageenumYesplsqldata type=string; lov=STATIC
Valid values: plsql javaScript-mle
Applies whenlocation = jsonSource and jsonSource is set and type = plsqlFunctionBody
plsqlFunctionBodymultiline stringYesdata type=multiline string; maxLen=32767
Applies whenlocation = jsonSource and jsonSource is set and type = plsqlFunctionBody and language = plsql
javaScriptFunctionBodymultiline stringYesdata type=multiline string; maxLen=32767
Applies whenlocation = jsonSource and jsonSource is set and type = plsqlFunctionBody and language = javaScript-mle
orderByTypeenumNodata type=string; lov=STATIC
Valid values: staticValue item
Applies whenlocation = jsonSource and jsonSource is set and type = whereOrderByClause
orderByClausemultiline stringYesdata type=multiline string; maxLen=255
Applies whenlocation = jsonSource and jsonSource is set and type = whereOrderByClause and orderByType = staticValue
itemcomplexYesdata type=complex; maxLen=32767
Applies whenlocation = jsonSource and jsonSource is set and type = whereOrderByClause and orderByType = item
orderByItemcomplexNodata type=complex; maxLen=32767
Applies whenlocation = jsonSource and jsonSource is set and type in (sqlQuery)location = jsonSource and jsonSource is set and type in (plsqlFunctionBody)
localPostProcessing {
  type: whereOrderByClause
  whereClause: ```sql
    value
  ```
  sqlQuery: ```sql
    value
  ```
  language: plsql
  plsqlFunctionBody: ```plsql
    value
  ```
  javaScriptFunctionBody: ```javascript-mle
    value
  ```
  orderByType: staticValue
  orderByClause: ```sql
    value
  ```
  item: {
    itemName: value
    orderBys: [
      value
      value
    ]
  }
  orderByItem: {
    itemName: value
    orderBys: [
      value
      value
    ]
  }
}
autoRefresh
PropertyTypeRequiredDefault ValueDetails
intervalintegerNodata type=integer; maxLen=32767
autoRefresh {
  interval: 42
}
remoteCache
PropertyTypeRequiredDefault ValueDetails
cachingenumNodata type=string; lov=STATIC
Valid values: allUsers user session
Applies whenlocation = restEnabledSql
timeoutmultiline stringYesdata type=multiline string; maxLen=255
Applies whenlocation = restEnabledSql and caching is set
remoteCache {
  caching: allUsers
  timeout: ```
    value
  ```
}
layout
PropertyTypeRequiredDefault ValueDetails
sequencenumberYesdata type=number; maxLen=22
parentRegionreferenceNodata type=reference; lov=COMPONENT; references=region
slotstringYesdata type=string; lov=SLOTS
startNewLayoutbooleanYesfalsedata type=boolean
startNewRowbooleanYestruedata type=boolean
Applies whenstartNewLayout = false
rowCssClassesarray of stringsNodata type=string; maxLen=255
columnstringNodata type=string; lov=GRID_COLUMNS
newColumnbooleanYestruedata type=boolean
Applies whenstartNewLayout = false and startNewRow = false
columnSpanstringNodata type=string; lov=GRID_COLUMNS
columnCssClassesarray of stringsNodata type=string; maxLen=255
columnAttributesarray of stringsNodata type=string; maxLen=255
layout {
  sequence: 42
  parentRegion: @component
  slot: value
  startNewLayout: false
  startNewRow: false
  rowCssClasses: [
    value
    value
  ]
  column: value
  newColumn: false
  columnSpan: value
  columnCssClasses: [
    value
    value
  ]
  columnAttributes: [
    value
    value
  ]
}
description
PropertyTypeRequiredDefault ValueDetails
descriptionmultiline stringNodata type=multiline string; maxLen=4000
Enter a description for this Interactive Report.
description {
  description: ```
    value
  ```
}
appearance
PropertyTypeRequiredDefault ValueDetails
templatereferenceNodata type=reference; lov=COMPONENT; references=regionTemplate
templateOptionsarray of stringsNodata type=string; lov=TEMPLATE_OPTIONS
Applies whentemplate is set
cssClassesarray of stringsNodata type=string; maxLen=255
Applies whentemplate is set
Enter classes to add to this component. You may add multiple classes by separating them with spaces.
iconstringNodata type=string; maxLen=255
Applies whentemplate is set
renderComponentsenumYesaboveContentdata type=string; lov=STATIC
Valid values: aboveContent belowContent
appearance {
  template: @component
  templateOptions: [
    value
    value
  ]
  cssClasses: [
    value
    value
  ]
  icon: value
  renderComponents: aboveContent
}
accessibility
PropertyTypeRequiredDefault ValueDetails
useLandmarkbooleanYestruedata type=boolean
Applies whentemplate supports REGION_LANDMARK_ATTRIBUTES
landmarkTypeenumNodata type=string; lov=STATIC
Valid values: banner complementary contentInfo form main navigation region search
Applies whentemplate supports REGION_LANDMARK_ATTRIBUTES and useLandmark = true
landmarkLabelstringNodata type=string; maxLen=255
Applies whentemplate supports REGION_LANDMARK_ATTRIBUTES and useLandmark = true
accessibility {
  useLandmark: false
  landmarkType: banner
  landmarkLabel: value
}
image
PropertyTypeRequiredDefault ValueDetails
fileUrlstringNodata type=string; maxLen=255
Applies whentemplate supports REGION_IMAGEtemplate supports REGION_IMAGE_URL
accessibleDescriptionstringNodata type=string; maxLen=255
Applies whentemplate supports REGION_IMAGE_ALT_TEXT and template supports REGION_IMAGE and fileUrl is settemplate supports REGION_IMAGE_ALT_TEXT and template supports REGION_IMAGE_URL and fileUrl is set
customAttributesstringNodata type=string; maxLen=255
Applies whentemplate supports REGION_IMAGE_ATTRIBUTES and template supports REGION_IMAGE and fileUrl is settemplate supports REGION_IMAGE_ATTRIBUTES and template supports REGION_IMAGE_URL and fileUrl is set
image {
  fileUrl: value
  accessibleDescription: value
  customAttributes: value
}
masterDetail
PropertyTypeRequiredDefault ValueDetails
masterRegionreferenceNodata type=reference; lov=COMPONENT; references=region
masterDetail {
  masterRegion: @component
}
headerAndFooter
PropertyTypeRequiredDefault ValueDetails
headerTextmultiline stringNodata type=multiline string; maxLen=4000
Enter HTML text displayed at the top of the region, before the #BODY# content.
footerTextmultiline stringNodata type=multiline string; maxLen=4000

Enter a region footer that displays directly after the body content, after #BODY# in the region template. You may use shortcuts, as well as the substitution string #TIMING#, to display the time consumed to render the region.

For report regions you can use the following pagination substitution strings:

#ROWS_FETCHED#
Shows the number of rows fetched by the reporting engine (the page size). Use these substitution strings to display customized messages to the user.
#TOTAL_ROWS#
Displays the total number of rows that satisfy a SQL query used for a report. For example, Z in rows X - Y of Z
#FIRST_ROW_FETCHED#
The X in rows X - Y of Z
#LAST_ROW_FETCHED#
The Y in rows X - Y of Z
headerAndFooter {
  headerText: ```html
    value
  ```
  footerText: ```html
    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 region to render page items as read-only. Not selecting a condition causes the page items to render normally.

Note: If you want a page item in this region (for example a search field) to always render as an enterable page item, independent of how this condition evaluates, then you should set the read only condition of that page item to "Never" to overwrite the region setting.

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)
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
  ]
}
security
PropertyTypeRequiredDefault ValueDetails
authorizationSchemeenumNodata type=reference; lov=COMPONENT; references=authorization
Valid values: mustNotBePublicUser
escapeSpecialCharsbooleanYestruedata type=boolean
security {
  authorizationScheme: mustNotBePublicUser
  escapeSpecialChars: false
}
serverCache
PropertyTypeRequiredDefault ValueDetails
cachingenumYesfalsedata type=string; lov=STATIC
Valid values: false true cacheByUser cacheBySession
cacheTimeoutenumYes6Hoursdata type=string; lov=STATIC
Valid values: 10Seconds 1Minute 10Minutes 30Minutes 1Hour 2Hours 3Hours 4Hours 6Hours 12Hours 1Day 2Days 3Days 4Days 1Week 2Weeks 4Weeks 10Weeks 1Year
dependsOnItemsarray of stringsNodata type=string; maxLen=4000; textCase=UPPER
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 for the region to be cached.
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)
serverCache {
  caching: false
  cacheTimeout: "10Seconds"
  dependsOnItems: [
    value
    value
  ]
  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
  ]
}
customization
PropertyTypeRequiredDefault ValueDetails
customizableenumYesfalsedata type=string; lov=STATIC
Valid values: false shownByDefault notShownByDefault
namestringNodata type=string; maxLen=255
Applies whencustomizable in (shownByDefault)customizable in (notShownByDefault)
customization {
  customizable: false
  name: 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
  ```
}
rowSelection
PropertyTypeRequiredDefault ValueDetails
typeenumNodata type=string; lov=STATIC
Valid values: focusOnly singleSelection multipleSelection
Applies whendisplay = report
currentSelectionPageItemstringNodata type=string; maxLen=255; textCase=UPPER
Applies whendisplay = report and type in (singleSelection)display = report and type in (multipleSelection)
selectAllPageItemstringNodata type=string; maxLen=255; textCase=UPPER
Applies whendisplay = report and type = multipleSelection
rowSelection {
  type: focusOnly
  currentSelectionPageItem: value
  selectAllPageItem: value
}
entityTitle
PropertyTypeRequiredDefault ValueDetails
singularstringNodata type=string; maxLen=255
Applies whendisplay = report
pluralstringNodata type=string; maxLen=255
Applies whendisplay = report
entityTitle {
  singular: value
  plural: value
}

APEXlang Example

region sample (
    name: value
    title: value
    type: dataUploadColMapping
    chart {
        type: area
    }
    componentAppearance {
        display: report
        layout: grid
        gridColumns: "2"
        listTemplate: @component
        breadcrumbTemplate: @component
        cssClasses: [
          value
          value
        ]
        templateOptions: [
          value
          value
        ]
        templateType: theme
        template: @component
        customAttributes: value
        showNullValuesAs: value
        selectFirstRow: false
        fixedRowHeight: false
    }
    edit {
        enabled: false
        allowedOperations: [
          add
          update
        ]
        allowedRowOperationsColumn: value
        lostUpdateType: rowValues
        rowVersionColumn: value
        addRowIfEmpty: false
    }
    link {
        linkColumn: singleRowView
        uniquelyIdentifyRowsBy: rowid
        uniqueColumn: value
        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
        }
        linkIcon: ```
          value
        ```
        linkAttributes: value
        authorizationScheme: mustNotBePublicUser
        conditionType: 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
        ]
    }
    map {
        background: default
        standard: openstreetmapPositron
        darkMode: openstreetmapDark
        height: 42
    }
    output {
        layout: @component
        linkText: value
        format: pdf
        viewFileAs: attachment
        formatItem: value
        fileName: value
    }
    page {
        size: letter
        orientation: portrait
        units: inches
        width: 42
        height: 42
        borderWidth: 42
        borderColor: value
    }
    reportLayout {
        numberOfRowsType: staticValue
        numberOfRows: 42
        item: value
    }
    title {
        title: value
        advancedFormatting: false
        column: value
        htmlExpression: ```html
          value
        ```
        cssClasses: [
          value
          value
        ]
    }
    chartAppearance {
        orientation: vertical
        stack: false
        stackLabel: false
        fontFamily: arial
        fontStyle: normal
        fontSize: "8"
        fontColor: value
    }
    card {
        cssClasses: [
          value
          value
        ]
        primaryKeyColumn1: value
        primaryKeyColumn2: value
    }
    source {
        plsqlCode: ```plsql
          value
        ```
        htmlCode: ```html
          value
        ```
        text: ```
          value
        ```
        language: plsql
        plsqlFunctionBody: ```plsql
          value
        ```
        javaScriptFunctionBody: ```javascript-mle
          value
        ```
        location: localDatabase
        remoteServer: @component
        sampleData: employees
        type: tableView
        tableOwner: value
        tableName: value
        includeRowidColumn: false
        whereClause: ```sql
          value
        ```
        graphOwner: value
        graphName: value
        matchClause: ```
          value
        ```
        columnsClause: ```
          value
        ```
        orderByClause: ```sql
          value
        ```
        sqlQuery: ```sql
          value
        ```
        restSource: @component
        jsonDualityView: @component
        jsonSource: @component
        list: @component
        breadcrumb: @component
        filteredRegion: @component
        pageItemsToSubmit: [
          value
          value
        ]
        optimizerHint: value
        useGenericColumnNames: false
        genericColumnCount: 42
    }
    controls {
        navigationBar: none
        navigationBarPosition: start
        options: [
          mousewheelZoom
          rectangleZoom
        ]
    }
    editAuthorization {
        add: mustNotBePublicUser
        update: mustNotBePublicUser
        delete: mustNotBePublicUser
    }
    pageHeader {
        font: helvetica
        fontWeight: normal
        fontSize: 42
        fontColor: value
        alignment: start
        pageHeaderText: ```
          value
        ```
    }
    chartLayout {
        maxWidth: 42
        height: 42
    }
    initialPositionAndZoom {
        getPositionFromBrowser: false
        type: staticValues
        sqlQuery: ```sql
          value
        ```
        geometryColumnDataType: sdoGeometry
        initialLongitudeColumn: value
        initialLatitudeColumn: value
        geometryColumn: value
        geojsonColumn: value
        initialZoomlevelColumn: value
        longitude: value
        latitude: value
        zoomLevel: value
    }
    performance {
        lazyLoading: false
        maxRowsToProcess: 42
    }
    pagination {
        type: showAll
        displayPosition: bottomLeft
        partialPageRefresh: false
        showTotalCount: false
        maxRowsToDisplay: value
        cardsPerPage: 42
        entitiesPerPage: 42
        initialEntitiesCount: 42
    }
    gauge {
        orientation: circular
        showPlotArea: false
        indicatorSize: 42
        innerRadius: 42
        startAngle: 42
        angleExtent: 42
    }
    columnHeadings {
        font: helvetica
        fontWeight: normal
        fontSize: 42
        fontColor: value
        backgroundColor: value
    }
    subtitle {
        advancedFormatting: false
        column: value
        htmlExpression: ```html
          value
        ```
        cssClasses: [
          value
          value
        ]
    }
    messages {
        whenNoDataFound: ```
          value
        ```
        whenMoreDataFound: ```
          value
        ```
        noDataFoundIcon: value
    }
    toolbar {
        show: false
        controls: [
          searchCol
          searchField
        ]
        addButtonLabel: value
    }
    body {
        advancedFormatting: false
        column: value
        htmlExpression: ```html
          value
        ```
        cssClasses: [
          value
          value
        ]
    }
    breakFormatting {
        reportSumLabel: value
        breakColumns: col1
        style: repeatHeadings
        repeatHeadingFormat: ```
          value
        ```
        reportBreakFormat: value
        beforeRow: value
        columnBreakFormat: value
        afterRow: value
    }
    columns {
        font: helvetica
        fontWeight: normal
        fontSize: 42
        fontColor: value
        backgroundColor: value
        widthUnits: percent
    }
    dataCursor {
        cursor: auto
        behavior: auto
        dimOnHover: false
    }
    enableUsersTo {
        savePublicReport: false
        savePublicReportAuthorization: mustNotBePublicUser
        flashback: false
        defineChartView: false
        download: false
    }
    boundingBox {
        type: staticValues
        sqlQuery: ```sql
          value
        ```
        geometryColumnDataType: sdoGeometry
        minLongitude: value
        minLatitude: value
        maxLongitude: value
        maxLatitude: value
        geometryColumn: value
        currentBoundsItem: value
    }
    multiSeriesChartData {
        fillGapsInChartData: false
        sortOrder: valueAsc
        renderGapAsZero: false
    }
    secondaryBody {
        advancedFormatting: false
        column: value
        htmlExpression: ```html
          value
        ```
        cssClasses: [
          value
          value
        ]
    }
    pageFooter {
        font: helvetica
        fontWeight: normal
        fontSize: 42
        fontColor: value
        alignment: start
        pageFooterText: ```
          value
        ```
    }
    download {
        authorization: mustNotBePublicUser
        sendAsEmail: false
        csvSeparator: value
        csvEnclosedBy: value
        csvExportEnabled: false
        filename: value
        supplementalText: ```
          value
        ```
        linkText: value
        formats: [
          csv
          html
        ]
    }
    settings {
        timeAxisType: auto
        zoomAndScroll: false
        zoomDirection: bothAxes
        initialZooming: first
        showHorizontalGrid: auto
        showVerticalGrid: auto
        showRowAxis: false
        axisPosition: top
        pieSelectionEffect: explode
        renderAs: area
    }
    iconAndBadge {
        iconSource: initials
        iconColumn: value
        imageColumn: value
        imageUrl: value
        iconCssClasses: value
        iconPosition: top
        iconDescription: value
        badgeColumn: value
        badgeLabel: value
        badgeCssClasses: [
          value
          value
        ]
    }
    componentAdvanced {
        stripHtml: false
        sortNulls: first
        customSvgStyles: ```
          value
        ```
        oracleTextIndexColumn: value
        emailFromAddress: value
        initJavaScriptFunction: ```javascript-browser
          value
        ```
        regionAlias: value
        reportIdItem: value
        maxRowsPerPageInSelector: value
    }
    singleRowView {
        excludeNullValues: false
        onlyDisplayedColumns: false
    }
    heading {
        type: columnNames
        plsqlFunctionBody: ```plsql
          value
        ```
        fixedTo: none
        fixedReportHeight: 42
        maxReportHeight: 42
    }
    iconView {
        show: false
        custom: false
        customIcon: ```html
          value
        ```
        iconType: imageInUrl
        iconUrl: value
        icon: value
        iconAttributes: value
        linkTarget: {
          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
        }
        linkAttributes: value
        labelColumn: value
        columnsPerRow: "1"
        linkColumn: value
        imageSourceColumn: value
        imageAttributes: value
        htmlAltText: value
        htmlTitleText: value
        customLink: ```
          value
        ```
    }
    media {
        advancedFormatting: false
        htmlExpression: ```html
          value
        ```
        source: imageUrl
        url: value
        urlColumn: value
        blobColumn: value
        position: first
        appearance: square
        sizing: fit
        cssClasses: [
          value
          value
        ]
        imageDescription: value
    }
    legend {
        show: false
        title: value
        position: start
        selector: value
        cssClasses: [
          value
          value
        ]
        hideAndShowBehavior: none
        fontFamily: arial
        fontStyle: normal
        fontSize: "8"
        fontColor: value
    }
    overview {
        show: false
        height: value
    }
    printing {
        enabled: false
    }
    externalProcessing {
        enabled: false
        url: value
        linkText: value
    }
    genAI {
        naturalLanguageSupport: false
        defaultSearchMode: searchModeRow
        reportContext: ```
          value
        ```
        enabled: false
        agent: @component
        service: @component
        systemPrompt: ```
          value
        ```
        welcomeMessage: ```html
          value
        ```
    }
    value {
        pieChartOtherThreshold: 42
        min: 42
        show: false
        valueType: number
        position: auto
        format: dateShort
        decimalPlaces: 42
        currency: value
        pattern: value
        formatScaling: none
    }
    attributes {
        messagesPosition: above
        messageSelector: value
        unitSystem: metric
        unitSystemItem: value
        copyrightNotice: ```html
          value
        ```
    }
    searchBar {
        includeSearchBar: false
        searchField: false
        finderDropDown: false
        reportsSelectList: false
        rowsPerPageSelector: false
        searchButtonLabel: value
    }
    orderBy {
        type: staticValue
        orderByClause: ```sql
          value
        ```
        item: {
          itemName: value
          orderBys: [
            value
            value
          ]
        }
    }
    blobAttributes {
        mimeTypeColumn: value
        lastUpdatedColumn: value
    }
    detailView {
        show: false
        beforeRows: ```html
          value
        ```
        forEachRow: ```html
          value
        ```
        afterRows: ```html
          value
        ```
    }
    actionsMenu {
        includeActionsMenu: false
        filter: false
        selectColumns: false
        rowsPerPage: false
        sort: false
        controlBreak: false
        highlight: false
        compute: false
        aggregate: false
        chart: false
        groupBy: false
        pivot: false
        flashback: false
        saveReport: false
        savePublicReport: false
        savePublicReportAuthorization: mustNotBePublicUser
        reset: false
        help: false
        download: false
        subscription: false
    }
    dataProfile {
        nestedRows: @component
    }
    animation {
        onDisplay: auto
        onDataChange: auto
    }
    restSynchronization {
        useLocalTable: false
    }
    tooltip {
        show: false
        showSeriesName: false
        showGroupName: false
        showValue: false
        showRow: false
        showLabel: false
        showStartDate: false
        showEndDate: false
        showProgress: false
        showBaseline: false
    }
    externalFilterAndOrderBy {
        enabled: false
        filter: ```
          value
        ```
        orderByType: staticValue
        orderBy: ```
          value
        ```
        item: {
          itemName: value
          orderBys: [
            value
            value
          ]
        }
    }
    advanced {
        savedReportMappingIdentifier: value
        htmlDomId: value
        customAttributes: value
        regionImage: value
        imageTagAttributes: value
        staticId: value
        regionDisplaySelector: false
        excludeTitleFromTranslation: false
        schemaOverrideItem: value
    }
    help {
        helpText: ```html
          value
        ```
    }
    localPostProcessing {
        type: whereOrderByClause
        whereClause: ```sql
          value
        ```
        sqlQuery: ```sql
          value
        ```
        language: plsql
        plsqlFunctionBody: ```plsql
          value
        ```
        javaScriptFunctionBody: ```javascript-mle
          value
        ```
        orderByType: staticValue
        orderByClause: ```sql
          value
        ```
        item: {
          itemName: value
          orderBys: [
            value
            value
          ]
        }
        orderByItem: {
          itemName: value
          orderBys: [
            value
            value
          ]
        }
    }
    autoRefresh {
        interval: 42
    }
    remoteCache {
        caching: allUsers
        timeout: ```
          value
        ```
    }
    layout {
        sequence: 42
        parentRegion: @component
        slot: value
        startNewLayout: false
        startNewRow: false
        rowCssClasses: [
          value
          value
        ]
        column: value
        newColumn: false
        columnSpan: value
        columnCssClasses: [
          value
          value
        ]
        columnAttributes: [
          value
          value
        ]
    }
    description {
        description: ```
          value
        ```
    }
    appearance {
        template: @component
        templateOptions: [
          value
          value
        ]
        cssClasses: [
          value
          value
        ]
        icon: value
        renderComponents: aboveContent
    }
    accessibility {
        useLandmark: false
        landmarkType: banner
        landmarkLabel: value
    }
    image {
        fileUrl: value
        accessibleDescription: value
        customAttributes: value
    }
    masterDetail {
        masterRegion: @component
    }
    headerAndFooter {
        headerText: ```html
          value
        ```
        footerText: ```html
          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
        ]
    }
    security {
        authorizationScheme: mustNotBePublicUser
        escapeSpecialChars: false
    }
    serverCache {
        caching: false
        cacheTimeout: "10Seconds"
        dependsOnItems: [
          value
          value
        ]
        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
        ]
    }
    customization {
        customizable: false
        name: value
    }
    config {
        buildOption: @component
    }
    comments {
        comments: ```
          value
        ```
    }
    rowSelection {
        type: focusOnly
        currentSelectionPageItem: value
        selectAllPageItem: value
    }
    entityTitle {
        singular: value
        plural: value
    }
)