region

Parent: page

Plug-in Variants: breadcrumbtype = breadcrumb, calendartype = calendar, cardstype = cards, charttype = chart, classicReporttype = classicReport, classicTreetype = classicTree, columnToggleReporttype = columnToggleReport, dataUploadColMappingtype = dataUploadColMapping, dynamicContenttype = dynamicContent, facetedSearchtype = facetedSearch, formtype = form, helpTexttype = helpText, interactiveGridtype = interactiveGrid, interactiveReporttype = interactiveReport, legacyCalendartype = legacyCalendar, listtype = list, listViewtype = listView, maptype = map, plSqlDynamicContenttype = plSqlDynamicContent, reflowReporttype = reflowReport, regionDisplaySelectortype = regionDisplaySelector, searchtype = search, simpleCharttype = simpleChart, smartFilterstype = smartFilters, staticContenttype = staticContent, svgCharttype = svgChart, tabformtype = tabform, treetype = tree, urltype = url, workflowDiagramtype = workflowDiagram

Children: actiontype = cards, action, axistype = chart and type in (area); type = chart and type in (bar); type = chart and type in (boxPlot); type = chart and type in (bubble); type = chart and type in (combination); type = chart and type in (gantt); type = chart and type in (line); type = chart and type in (lineWithArea); type = chart and type in (polar); type = chart and type in (radar); type = chart and type in (range); type = chart and type in (scatter); type = chart and type in (stock), columntype = interactiveReport, columntype = classicReport, columntype = tabform, columntype supports COLUMNS, columntype supports SOURCE_LOCATION and location is set, columntype = interactiveGrid, columnGrouptype = interactiveReport, columnGrouptype = interactiveGrid, facettype = facetedSearch, facetGrouptype = facetedSearch, filtertype = smartFilters, filterGrouptype = smartFilters, layertype = map, parametertype supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable = false; type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable = false; type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable = false, savedReporttype = interactiveReport, savedReporttype = interactiveGrid, searchSourcetype = search, seriestype = chart

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: breadcrumb calendar cards chart classicReport classicTree columnToggleReport dataUploadColMapping dynamicContent facetedSearch form helpText interactiveGrid interactiveReport legacyCalendar list listView map plSqlDynamicContent reflowReport regionDisplaySelector search simpleChart smartFilters staticContent svgChart tabform tree url workflowDiagram

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
Applies whentype = chart
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
Applies whentype = cards
gridColumnsenumNodata type=string; lov=STATIC
Valid values: 2 3 4 5
Applies whentype = cards and layout = grid
listTemplatereferenceYesdata type=reference; lov=COMPONENT; references=listTemplate
Applies whentype = list
breadcrumbTemplatereferenceYesdata type=reference; lov=COMPONENT; references=breadcrumbTemplate
Applies whentype = breadcrumb
cssClassesarray of stringsNodata type=string; maxLen=255
Applies whentype = cardstype = classicReport and templateType = themetype = tabform and templateType = theme
templateOptionsarray of stringsNodata type=string; lov=TEMPLATE_OPTIONS
Applies whentype = breadcrumb and breadcrumbTemplate is settype = list and listTemplate is settype = classicReport and templateType = theme and template is settype = tabform and templateType = theme and template is set
templateTypeenumYesthemedata type=string; lov=STATIC
Valid values: theme predefined
Applies whentype = classicReporttype = tabform
templatereferenceYesdata type=reference; lov=COMPONENT; references=classicReportTemplate
Applies whentype = classicReport and templateType = themetype = tabform and templateType = theme
templateenumYeshtmldata type=string; lov=STATIC
Valid values: html verticalReport csv xml
Applies whentype = classicReport and templateType = predefinedtype = tabform and templateType = predefined
customAttributesstringNodata type=string; maxLen=2000
Applies whentype = classicReporttype = tabform
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
Applies whentype = interactiveReporttype = classicReporttype = tabformtype = interactiveGrid
selectFirstRowbooleanYestruedata type=boolean
Applies whentype = interactiveGrid
fixedRowHeightbooleanYestruedata type=boolean
Applies whentype = interactiveGrid
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
Applies whentype = interactiveGridtype supports EDITABLE
allowedOperationsarray of enumsNodata type=string; lov=STATIC
Valid values: add update delete
Applies whentype = interactiveGrid and enabled = truetype supports EDITABLE and enabled = true
allowedRowOperationsColumnstringNodata type=string; maxLen=32767
Applies whentype = interactiveGrid and enabled = true and allowedOperations in (update)type = interactiveGrid and enabled = true and allowedOperations in (delete)type supports EDITABLE and enabled = true and allowedOperations in (update)type supports EDITABLE and enabled = true and allowedOperations in (delete)
lostUpdateTypeenumYesrowValuesdata type=string; lov=STATIC
Valid values: rowValues rowVersionColumn
Applies whentype = interactiveGrid and enabled = truetype supports EDITABLE and enabled = true
rowVersionColumnstringYesdata type=string; maxLen=32767
Applies whentype = interactiveGrid and enabled = true and lostUpdateType = rowVersionColumntype supports EDITABLE and enabled = true and lostUpdateType = rowVersionColumn
addRowIfEmptybooleanYestruedata type=boolean
Applies whentype = interactiveGrid and enabled = 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
Applies whentype = interactiveReport
uniquelyIdentifyRowsByenumYesrowiddata type=string; lov=STATIC
Valid values: rowid uniqueColumn
Applies whentype = interactiveReport and linkColumn = singleRowView
uniqueColumnstringYesdata type=string; maxLen=32767
Applies whentype = interactiveReport and linkColumn = singleRowView and uniquelyIdentifyRowsBy = uniqueColumn
targetcomplexYesdata type=complex; maxLen=32767
Applies whentype = interactiveReport and linkColumn = customTarget
linkIconmultiline stringNodata type=multiline string; maxLen=4000
Applies whentype = interactiveReport and linkColumn in (singleRowView)type = interactiveReport and linkColumn in (customTarget)
linkAttributesstringNodata type=string; maxLen=4000
Applies whentype = interactiveReport and linkColumn in (singleRowView)type = interactiveReport and linkColumn in (customTarget)
authorizationSchemeenumNodata type=reference; lov=COMPONENT; references=authorization
Valid values: mustNotBePublicUser
Applies whentype = interactiveReport and linkColumn in (singleRowView)type = interactiveReport and 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 whentype = interactiveReport and linkColumn in (singleRowView)type = interactiveReport and linkColumn in (customTarget)
sqlQuerymultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = interactiveReport and linkColumn in (singleRowView) and conditionType in (rowsReturned)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (noRowsReturned)type = interactiveReport and linkColumn in (customTarget) and conditionType in (rowsReturned)type = interactiveReport and linkColumn in (customTarget) and conditionType in (noRowsReturned)
languageenumYesplsqldata type=string; lov=STATIC
Valid values: sql plsql javaScript-mle
Applies whentype = interactiveReport and linkColumn in (singleRowView) and conditionType = expressiontype = interactiveReport and linkColumn in (customTarget) and conditionType = expression
sqlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = interactiveReport and linkColumn in (singleRowView) and conditionType = expression and language = sqltype = interactiveReport and linkColumn in (customTarget) and conditionType = expression and language = sql
plsqlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = interactiveReport and linkColumn in (singleRowView) and conditionType = expression and language = plsqltype = interactiveReport and linkColumn in (customTarget) and conditionType = expression and language = plsql
javaScriptExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = interactiveReport and linkColumn in (singleRowView) and conditionType = expression and language = javaScript-mletype = interactiveReport and linkColumn in (customTarget) and conditionType = expression and language = javaScript-mle
languageenumYesplsqldata type=string; lov=STATIC
Valid values: plsql javaScript-mle
Applies whentype = interactiveReport and linkColumn in (singleRowView) and conditionType = functionBodytype = interactiveReport and linkColumn in (customTarget) and conditionType = functionBody
plsqlFunctionBodymultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = interactiveReport and linkColumn in (singleRowView) and conditionType = functionBody and language = plsqltype = interactiveReport and linkColumn in (customTarget) and conditionType = functionBody and language = plsql
javaScriptFunctionBodymultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = interactiveReport and linkColumn in (singleRowView) and conditionType = functionBody and language = javaScript-mletype = interactiveReport and linkColumn in (customTarget) and conditionType = functionBody and language = javaScript-mle
valuestringYesdata type=string; maxLen=4000
Applies whentype = interactiveReport and linkColumn in (singleRowView) and conditionType in (request=Value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (request!=Value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (requestIsContainedInValue)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (requestIsNotContainedInValue)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (currentLanguageIsContainedInValue)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (currentLanguageIsNotContainedInValue)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (currentLanguage!=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (currentLanguage=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (cgiEnvDadName=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (cgiEnvDadName!=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (cgiEnvServerName=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (cgiEnvServerName!=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (cgiEnvHttpHost=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (cgiEnvHttpHost!=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (request=Value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (request!=Value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (requestIsContainedInValue)type = interactiveReport and linkColumn in (customTarget) and conditionType in (requestIsNotContainedInValue)type = interactiveReport and linkColumn in (customTarget) and conditionType in (currentLanguageIsContainedInValue)type = interactiveReport and linkColumn in (customTarget) and conditionType in (currentLanguageIsNotContainedInValue)type = interactiveReport and linkColumn in (customTarget) and conditionType in (currentLanguage!=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (currentLanguage=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (cgiEnvDadName=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (cgiEnvDadName!=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (cgiEnvServerName=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (cgiEnvServerName!=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (cgiEnvHttpHost=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (cgiEnvHttpHost!=value)
itemstringYesdata type=string; maxLen=4000; textCase=UPPER
Applies whentype = interactiveReport and linkColumn in (singleRowView) and conditionType in (item=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (item!=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (VALUE_OF_ITEM_IN_COND_1_EQ_COND_2)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (VALUE_OF_ITEM_IN_COND_1_NOT_EQ_COND_2)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemIsNull)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemIsNotNull)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemIsZero)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemIsNotZero)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemIsNullOrZero)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemIsNotNullAndNotZero)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemContainsNoSpaces)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemIsNumeric)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemIsNotNumeric)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemIsAlphanumeric)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemIsInColonDelimitedList)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemIsNotInColonDelimitedList)type = interactiveReport and linkColumn in (customTarget) and conditionType in (item=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (item!=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (VALUE_OF_ITEM_IN_COND_1_EQ_COND_2)type = interactiveReport and linkColumn in (customTarget) and conditionType in (VALUE_OF_ITEM_IN_COND_1_NOT_EQ_COND_2)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemIsNull)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemIsNotNull)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemIsZero)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemIsNotZero)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemIsNullOrZero)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemIsNotNullAndNotZero)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemContainsNoSpaces)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemIsNumeric)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemIsNotNumeric)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemIsAlphanumeric)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemIsInColonDelimitedList)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemIsNotInColonDelimitedList)
preferencestringYesdata type=string; maxLen=4000; textCase=UPPER
Applies whentype = interactiveReport and linkColumn in (singleRowView) and conditionType in (userPreference=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (userPreference!=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (userPreference=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (userPreference!=value)
pageintegerYesdata type=integer; maxLen=4000
Applies whentype = interactiveReport and linkColumn in (singleRowView) and conditionType in (currentPage=page)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (currentPage!=page)type = interactiveReport and linkColumn in (customTarget) and conditionType in (currentPage=page)type = interactiveReport and linkColumn in (customTarget) and conditionType in (currentPage!=page)
pagesarray of integersYesdata type=integer; maxLen=4000
Applies whentype = interactiveReport and linkColumn in (singleRowView) and conditionType in (currentPageInList)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (currentPageNotInList)type = interactiveReport and linkColumn in (customTarget) and conditionType in (currentPageInList)type = interactiveReport and linkColumn in (customTarget) and conditionType in (currentPageNotInList)
textstringYesdata type=string; maxLen=4000
Applies whentype = interactiveReport and linkColumn in (singleRowView) and conditionType in (textIsContainedInItem)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (textIsContainedInValue)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (textIsNotContainedInValue)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (text=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (text!=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (textIsContainedInItem)type = interactiveReport and linkColumn in (customTarget) and conditionType in (textIsContainedInValue)type = interactiveReport and linkColumn in (customTarget) and conditionType in (textIsNotContainedInValue)type = interactiveReport and linkColumn in (customTarget) and conditionType in (text=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (text!=value)
valuestringYesdata type=string; maxLen=4000
Applies whentype = interactiveReport and linkColumn in (singleRowView) and conditionType in (item=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (item!=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (VALUE_OF_ITEM_IN_COND_1_EQ_COND_2)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (VALUE_OF_ITEM_IN_COND_1_NOT_EQ_COND_2)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (userPreference=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (userPreference!=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (item=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (item!=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (VALUE_OF_ITEM_IN_COND_1_EQ_COND_2)type = interactiveReport and linkColumn in (customTarget) and conditionType in (VALUE_OF_ITEM_IN_COND_1_NOT_EQ_COND_2)type = interactiveReport and linkColumn in (customTarget) and conditionType in (userPreference=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (userPreference!=value)
listarray of stringsYesdata type=string; maxLen=4000
Applies whentype = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemIsInColonDelimitedList)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemIsNotInColonDelimitedList)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemIsInColonDelimitedList)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemIsNotInColonDelimitedList)
itemstringYesdata type=string; maxLen=4000; textCase=UPPER
Applies whentype = interactiveReport and linkColumn in (singleRowView) and conditionType = textIsContainedInItemtype = interactiveReport and linkColumn in (customTarget) and conditionType = textIsContainedInItem
valuestringYesdata type=string; maxLen=4000
Applies whentype = interactiveReport and linkColumn in (singleRowView) and conditionType in (textIsContainedInValue)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (textIsNotContainedInValue)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (text=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (text!=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (textIsContainedInValue)type = interactiveReport and linkColumn in (customTarget) and conditionType in (textIsNotContainedInValue)type = interactiveReport and linkColumn in (customTarget) and conditionType in (text=value)type = interactiveReport and 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
Applies whentype = map
standardenumYesopenstreetmapPositrondata type=string; lov=STATIC
Valid values: openstreetmapPositron openstreetmapDark openstreetmapBright oracleWorldMap oracleBiWorldMap
Applies whentype = map and background = builtIn
darkModeenumNodata type=string; lov=STATIC
Valid values: openstreetmapDark openstreetmapPositron openstreetmapBright oracleWorldMap oracleBiWorldMap
Applies whentype = map and background = builtIn
standardreferenceYesdata type=reference; lov=COMPONENT; references=mapBackground
Applies whentype = map and background = sharedComponent
darkModereferenceNodata type=reference; lov=COMPONENT; references=mapBackground
Applies whentype = map and background = sharedComponent
heightnumberYes640data type=number; maxLen=22
Applies whentype = map
map {
  background: default
  standard: openstreetmapPositron
  darkMode: openstreetmapDark
  height: 42
}
output
PropertyTypeRequiredDefault ValueDetails
layoutreferenceNodata type=reference; lov=COMPONENT; references=reportLayout
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = true
linkTextstringNodata type=string; maxLen=255
Applies whentype = classicReport and enabled = truetype = tabform and enabled = true
formatenumNodata type=string; lov=STATIC
Valid values: pdf word excel html xml
Applies whentype = classicReport and enabled = truetype = tabform and enabled = true
viewFileAsenumYesattachmentdata type=string; lov=STATIC
Valid values: attachment inline
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = true
formatItemstringYesdata type=string; maxLen=255; textCase=UPPER
Applies whentype = classicReport and enabled = truetype = tabform and enabled = true
fileNamestringNodata type=string; maxLen=255
Applies whentype = classicReport and enabled = truetype = tabform and enabled = 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 whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf)
orientationenumYeslandscapedata type=string; lov=STATIC
Valid values: portrait landscape
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf)
unitsenumYesinchesdata type=string; lov=STATIC
Valid values: inches millimeters centimeters points
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf)
widthnumberYes11data type=number; maxLen=22
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf)
heightnumberYes8.5data type=number; maxLen=22
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf)
borderWidthnumberNodata type=number; maxLen=255
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf)
borderColorstringNodata type=string; maxLen=255
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and 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
Applies whentype = classicReporttype = tabformtype supports FETCHED_ROWS
numberOfRowsintegerYes15data type=integer; maxLen=32767
Applies whentype = classicReport and numberOfRowsType = staticValuetype = tabform and numberOfRowsType = staticValuetype supports FETCHED_ROWS and numberOfRowsType = staticValue
itemstringYesdata type=string; maxLen=255; textCase=UPPER
Applies whentype = classicReport and numberOfRowsType = itemValuetype = tabform and numberOfRowsType = itemValuetype supports FETCHED_ROWS and numberOfRowsType = itemValue
reportLayout {
  numberOfRowsType: staticValue
  numberOfRows: 42
  item: value
}
title
PropertyTypeRequiredDefault ValueDetails
titlestringNodata type=string; maxLen=255
Applies whentype = chart
advancedFormattingbooleanYesfalsedata type=boolean
Applies whentype = cards
columnstringNodata type=string; maxLen=32767
Applies whentype = cards and advancedFormatting = false
htmlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = cards and advancedFormatting = true
cssClassesarray of stringsNodata type=string; maxLen=255
Applies whentype = cards and advancedFormatting = 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 = chart and type in (area)type = chart and type in (bar)type = chart and type in (combination)type = chart and type in (funnel)type = chart and type in (line)type = chart and type in (lineWithArea)type = chart and type in (boxPlot)type = chart and type in (range)
stackbooleanYesoffdata type=boolean
Applies whentype = chart and type in (area)type = chart and type in (bar)type = chart and type in (line)type = chart and type in (lineWithArea)type = chart and type in (combination)type = chart and type in (polar)type = chart and type in (radar)
stackLabelbooleanYesoffdata type=boolean
Applies whentype = chart and type = bar and type in (area) and stack = ontype = chart and type = bar and type in (bar) and stack = ontype = chart and type = bar and type in (line) and stack = ontype = chart and type = bar and type in (lineWithArea) and stack = ontype = chart and type = bar and type in (combination) and stack = ontype = chart and type = bar and type in (polar) and stack = ontype = chart and type = 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 = chart and type = bar and type in (area) and stack = on and stackLabel = ontype = chart and type = bar and type in (bar) and stack = on and stackLabel = ontype = chart and type = bar and type in (line) and stack = on and stackLabel = ontype = chart and type = bar and type in (lineWithArea) and stack = on and stackLabel = ontype = chart and type = bar and type in (combination) and stack = on and stackLabel = ontype = chart and type = bar and type in (polar) and stack = on and stackLabel = ontype = chart and type = bar and type in (radar) and stack = on and stackLabel = on
fontStyleenumNodata type=string; lov=STATIC
Valid values: normal italic oblique
Applies whentype = chart and type = bar and type in (area) and stack = on and stackLabel = ontype = chart and type = bar and type in (bar) and stack = on and stackLabel = ontype = chart and type = bar and type in (line) and stack = on and stackLabel = ontype = chart and type = bar and type in (lineWithArea) and stack = on and stackLabel = ontype = chart and type = bar and type in (combination) and stack = on and stackLabel = ontype = chart and type = bar and type in (polar) and stack = on and stackLabel = ontype = chart and type = 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 = chart and type = bar and type in (area) and stack = on and stackLabel = ontype = chart and type = bar and type in (bar) and stack = on and stackLabel = ontype = chart and type = bar and type in (line) and stack = on and stackLabel = ontype = chart and type = bar and type in (lineWithArea) and stack = on and stackLabel = ontype = chart and type = bar and type in (combination) and stack = on and stackLabel = ontype = chart and type = bar and type in (polar) and stack = on and stackLabel = ontype = chart and type = bar and type in (radar) and stack = on and stackLabel = on
fontColorstringNodata type=string; maxLen=255
Applies whentype = chart and type = bar and type in (area) and stack = on and stackLabel = ontype = chart and type = bar and type in (bar) and stack = on and stackLabel = ontype = chart and type = bar and type in (line) and stack = on and stackLabel = ontype = chart and type = bar and type in (lineWithArea) and stack = on and stackLabel = ontype = chart and type = bar and type in (combination) and stack = on and stackLabel = ontype = chart and type = bar and type in (polar) and stack = on and stackLabel = ontype = chart and type = 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
Applies whentype = cards
primaryKeyColumn1stringNodata type=string; maxLen=32767
Applies whentype = cards
primaryKeyColumn2stringNodata type=string; maxLen=32767
Applies whentype = cards and primaryKeyColumn1 is set
card {
  cssClasses: [
    value
    value
  ]
  primaryKeyColumn1: value
  primaryKeyColumn2: value
}
source
PropertyTypeRequiredDefault ValueDetails
sqlQuerymultiline stringNodata type=multiline string; maxLen=32767
Applies whentype supports SOURCE_SQL
plsqlCodemultiline stringNodata type=multiline string; maxLen=32767
Applies whentype supports SOURCE_PLSQL
Enter the PL/SQL code to generate the HTML output.
plsqlFunctionBodymultiline stringNodata type=multiline string; maxLen=32767
Applies whentype supports SOURCE_PLSQL_FUNCTION
htmlCodemultiline stringNodata type=multiline string; maxLen=32767
Applies whentype supports SOURCE_HTML
textmultiline stringNodata type=multiline string; maxLen=32767
Applies whentype supports SOURCE_PLAIN
languageenumYesplsqldata type=string; lov=STATIC
Valid values: plsql javaScript-mle
Applies whentype = dynamicContent
plsqlFunctionBodymultiline stringYesdata type=multiline string; maxLen=32767
Applies whentype = dynamicContent and language = plsql
javaScriptFunctionBodymultiline stringYesdata type=multiline string; maxLen=32767
Applies whentype = dynamicContent and language = javaScript-mle
locationenumNolocalDatabasedata type=string; lov=STATIC
Valid values: localDatabase restEnabledSql restSource jsonDualityView jsonSource sampleData
Applies whentype supports SOURCE_LOCATION
remoteServerreferenceYesdata type=reference; lov=COMPONENT; references=restEnabledSqlDatabase
Applies whentype supports SOURCE_LOCATION and location = restEnabledSql
sampleDataenumYesdata type=string; lov=STATIC
Valid values: employees tasks products projects
Applies whentype supports SOURCE_LOCATION and location = sampleData
typeenumYestableViewdata type=string; lov=STATIC
Valid values: tableView sqlQuery functionBody propertyGraph
Applies whentype supports SOURCE_LOCATION and location in (localDatabase)type supports SOURCE_LOCATION and location in (restEnabledSql)
tableOwnerstringNodata type=string; maxLen=32767
Applies whentype supports SOURCE_LOCATION and location in (localDatabase) and type = tableViewtype supports SOURCE_LOCATION and location in (restEnabledSql) and type = tableView
tableNamestringYesdata type=string; maxLen=128
Applies whentype supports SOURCE_LOCATION and location in (localDatabase) and type = tableViewtype supports SOURCE_LOCATION and location in (restEnabledSql) and type = tableView
includeRowidColumnbooleanYesfalsedata type=boolean
Applies whentype supports SOURCE_LOCATION and location in (localDatabase) and type = tableView and location = restEnabledSql and remoteServer supports IS_ORACLEtype supports SOURCE_LOCATION and location in (restEnabledSql) and type = tableView and location = restEnabledSql and remoteServer supports IS_ORACLE
whereClausemultiline stringNodata type=multiline string; maxLen=4000
Applies whentype supports SOURCE_LOCATION and location in (localDatabase) and type = tableViewtype supports SOURCE_LOCATION and location in (restEnabledSql) and type = tableView
graphOwnerstringNodata type=string; maxLen=32767
Applies whentype supports SOURCE_LOCATION and location in (localDatabase) and type = propertyGraphtype supports SOURCE_LOCATION and location in (restEnabledSql) and type = propertyGraph
graphNamestringYesdata type=string; maxLen=32767
Applies whentype supports SOURCE_LOCATION and location in (localDatabase) and type = propertyGraphtype supports SOURCE_LOCATION and location in (restEnabledSql) and type = propertyGraph
matchClausemultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype supports SOURCE_LOCATION and location in (localDatabase) and type = propertyGraphtype supports SOURCE_LOCATION and location in (restEnabledSql) and type = propertyGraph
columnsClausemultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype supports SOURCE_LOCATION and location in (localDatabase) and type = propertyGraphtype supports SOURCE_LOCATION and location in (restEnabledSql) and type = propertyGraph
whereClausemultiline stringNodata type=multiline string; maxLen=4000
Applies whentype supports SOURCE_LOCATION and location in (localDatabase) and type = propertyGraphtype supports SOURCE_LOCATION and location in (restEnabledSql) and type = propertyGraph
orderByClausemultiline stringNodata type=multiline string; maxLen=255
Applies whentype supports SOURCE_LOCATION and location in (localDatabase) and type = tableView and type in (interactiveGrid)type supports SOURCE_LOCATION and location in (localDatabase) and type = tableView and type in (interactiveReport)type supports SOURCE_LOCATION and location in (localDatabase) and type = tableView and type in (map)type supports SOURCE_LOCATION and location in (localDatabase) and type = tableView and type in (form)type supports SOURCE_LOCATION and location in (restEnabledSql) and type = tableView and type in (interactiveGrid)type supports SOURCE_LOCATION and location in (restEnabledSql) and type = tableView and type in (interactiveReport)type supports SOURCE_LOCATION and location in (restEnabledSql) and type = tableView and type in (map)type supports SOURCE_LOCATION and location in (restEnabledSql) and type = tableView and type in (form)
orderByClausemultiline stringNodata type=multiline string; maxLen=255
Applies whentype supports SOURCE_LOCATION and location in (localDatabase) and type = propertyGraph and type in (interactiveGrid)type supports SOURCE_LOCATION and location in (localDatabase) and type = propertyGraph and type in (interactiveReport)type supports SOURCE_LOCATION and location in (localDatabase) and type = propertyGraph and type in (map)type supports SOURCE_LOCATION and location in (localDatabase) and type = propertyGraph and type in (form)type supports SOURCE_LOCATION and location in (restEnabledSql) and type = propertyGraph and type in (interactiveGrid)type supports SOURCE_LOCATION and location in (restEnabledSql) and type = propertyGraph and type in (interactiveReport)type supports SOURCE_LOCATION and location in (restEnabledSql) and type = propertyGraph and type in (map)type supports SOURCE_LOCATION and location in (restEnabledSql) and type = propertyGraph and type in (form)
sqlQuerymultiline stringYesdata type=multiline string; maxLen=32767
Applies whentype supports SOURCE_LOCATION and location in (localDatabase) and type = sqlQuerytype supports SOURCE_LOCATION and location in (restEnabledSql) and type = sqlQuery
languageenumYesplsqldata type=string; lov=STATIC
Valid values: plsql javaScript-mle
Applies whentype supports SOURCE_LOCATION and location in (localDatabase) and type = functionBodytype supports SOURCE_LOCATION and location in (restEnabledSql) and type = functionBody
plsqlFunctionBodymultiline stringYesdata type=multiline string; maxLen=32767
Applies whentype supports SOURCE_LOCATION and location in (localDatabase) and type = functionBody and language = plsqltype supports SOURCE_LOCATION and location in (restEnabledSql) and type = functionBody and language = plsql
javaScriptFunctionBodymultiline stringYesdata type=multiline string; maxLen=32767
Applies whentype supports SOURCE_LOCATION and location in (localDatabase) and type = functionBody and language = javaScript-mletype supports SOURCE_LOCATION and location in (restEnabledSql) and type = functionBody and language = javaScript-mle
restSourcereferenceYesdata type=reference; lov=COMPONENT; references=restDataSource
Applies whentype supports SOURCE_LOCATION and location = restSource
jsonDualityViewreferenceYesdata type=reference; lov=COMPONENT; references=jsonDualityView
Applies whentype supports SOURCE_LOCATION and location = jsonDualityView
jsonSourcereferenceYesdata type=reference; lov=COMPONENT; references=jsonSource
Applies whentype supports SOURCE_LOCATION and location = jsonSource
listreferenceYesdata type=reference; lov=COMPONENT; references=list
Applies whentype in (list)
breadcrumbreferenceYesdata type=reference; lov=COMPONENT; references=breadcrumb
Applies whentype in (breadcrumb)
filteredRegionreferenceYesdata type=reference; lov=COMPONENT; references=region
Applies whentype in (facetedSearch)type in (smartFilters)
pageItemsToSubmitarray of stringsNodata type=string; maxLen=4000; textCase=UPPER
Applies whentype supports AJAX_ITEMS_TO_SUBMIT
optimizerHintstringNodata type=string; maxLen=255
Applies whentype supports SOURCE_LOCATION and location in (localDatabase)type supports SOURCE_LOCATION and location in (restEnabledSql)type supports SOURCE_LOCATION and location in (restSource)type supports SOURCE_LOCATION and location in (jsonDualityView)type supports SOURCE_LOCATION and location in (jsonSource)
useGenericColumnNamesbooleanYesDERIVED_REPORT_COLUMNSdata type=boolean
Applies whentype = classicReport and type supports SOURCE_LOCATION and location in (localDatabase) and type = functionBodytype = classicReport and type supports SOURCE_LOCATION and location in (restEnabledSql) and type = functionBody
genericColumnCountintegerYesdata type=integer; maxLen=3
Applies whentype = classicReport and type supports SOURCE_LOCATION and location in (localDatabase) and type = functionBody and useGenericColumnNames = GENERIC_REPORT_COLUMNStype = classicReport and type supports SOURCE_LOCATION and location 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
Applies whentype = map
navigationBarPositionenumYesenddata type=string; lov=STATIC
Valid values: start end
Applies whentype = map
optionsarray of enumsNodata type=string; lov=STATIC
Valid values: mousewheelZoom rectangleZoom scaleBar overviewMap infiniteMap getBrowserLocation circleTool distanceTool
Applies whentype = map
controls {
  navigationBar: none
  navigationBarPosition: start
  options: [
    mousewheelZoom
    rectangleZoom
  ]
}
editAuthorization
PropertyTypeRequiredDefault ValueDetails
addenumNodata type=reference; lov=COMPONENT; references=authorization
Valid values: mustNotBePublicUser
Applies whentype = interactiveGrid and enabled = true and allowedOperations = addtype supports EDITABLE and enabled = true and allowedOperations = add
updateenumNodata type=reference; lov=COMPONENT; references=authorization
Valid values: mustNotBePublicUser
Applies whentype = interactiveGrid and enabled = true and allowedOperations = updatetype supports EDITABLE and enabled = true and allowedOperations = update
deleteenumNodata type=reference; lov=COMPONENT; references=authorization
Valid values: mustNotBePublicUser
Applies whentype = interactiveGrid and enabled = true and allowedOperations = deletetype supports EDITABLE and enabled = 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 whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf)
fontWeightenumYesnormaldata type=string; lov=STATIC
Valid values: normal bold
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf)
fontSizeintegerYes12data type=integer; maxLen=32767
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf)
fontColorstringYes#000000data type=string; maxLen=255
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf)
alignmentenumYescenterdata type=string; lov=STATIC
Valid values: start center end
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf)
pageHeaderTextmultiline stringNodata type=multiline string; maxLen=4000
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and 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
Applies whentype = chart
heightintegerNodata type=integer; maxLen=32767
Applies whentype = chart
chartLayout {
  maxWidth: 42
  height: 42
}
initialPositionAndZoom
PropertyTypeRequiredDefault ValueDetails
getPositionFromBrowserbooleanYesfalsedata type=boolean
Applies whentype = map and options = getBrowserLocation
typeenumYesbasedOnSpatialResultsdata type=string; lov=STATIC
Valid values: staticValues sqlQuery basedOnSpatialResults
Applies whentype = map
sqlQuerymultiline stringYesdata type=multiline string; maxLen=32767
Applies whentype = map and type = sqlQuery
geometryColumnDataTypeenumYesdata type=string; lov=STATIC
Valid values: sdoGeometry geojson longitudeLatitude
Applies whentype = map and type = sqlQuery
initialLongitudeColumnstringYesdata type=string; maxLen=32767
Applies whentype = map and type = sqlQuery and geometryColumnDataType = longitudeLatitude
initialLatitudeColumnstringYesdata type=string; maxLen=32767
Applies whentype = map and type = sqlQuery and geometryColumnDataType = longitudeLatitude
geometryColumnstringYesdata type=string; maxLen=32767
Applies whentype = map and type = sqlQuery and geometryColumnDataType = sdoGeometry
geojsonColumnstringYesdata type=string; maxLen=32767
Applies whentype = map and type = sqlQuery and geometryColumnDataType = geojson
initialZoomlevelColumnstringNodata type=string; maxLen=32767
Applies whentype = map and type = sqlQuery
longitudestringYesdata type=string; maxLen=32767
Applies whentype = map and type = staticValues
latitudestringYesdata type=string; maxLen=32767
Applies whentype = map and type = staticValues
zoomLevelstringNodata type=string; maxLen=32767
Applies whentype = map and type in (staticValues)type = map and 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 whentype = interactiveReporttype = charttype = interactiveGridtype = cardstype = maptype = classicReport and partialPageRefresh = truetype = tabform and partialPageRefresh = truetype supports LAZY_LOADING and type supports SOURCE_LOCATION and location is set
maxRowsToProcessintegerNodata type=integer; maxLen=32767
Applies whentype = classicReporttype = tabformtype = interactiveReport
lazyLoadingbooleanYesfalsedata type=boolean
Applies whentype supports LAZY_LOADING_ALWAYS
performance {
  lazyLoading: false
  maxRowsToProcess: 42
}
pagination
PropertyTypeRequiredDefault ValueDetails
typeenumYesnextAndPreviousLinksdata type=string; lov=STATIC
Valid values: showAll rowRangesXToYNoPagination rowRangesXToYOfZNoPagination rowRangesXToYOfZWithPagination setPaginationLinks setPaginationSelectList setPaginationSearchEngine externalPaginationButtons nextAndPreviousLinks
Applies whentype = classicReporttype = tabform
displayPositionenumYesbottomRightdata type=string; lov=STATIC
Valid values: bottomLeft bottomRight topLeft topRight topAndBottomLeft topAndBottomRight
Applies whentype = interactiveReport and type is settype = classicReporttype = tabform
partialPageRefreshbooleanYestruedata type=boolean
Applies whentype = classicReporttype = tabform
typeenumYesscrolldata type=string; lov=STATIC
Valid values: page scroll
Applies whentype = interactiveGridtype = cardsdisplay = report
showTotalCountbooleanYestruedata type=boolean
Applies whentype = interactiveGridtype = cardsdisplay = report
typeenumNodata type=string; lov=STATIC
Valid values: rowRangesXToYOfZ rowRangesXToY
Applies whentype = interactiveReport
maxRowsToDisplaystringNodata type=string; maxLen=32767
Applies whentype = interactiveReport
cardsPerPageintegerYes15data type=integer; maxLen=32767
Applies whentype = cards and type = 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 = chart and type = statusMeterGauge
showPlotAreabooleanYesondata type=boolean
Applies whentype = chart and type = statusMeterGauge
indicatorSizenumberYes1data type=number; maxLen=22
Applies whentype = chart and type = statusMeterGauge
innerRadiusnumberYes0.7data type=number; maxLen=22
Applies whentype = chart and type = statusMeterGauge and orientation = circular
startAnglenumberYes90data type=number; maxLen=22
Applies whentype = chart and type = statusMeterGauge and orientation = circular
angleExtentnumberYes360data type=number; maxLen=22
Applies whentype = chart and type = 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 whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf)
fontWeightenumYesbolddata type=string; lov=STATIC
Valid values: normal bold
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf)
fontSizeintegerYes10data type=integer; maxLen=32767
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf)
fontColorstringYes#000000data type=string; maxLen=255
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf)
backgroundColorstringYes#EEEEEEdata type=string; maxLen=255
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf)
columnHeadings {
  font: helvetica
  fontWeight: normal
  fontSize: 42
  fontColor: value
  backgroundColor: value
}
subtitle
PropertyTypeRequiredDefault ValueDetails
advancedFormattingbooleanYesfalsedata type=boolean
Applies whentype = cards
columnstringNodata type=string; maxLen=32767
Applies whentype = cards and advancedFormatting = false
htmlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = cards and advancedFormatting = true
cssClassesarray of stringsNodata type=string; maxLen=255
Applies whentype = cards and advancedFormatting = false
subtitle {
  advancedFormatting: false
  column: value
  htmlExpression: ```html
    value
  ```
  cssClasses: [
    value
    value
  ]
}
messages
PropertyTypeRequiredDefault ValueDetails
whenNoDataFoundmultiline stringNodata type=multiline string; maxLen=4000
Applies whentype = interactiveReporttype = classicReporttype = tabformtype = charttype = interactiveGridtype = cardstype supports NO_DATA_FOUND_MESSAGE and display = report
whenMoreDataFoundmultiline stringNodata type=multiline string; maxLen=4000
Applies whentype = interactiveReporttype = classicReporttype = tabform
noDataFoundIconstringNodata type=string; maxLen=4000
Applies whentype = cards and whenNoDataFound is settype supports NO_DATA_FOUND_ICON and type supports NO_DATA_FOUND_MESSAGE and display = report and whenNoDataFound is set
messages {
  whenNoDataFound: ```
    value
  ```
  whenMoreDataFound: ```
    value
  ```
  noDataFoundIcon: value
}
toolbar
PropertyTypeRequiredDefault ValueDetails
showbooleanYestruedata type=boolean
Applies whentype = interactiveGrid
controlsarray of enumsNodata type=string; lov=STATIC
Valid values: searchCol searchField actionsMenu resetButton saveButton
Applies whentype = interactiveGrid and show = true
addButtonLabelstringNodata type=string; maxLen=255
Applies whentype = interactiveGrid and show = true and enabled = true and allowedOperations = add
toolbar {
  show: false
  controls: [
    searchCol
    searchField
  ]
  addButtonLabel: value
}
body
PropertyTypeRequiredDefault ValueDetails
advancedFormattingbooleanYesfalsedata type=boolean
Applies whentype = cards
columnstringNodata type=string; maxLen=32767
Applies whentype = cards and advancedFormatting = false
htmlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = cards and advancedFormatting = true
cssClassesarray of stringsNodata type=string; maxLen=255
Applies whentype = cards and advancedFormatting = false
body {
  advancedFormatting: false
  column: value
  htmlExpression: ```html
    value
  ```
  cssClasses: [
    value
    value
  ]
}
breakFormatting
PropertyTypeRequiredDefault ValueDetails
reportSumLabelstringNodata type=string; maxLen=255
Applies whentype = classicReporttype = tabform
breakColumnsenumNodata type=string; lov=STATIC
Valid values: col1 cols1-2 cols1-3
Applies whentype = classicReporttype = tabform
styleenumYesdefaultdata type=string; lov=STATIC
Valid values: repeatHeadings default
Applies whentype = classicReport and breakColumns is settype = tabform and breakColumns is set
repeatHeadingFormatmultiline stringNodata type=multiline string; maxLen=4000
Applies whentype = classicReport and breakColumns is set and style = repeatHeadingstype = tabform and breakColumns is set and style = repeatHeadings
reportBreakFormatstringNodata type=string; maxLen=2000
Applies whentype = classicReport and breakColumns is settype = tabform and breakColumns is set
beforeRowstringNodata type=string; maxLen=2000
Applies whentype = classicReport and breakColumns is settype = tabform and breakColumns is set
columnBreakFormatstringNodata type=string; maxLen=2000
Applies whentype = classicReport and breakColumns is settype = tabform and breakColumns is set
afterRowstringNodata type=string; maxLen=2000
Applies whentype = classicReport and breakColumns is settype = tabform and breakColumns 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 whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf)
fontWeightenumYesnormaldata type=string; lov=STATIC
Valid values: normal bold
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf)
fontSizeintegerYes10data type=integer; maxLen=32767
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf)
fontColorstringYes#000000data type=string; maxLen=255
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf)
backgroundColorstringYes#FFFFFFdata type=string; maxLen=255
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf)
widthUnitsenumYespercentdata type=string; lov=STATIC
Valid values: percent point
Applies whentype = classicReport and enabled = truetype = tabform and enabled = 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
Applies whentype = chart
behaviorenumYesautodata type=string; lov=STATIC
Valid values: auto smooth snap
Applies whentype = chart and cursor in (auto)type = chart and cursor in (true)
dimOnHoverbooleanYesdimdata type=boolean
Applies whentype = chart
dataCursor {
  cursor: auto
  behavior: auto
  dimOnHover: false
}
enableUsersTo
PropertyTypeRequiredDefault ValueDetails
savePublicReportbooleanYesfalsedata type=boolean
Applies whentype = interactiveGrid
savePublicReportAuthorizationenumNodata type=reference; lov=COMPONENT; references=authorization
Valid values: mustNotBePublicUser
Applies whentype = interactiveGrid and savePublicReport = true
flashbackbooleanYestruedata type=boolean
Applies whentype = interactiveGrid
defineChartViewbooleanYestruedata type=boolean
Applies whentype = interactiveGrid
downloadbooleanYestruedata type=boolean
Applies whentype = interactiveGrid
enableUsersTo {
  savePublicReport: false
  savePublicReportAuthorization: mustNotBePublicUser
  flashback: false
  defineChartView: false
  download: false
}
boundingBox
PropertyTypeRequiredDefault ValueDetails
typeenumNodata type=string; lov=STATIC
Valid values: staticValues sqlQuery
Applies whentype = map
sqlQuerymultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = map and type = sqlQuery
geometryColumnDataTypeenumYessdoGeometrydata type=string; lov=STATIC
Valid values: sdoGeometry longitudeLatitude
Applies whentype = map and type = sqlQuery
minLongitudestringYesdata type=string; maxLen=32767
Applies whentype = map and type = sqlQuery and geometryColumnDataType = longitudeLatitude
minLatitudestringYesdata type=string; maxLen=32767
Applies whentype = map and type = sqlQuery and geometryColumnDataType = longitudeLatitude
maxLongitudestringYesdata type=string; maxLen=32767
Applies whentype = map and type = sqlQuery and geometryColumnDataType = longitudeLatitude
maxLatitudestringYesdata type=string; maxLen=32767
Applies whentype = map and type = sqlQuery and geometryColumnDataType = longitudeLatitude
geometryColumnstringYesdata type=string; maxLen=32767
Applies whentype = map and type = sqlQuery and geometryColumnDataType = sdoGeometry
minLongitudestringYesdata type=string; maxLen=128
Applies whentype = map and type = staticValues
minLatitudestringYesdata type=string; maxLen=128
Applies whentype = map and type = staticValues
maxLongitudestringYesdata type=string; maxLen=128
Applies whentype = map and type = staticValues
maxLatitudestringYesdata type=string; maxLen=128
Applies whentype = map and type = staticValues
currentBoundsItemstringNodata type=string; maxLen=32767; textCase=UPPER
Applies whentype = map
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
Applies whentype = chart
sortOrderenumYeslabelAscdata type=string; lov=STATIC
Valid values: valueAsc valueDesc labelAsc labelDesc
Applies whentype = chart and fillGapsInChartData = true
renderGapAsZerobooleanYestruedata type=boolean
Applies whentype = chart and type in (line) and fillGapsInChartData = truetype = chart and type in (lineWithArea) and fillGapsInChartData = truetype = chart and type in (area) and fillGapsInChartData = truetype = chart and type in (scatter) and fillGapsInChartData = truetype = chart and type in (bar) and fillGapsInChartData = truetype = chart and type in (combination) and fillGapsInChartData = true
multiSeriesChartData {
  fillGapsInChartData: false
  sortOrder: valueAsc
  renderGapAsZero: false
}
secondaryBody
PropertyTypeRequiredDefault ValueDetails
advancedFormattingbooleanYesfalsedata type=boolean
Applies whentype = cards
columnstringNodata type=string; maxLen=32767
Applies whentype = cards and advancedFormatting = false
htmlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = cards and advancedFormatting = true
cssClassesarray of stringsNodata type=string; maxLen=255
Applies whentype = cards and advancedFormatting = 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 whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf)
fontWeightenumYesnormaldata type=string; lov=STATIC
Valid values: normal bold
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf)
fontSizeintegerYes12data type=integer; maxLen=32767
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf)
fontColorstringYes#000000data type=string; maxLen=255
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf)
alignmentenumYescenterdata type=string; lov=STATIC
Valid values: start center end
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf)
pageFooterTextmultiline stringNodata type=multiline string; maxLen=4000
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and 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 whentype = interactiveGrid and download = truetype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true
formatsarray of enumsNodata type=string; lov=STATIC
Valid values: csv html pdf excel
Applies whentype = interactiveGrid and download = true
sendAsEmailbooleanYestruedata type=boolean
Applies whentype = interactiveGrid and download = truetype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true
csvSeparatorstringNodata type=string; maxLen=2
Applies whentype = classicReport and csvExportEnabled = truetype = tabform and csvExportEnabled = truetype = interactiveGrid and download = true and formats = csvtype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats = csv
csvEnclosedBystringNodata type=string; maxLen=1
Applies whentype = classicReport and csvExportEnabled = truetype = tabform and csvExportEnabled = truetype = interactiveGrid and download = true and formats = csvtype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats = csv
csvExportEnabledbooleanYesfalsedata type=boolean
Applies whentype = classicReporttype = tabform
filenamestringNodata type=string; maxLen=255
Applies whentype = classicReport and csvExportEnabled = truetype = tabform and csvExportEnabled = truetype = interactiveGrid and download = truetype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true
supplementalTextmultiline stringNodata type=multiline string; maxLen=4000
Applies whentype = classicReporttype = tabformtype = interactiveGrid and download = true and formats is settype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats is set
linkTextstringYesDownloaddata type=string; maxLen=255
Applies whentype = classicReport and csvExportEnabled = truetype = tabform and csvExportEnabled = true
formatsarray of enumsYesCSV:HTML:XLSX:PDFdata type=string; lov=STATIC
Valid values: csv html excel pdf
Applies whentype = interactiveReport and includeSearchBar = 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 = chart and type in (area)type = chart and type in (bar)type = chart and type in (line)type = chart and type in (lineWithArea)type = chart and type in (stock)type = chart and type in (boxPlot)type = chart and type in (combination)
zoomAndScrollenumYesfalsedata type=string; lov=STATIC
Valid values: false delayed delayedScrollOnly live liveScrollOnly
Applies whentype = chart

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 = chart and type in (bubble)type = chart and type in (scatter)
initialZoomingenumYesnonedata type=string; lov=STATIC
Valid values: first last none
Applies whentype = chart and type in (bar)type = chart and type in (line)type = chart and type in (area)type = chart and type in (lineWithArea)type = chart and type in (combination)type = chart and type in (stock)
showHorizontalGridenumYesautodata type=string; lov=STATIC
Valid values: auto true false
Applies whentype = chart and type = gantt
showVerticalGridenumYesautodata type=string; lov=STATIC
Valid values: auto true false
Applies whentype = chart and type = gantt
showRowAxisbooleanYesondata type=boolean
Applies whentype = chart and type = gantt
axisPositionenumYestopdata type=string; lov=STATIC
Valid values: top bottom
Applies whentype = chart and type = gantt
pieSelectionEffectenumYeshighlightdata type=string; lov=STATIC
Valid values: explode highlightAndExplode highlight
Applies whentype = chart and type in (pie)type = chart and type in (donut)
renderAsenumYescandlestickdata type=string; lov=STATIC
Valid values: area bar candlestick line lineWithArea
Applies whentype = chart and type = 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
Applies whentype = cards
iconColumnstringYesdata type=string; maxLen=32767
Applies whentype = cards and iconSource in (initials)type = cards and iconSource in (iconClassColumn)
imageColumnstringYesdata type=string; maxLen=32767
Applies whentype = cards and iconSource = imageBlobColumn
imageUrlstringYesdata type=string; maxLen=4000
Applies whentype = cards and iconSource = imageUrl
iconCssClassesstringNodata type=string; maxLen=255
Applies whentype = cards and iconSource is set
iconPositionenumYesstartdata type=string; lov=STATIC
Valid values: top start end
Applies whentype = cards and iconSource is set
iconDescriptionstringNodata type=string; maxLen=255
Applies whentype = cards and iconSource is set
badgeColumnstringNodata type=string; maxLen=32767
Applies whentype = cards
badgeLabelstringNodata type=string; maxLen=255
Applies whentype = cards and badgeColumn is set
badgeCssClassesarray of stringsNodata type=string; maxLen=255
Applies whentype = cards and badgeColumn 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
Applies whentype = classicReporttype = tabform
sortNullsenumYeslastdata type=string; lov=STATIC
Valid values: first last
Applies whentype = classicReporttype = tabform
customSvgStylesmultiline stringNodata type=multiline string; maxLen=32767
Applies whentype = map
oracleTextIndexColumnstringNodata type=string; maxLen=32767
Applies whentype = interactiveReporttype = interactiveGrid
emailFromAddressstringNodata type=string; maxLen=255
Applies whentype = interactiveReporttype = interactiveGrid
initJavaScriptFunctionmultiline stringNodata type=multiline string; maxLen=4000
Applies whentype = charttype = interactiveGridtype = cardstype supports INIT_JAVASCRIPT_CODE
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
Applies whentype = interactiveReport
reportIdItemstringNodata type=string; maxLen=255; textCase=UPPER
Applies whentype = interactiveReport
maxRowsPerPageInSelectorstringNodata type=string; maxLen=4000
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and rowsPerPage = truetype = interactiveReport and includeSearchBar = 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 whentype = interactiveReport and linkColumn = singleRowView
onlyDisplayedColumnsbooleanYesfalsedata type=boolean
Applies whentype = interactiveReport and linkColumn = singleRowView
singleRowView {
  excludeNullValues: false
  onlyDisplayedColumns: false
}
heading
PropertyTypeRequiredDefault ValueDetails
typeenumYescustomHeadingsdata type=string; lov=STATIC
Valid values: columnNames columnNamesInitcap customHeadings plsqlFunctionBody none
Applies whentype = classicReporttype = tabformtype supports COLUMN_HEADING
plsqlFunctionBodymultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = classicReport and type = plsqlFunctionBodytype = tabform and type = plsqlFunctionBodytype supports COLUMN_HEADING and type = plsqlFunctionBody
fixedToenumYespagedata type=string; lov=STATIC
Valid values: none region page
Applies whentype = interactiveReporttype = interactiveGrid
fixedReportHeightintegerYesdata type=integer; maxLen=32767
Applies whentype = interactiveGrid and fixedTo = region
maxReportHeightintegerYesdata type=integer; maxLen=32767
Applies whentype = interactiveReport and fixedTo = region
heading {
  type: columnNames
  plsqlFunctionBody: ```plsql
    value
  ```
  fixedTo: none
  fixedReportHeight: 42
  maxReportHeight: 42
}
iconView
PropertyTypeRequiredDefault ValueDetails
showbooleanYesfalsedata type=boolean
Applies whentype = interactiveReporttype = interactiveGrid
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 whentype = interactiveReport and show = truetype = interactiveGrid and show = true
customIconmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = interactiveGrid and show = true and custom = true
iconTypeenumYesiconCssClassesdata type=string; lov=STATIC
Valid values: imageInUrl iconCssClasses
Applies whentype = interactiveGrid and show = true and custom = false
iconUrlstringYesdata type=string; maxLen=32767
Applies whentype = interactiveGrid and show = true and custom = false and iconType = imageInUrl
iconstringYesdata type=string; maxLen=32767
Applies whentype = interactiveGrid and show = true and custom = false and iconType = iconCssClasses
iconAttributesstringNodata type=string; maxLen=255
Applies whentype = interactiveGrid and show = true and custom = false and iconType = imageInUrl
linkTargetcomplexNodata type=complex; maxLen=32767
Applies whentype = interactiveGrid and show = true
linkAttributesstringNodata type=string; maxLen=255
Applies whentype = interactiveGrid and show = true and linkTarget is set and custom = false
labelColumnstringYesdata type=string; maxLen=32767
Applies whentype = interactiveGrid and show = true and custom = false
columnsPerRowenumYes6data type=string; lov=STATIC
Valid values: 1 2 3 4 5 6 7 8 9
Applies whentype = interactiveReport and show = true
linkColumnstringYesdata type=string; maxLen=32767
Applies whentype = interactiveReport and show = true and custom = false
imageSourceColumnstringYesdata type=string; maxLen=32767
Applies whentype = interactiveReport and show = true and custom = false
labelColumnstringYesdata type=string; maxLen=32767
Applies whentype = interactiveReport and show = true and custom = false
imageAttributesstringNodata type=string; maxLen=512
Applies whentype = interactiveReport and show = true and custom = false
htmlAltTextstringNodata type=string; maxLen=512
Applies whentype = interactiveReport and show = true and custom = false
htmlTitleTextstringNodata type=string; maxLen=512
Applies whentype = interactiveReport and show = true and custom = false
customLinkmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = interactiveReport and show = 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
Applies whentype = cards
htmlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = cards and advancedFormatting = true
sourceenumNodata type=string; lov=STATIC
Valid values: imageUrl urlColumn blobColumn
Applies whentype = cards and advancedFormatting = false
urlstringYesdata type=string; maxLen=4000
Applies whentype = cards and advancedFormatting = false and source = imageUrl
urlColumnstringYesdata type=string; maxLen=32767
Applies whentype = cards and advancedFormatting = false and source = urlColumn
blobColumnstringYesdata type=string; maxLen=32767
Applies whentype = cards and advancedFormatting = false and source = blobColumn
positionenumYesbodydata type=string; lov=STATIC
Valid values: first body background
Applies whentype = cards and advancedFormatting = false and source is set and advancedFormatting = true and htmlExpression is set
appearanceenumNodata type=string; lov=STATIC
Valid values: square widescreen
Applies whentype = cards and advancedFormatting = false and source is set
sizingenumYesfitdata type=string; lov=STATIC
Valid values: fit cover
Applies whentype = cards and advancedFormatting = false and source is set
cssClassesarray of stringsNodata type=string; maxLen=255
Applies whentype = cards
imageDescriptionstringNodata type=string; maxLen=255
Applies whentype = cards and advancedFormatting = 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
Applies whentype = map
titlestringNodata type=string; maxLen=255
Applies whentype = map and show = truetype = chart and show = on
Specify the title of the legend.
positionenumYesenddata type=string; lov=STATIC
Valid values: start end selector
Applies whentype = map and show = true
selectorstringYesdata type=string; maxLen=32767
Applies whentype = map and show = true and position = selector
cssClassesarray of stringsNodata type=string; maxLen=255
Applies whentype = map and show = true
showbooleanYesondata type=boolean
Applies whentype = chart
positionenumYesautodata type=string; lov=STATIC
Valid values: auto start end top bottom
Applies whentype = chart and show = on
hideAndShowBehaviorenumYesrescaledata type=string; lov=STATIC
Valid values: none rescale noRescaling
Applies whentype = chart and show = 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 = chart and show = on
fontStyleenumNodata type=string; lov=STATIC
Valid values: normal italic oblique
Applies whentype = chart and show = on
fontSizeenumNodata type=string; lov=STATIC
Valid values: 8 10 12 14 16 18 20 22
Applies whentype = chart and show = on
fontColorstringNodata type=string; maxLen=255
Applies whentype = chart and show = 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 = chart and type in (area)type = chart and type in (bar)type = chart and type in (line)type = chart and type in (stock)type = chart and type in (boxPlot)type = chart and type in (lineWithArea)type = chart and type in (combination)
heightstringNodata type=string; maxLen=5
Applies whentype = chart and type in (area) and show = ontype = chart and type in (bar) and show = ontype = chart and type in (line) and show = ontype = chart and type in (stock) and show = ontype = chart and type in (boxPlot) and show = ontype = chart and type in (lineWithArea) and show = ontype = chart and type in (combination) and show = on
overview {
  show: false
  height: value
}
printing
PropertyTypeRequiredDefault ValueDetails
enabledbooleanYesfalsedata type=boolean
Applies whentype = classicReporttype = tabform
printing {
  enabled: false
}
externalProcessing
PropertyTypeRequiredDefault ValueDetails
enabledbooleanYesfalsedata type=boolean
Applies whentype = classicReporttype = tabform
urlstringYesdata type=string; maxLen=2000
Applies whentype = classicReport and enabled = truetype = tabform and enabled = true
linkTextstringYesdata type=string; maxLen=2000
Applies whentype = classicReport and enabled = truetype = tabform and enabled = true
externalProcessing {
  enabled: false
  url: value
  linkText: value
}
genAI
PropertyTypeRequiredDefault ValueDetails
naturalLanguageSupportbooleanYesfalsedata type=boolean
Applies whentype = interactiveReport
defaultSearchModeenumYessearchModeAIdata type=string; lov=STATIC
Valid values: searchModeRow searchModeAI
Applies whentype = interactiveReport and naturalLanguageSupport = true
reportContextmultiline stringNodata type=multiline string; maxLen=32767
Applies whentype = interactiveReport and naturalLanguageSupport = true
enabledbooleanYesfalsedata type=boolean
Applies whentype supports AI_ENABLED
agentreferenceNodata type=reference; lov=COMPONENT; references=aiAgent
Applies whentype supports AI_ENABLED_ALWAYS and type supports AI_ENABLED and enabled = truetype supports AI_ENABLED and enabled = true
servicereferenceNodata type=reference; lov=COMPONENT; references=genAIService
Applies whentype supports AI_ENABLED_ALWAYS and type supports AI_ENABLED and enabled = truetype supports AI_ENABLED and enabled = true
systemPromptmultiline stringNodata type=multiline string; maxLen=32767
Applies whentype supports AI_SYSTEM_PROMPT and type supports AI_ENABLED_ALWAYS and type supports AI_ENABLED and enabled = truetype supports AI_SYSTEM_PROMPT and type supports AI_ENABLED and enabled = true
welcomeMessagemultiline stringNodata type=multiline string; maxLen=32767
Applies whentype supports AI_UI and type supports AI_ENABLED_ALWAYS and type supports AI_ENABLED and enabled = truetype supports AI_UI and type supports AI_ENABLED and enabled = 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 = chart and type in (pie)type = chart and type in (donut)
minintegerNodata type=integer; maxLen=32767
Applies whentype = chart and type in (pie)type = chart and type in (donut)
showbooleanYestruedata type=boolean
Applies whentype = chart and type = statusMeterGauge
valueTypeenumYesnumberdata type=string; lov=STATIC
Valid values: number percent
Applies whentype = chart and type = statusMeterGauge
positionenumYesautodata type=string; lov=STATIC
Valid values: auto center insideIndicatorEdge outsideIndicatorEdge outsidePlotArea withLabel
Applies whentype = chart and type = 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 = chart and type in (statusMeterGauge)type = chart and type in (funnel)type = chart and type in (pyramid)type = chart and type in (pie)type = chart and 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 = chart and type in (statusMeterGauge) and format in (decimal)type = chart and type in (statusMeterGauge) and format in (currency)type = chart and type in (statusMeterGauge) and format in (percent)type = chart and type in (statusMeterGauge) and type in (funnel) and format in (decimal)type = chart and type in (statusMeterGauge) and type in (funnel) and format in (currency)type = chart and type in (statusMeterGauge) and type in (funnel) and format in (percent)type = chart and type in (statusMeterGauge) and type in (pyramid) and format in (decimal)type = chart and type in (statusMeterGauge) and type in (pyramid) and format in (currency)type = chart and type in (statusMeterGauge) and type in (pyramid) and format in (percent)type = chart and type in (statusMeterGauge) and type in (pie) and format in (decimal)type = chart and type in (statusMeterGauge) and type in (pie) and format in (currency)type = chart and type in (statusMeterGauge) and type in (pie) and format in (percent)type = chart and type in (statusMeterGauge) and type in (donut) and format in (decimal)type = chart and type in (statusMeterGauge) and type in (donut) and format in (currency)type = chart and type in (statusMeterGauge) and type in (donut) and format in (percent)type = chart and type in (funnel) and type in (statusMeterGauge) and format in (decimal)type = chart and type in (funnel) and type in (statusMeterGauge) and format in (currency)type = chart and type in (funnel) and type in (statusMeterGauge) and format in (percent)type = chart and type in (funnel) and format in (decimal)type = chart and type in (funnel) and format in (currency)type = chart and type in (funnel) and format in (percent)type = chart and type in (funnel) and type in (pyramid) and format in (decimal)type = chart and type in (funnel) and type in (pyramid) and format in (currency)type = chart and type in (funnel) and type in (pyramid) and format in (percent)type = chart and type in (funnel) and type in (pie) and format in (decimal)type = chart and type in (funnel) and type in (pie) and format in (currency)type = chart and type in (funnel) and type in (pie) and format in (percent)type = chart and type in (funnel) and type in (donut) and format in (decimal)type = chart and type in (funnel) and type in (donut) and format in (currency)type = chart and type in (funnel) and type in (donut) and format in (percent)type = chart and type in (pyramid) and type in (statusMeterGauge) and format in (decimal)type = chart and type in (pyramid) and type in (statusMeterGauge) and format in (currency)type = chart and type in (pyramid) and type in (statusMeterGauge) and format in (percent)type = chart and type in (pyramid) and type in (funnel) and format in (decimal)type = chart and type in (pyramid) and type in (funnel) and format in (currency)type = chart and type in (pyramid) and type in (funnel) and format in (percent)type = chart and type in (pyramid) and format in (decimal)type = chart and type in (pyramid) and format in (currency)type = chart and type in (pyramid) and format in (percent)type = chart and type in (pyramid) and type in (pie) and format in (decimal)type = chart and type in (pyramid) and type in (pie) and format in (currency)type = chart and type in (pyramid) and type in (pie) and format in (percent)type = chart and type in (pyramid) and type in (donut) and format in (decimal)type = chart and type in (pyramid) and type in (donut) and format in (currency)type = chart and type in (pyramid) and type in (donut) and format in (percent)type = chart and type in (pie) and type in (statusMeterGauge) and format in (decimal)type = chart and type in (pie) and type in (statusMeterGauge) and format in (currency)type = chart and type in (pie) and type in (statusMeterGauge) and format in (percent)type = chart and type in (pie) and type in (funnel) and format in (decimal)type = chart and type in (pie) and type in (funnel) and format in (currency)type = chart and type in (pie) and type in (funnel) and format in (percent)type = chart and type in (pie) and type in (pyramid) and format in (decimal)type = chart and type in (pie) and type in (pyramid) and format in (currency)type = chart and type in (pie) and type in (pyramid) and format in (percent)type = chart and type in (pie) and format in (decimal)type = chart and type in (pie) and format in (currency)type = chart and type in (pie) and format in (percent)type = chart and type in (pie) and type in (donut) and format in (decimal)type = chart and type in (pie) and type in (donut) and format in (currency)type = chart and type in (pie) and type in (donut) and format in (percent)type = chart and type in (donut) and type in (statusMeterGauge) and format in (decimal)type = chart and type in (donut) and type in (statusMeterGauge) and format in (currency)type = chart and type in (donut) and type in (statusMeterGauge) and format in (percent)type = chart and type in (donut) and type in (funnel) and format in (decimal)type = chart and type in (donut) and type in (funnel) and format in (currency)type = chart and type in (donut) and type in (funnel) and format in (percent)type = chart and type in (donut) and type in (pyramid) and format in (decimal)type = chart and type in (donut) and type in (pyramid) and format in (currency)type = chart and type in (donut) and type in (pyramid) and format in (percent)type = chart and type in (donut) and type in (pie) and format in (decimal)type = chart and type in (donut) and type in (pie) and format in (currency)type = chart and type in (donut) and type in (pie) and format in (percent)type = chart and type in (donut) and format in (decimal)type = chart and type in (donut) and format in (currency)type = chart and 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 = chart and type in (statusMeterGauge) and format = currencytype = chart and type in (statusMeterGauge) and type in (funnel) and format = currencytype = chart and type in (statusMeterGauge) and type in (pyramid) and format = currencytype = chart and type in (statusMeterGauge) and type in (pie) and format = currencytype = chart and type in (statusMeterGauge) and type in (donut) and format = currencytype = chart and type in (funnel) and type in (statusMeterGauge) and format = currencytype = chart and type in (funnel) and format = currencytype = chart and type in (funnel) and type in (pyramid) and format = currencytype = chart and type in (funnel) and type in (pie) and format = currencytype = chart and type in (funnel) and type in (donut) and format = currencytype = chart and type in (pyramid) and type in (statusMeterGauge) and format = currencytype = chart and type in (pyramid) and type in (funnel) and format = currencytype = chart and type in (pyramid) and format = currencytype = chart and type in (pyramid) and type in (pie) and format = currencytype = chart and type in (pyramid) and type in (donut) and format = currencytype = chart and type in (pie) and type in (statusMeterGauge) and format = currencytype = chart and type in (pie) and type in (funnel) and format = currencytype = chart and type in (pie) and type in (pyramid) and format = currencytype = chart and type in (pie) and format = currencytype = chart and type in (pie) and type in (donut) and format = currencytype = chart and type in (donut) and type in (statusMeterGauge) and format = currencytype = chart and type in (donut) and type in (funnel) and format = currencytype = chart and type in (donut) and type in (pyramid) and format = currencytype = chart and type in (donut) and type in (pie) and format = currencytype = chart and type in (donut) and format = currency
patternstringNodata type=string; maxLen=30
Applies whentype = chart and type in (statusMeterGauge) and format in (decimal)type = chart and type in (statusMeterGauge) and format in (currency)type = chart and type in (statusMeterGauge) and format in (percent)type = chart and type in (statusMeterGauge) and type in (funnel) and format in (decimal)type = chart and type in (statusMeterGauge) and type in (funnel) and format in (currency)type = chart and type in (statusMeterGauge) and type in (funnel) and format in (percent)type = chart and type in (statusMeterGauge) and type in (pyramid) and format in (decimal)type = chart and type in (statusMeterGauge) and type in (pyramid) and format in (currency)type = chart and type in (statusMeterGauge) and type in (pyramid) and format in (percent)type = chart and type in (statusMeterGauge) and type in (pie) and format in (decimal)type = chart and type in (statusMeterGauge) and type in (pie) and format in (currency)type = chart and type in (statusMeterGauge) and type in (pie) and format in (percent)type = chart and type in (statusMeterGauge) and type in (donut) and format in (decimal)type = chart and type in (statusMeterGauge) and type in (donut) and format in (currency)type = chart and type in (statusMeterGauge) and type in (donut) and format in (percent)type = chart and type in (funnel) and type in (statusMeterGauge) and format in (decimal)type = chart and type in (funnel) and type in (statusMeterGauge) and format in (currency)type = chart and type in (funnel) and type in (statusMeterGauge) and format in (percent)type = chart and type in (funnel) and format in (decimal)type = chart and type in (funnel) and format in (currency)type = chart and type in (funnel) and format in (percent)type = chart and type in (funnel) and type in (pyramid) and format in (decimal)type = chart and type in (funnel) and type in (pyramid) and format in (currency)type = chart and type in (funnel) and type in (pyramid) and format in (percent)type = chart and type in (funnel) and type in (pie) and format in (decimal)type = chart and type in (funnel) and type in (pie) and format in (currency)type = chart and type in (funnel) and type in (pie) and format in (percent)type = chart and type in (funnel) and type in (donut) and format in (decimal)type = chart and type in (funnel) and type in (donut) and format in (currency)type = chart and type in (funnel) and type in (donut) and format in (percent)type = chart and type in (pyramid) and type in (statusMeterGauge) and format in (decimal)type = chart and type in (pyramid) and type in (statusMeterGauge) and format in (currency)type = chart and type in (pyramid) and type in (statusMeterGauge) and format in (percent)type = chart and type in (pyramid) and type in (funnel) and format in (decimal)type = chart and type in (pyramid) and type in (funnel) and format in (currency)type = chart and type in (pyramid) and type in (funnel) and format in (percent)type = chart and type in (pyramid) and format in (decimal)type = chart and type in (pyramid) and format in (currency)type = chart and type in (pyramid) and format in (percent)type = chart and type in (pyramid) and type in (pie) and format in (decimal)type = chart and type in (pyramid) and type in (pie) and format in (currency)type = chart and type in (pyramid) and type in (pie) and format in (percent)type = chart and type in (pyramid) and type in (donut) and format in (decimal)type = chart and type in (pyramid) and type in (donut) and format in (currency)type = chart and type in (pyramid) and type in (donut) and format in (percent)type = chart and type in (pie) and type in (statusMeterGauge) and format in (decimal)type = chart and type in (pie) and type in (statusMeterGauge) and format in (currency)type = chart and type in (pie) and type in (statusMeterGauge) and format in (percent)type = chart and type in (pie) and type in (funnel) and format in (decimal)type = chart and type in (pie) and type in (funnel) and format in (currency)type = chart and type in (pie) and type in (funnel) and format in (percent)type = chart and type in (pie) and type in (pyramid) and format in (decimal)type = chart and type in (pie) and type in (pyramid) and format in (currency)type = chart and type in (pie) and type in (pyramid) and format in (percent)type = chart and type in (pie) and format in (decimal)type = chart and type in (pie) and format in (currency)type = chart and type in (pie) and format in (percent)type = chart and type in (pie) and type in (donut) and format in (decimal)type = chart and type in (pie) and type in (donut) and format in (currency)type = chart and type in (pie) and type in (donut) and format in (percent)type = chart and type in (donut) and type in (statusMeterGauge) and format in (decimal)type = chart and type in (donut) and type in (statusMeterGauge) and format in (currency)type = chart and type in (donut) and type in (statusMeterGauge) and format in (percent)type = chart and type in (donut) and type in (funnel) and format in (decimal)type = chart and type in (donut) and type in (funnel) and format in (currency)type = chart and type in (donut) and type in (funnel) and format in (percent)type = chart and type in (donut) and type in (pyramid) and format in (decimal)type = chart and type in (donut) and type in (pyramid) and format in (currency)type = chart and type in (donut) and type in (pyramid) and format in (percent)type = chart and type in (donut) and type in (pie) and format in (decimal)type = chart and type in (donut) and type in (pie) and format in (currency)type = chart and type in (donut) and type in (pie) and format in (percent)type = chart and type in (donut) and format in (decimal)type = chart and type in (donut) and format in (currency)type = chart and 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 = chart and type in (statusMeterGauge)type = chart and type in (funnel)type = chart and type in (pyramid)type = chart and type in (pie)type = chart and 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
Applies whentype = map
messageSelectorstringYesdata type=string; maxLen=32767
Applies whentype = map and messagesPosition = selector
unitSystemenumYesmetricdata type=string; lov=STATIC
Valid values: metric imperial deriveFromItem
Applies whentype = map
unitSystemItemstringYesdata type=string; maxLen=32767; textCase=UPPER
Applies whentype = map and unitSystem = deriveFromItem
copyrightNoticemultiline stringNodata type=multiline string; maxLen=32767
Applies whentype = map
attributes {
  messagesPosition: above
  messageSelector: value
  unitSystem: metric
  unitSystemItem: value
  copyrightNotice: ```html
    value
  ```
}
searchBar
PropertyTypeRequiredDefault ValueDetails
includeSearchBarbooleanYestruedata type=boolean
Applies whentype = interactiveReport
searchFieldbooleanYestruedata type=boolean
Applies whentype = interactiveReport and includeSearchBar = true
finderDropDownbooleanYestruedata type=boolean
Applies whentype = interactiveReport and includeSearchBar = true and searchField = true
reportsSelectListbooleanYesTABSdata type=boolean
Applies whentype = interactiveReport and includeSearchBar = true
rowsPerPageSelectorbooleanYesfalsedata type=boolean
Applies whentype = interactiveReport and includeSearchBar = true
searchButtonLabelstringNodata type=string; maxLen=4000
Applies whentype = interactiveReport and includeSearchBar = 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 whentype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$)
orderByClausemultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue
itemcomplexYesdata type=complex; maxLen=32767
Applies whentype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item
orderByClausemultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type = propertyGraph
itemcomplexYesdata type=complex; maxLen=32767
Applies whentype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location 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 whentype = cards and iconSource = imageBlobColumntype = cards and advancedFormatting = false and source = blobColumn
lastUpdatedColumnstringNodata type=string; maxLen=32767
Applies whentype = cards and iconSource = imageBlobColumntype = cards and advancedFormatting = false and source = blobColumn
blobAttributes {
  mimeTypeColumn: value
  lastUpdatedColumn: value
}
detailView
PropertyTypeRequiredDefault ValueDetails
showbooleanYesfalsedata type=boolean
Applies whentype = interactiveReporttype = interactiveGrid
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 whentype = interactiveReport and show = truetype = interactiveGrid and show = true
forEachRowmultiline stringDependsdata type=multiline string; maxLen=4000
Applies whentype = interactiveReport and show = truetype = interactiveGrid and show = 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 whentype = interactiveReport and show = truetype = interactiveGrid and show = true
detailView {
  show: false
  beforeRows: ```html
    value
  ```
  forEachRow: ```html
    value
  ```
  afterRows: ```html
    value
  ```
}
actionsMenu
PropertyTypeRequiredDefault ValueDetails
includeActionsMenubooleanYestruedata type=boolean
Applies whentype = interactiveReport and includeSearchBar = true
filterbooleanYestruedata type=boolean
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true
selectColumnsbooleanYestruedata type=boolean
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true
rowsPerPagebooleanYestruedata type=boolean
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true
sortbooleanYestruedata type=boolean
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true
controlBreakbooleanYestruedata type=boolean
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true
highlightbooleanYestruedata type=boolean
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true
computebooleanYestruedata type=boolean
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true
aggregatebooleanYestruedata type=boolean
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true
chartbooleanYestruedata type=boolean
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true
groupBybooleanYestruedata type=boolean
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true
pivotbooleanYestruedata type=boolean
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true
flashbackbooleanYestruedata type=boolean
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true
saveReportbooleanYestruedata type=boolean
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true
savePublicReportbooleanYesfalsedata type=boolean
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and saveReport = true
savePublicReportAuthorizationenumNodata type=reference; lov=COMPONENT; references=authorization
Valid values: mustNotBePublicUser
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and saveReport = true and savePublicReport = true
resetbooleanYestruedata type=boolean
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true
helpbooleanYestruedata type=boolean
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true
downloadbooleanYestruedata type=boolean
Applies whentype = interactiveReport and includeSearchBar = true and includeActionsMenu = true
subscriptionbooleanYestruedata type=boolean
Applies whentype = interactiveReport and includeSearchBar = 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 whentype supports SOURCE_LOCATION and location = restSource and restSource supports HAS_ARRAY_COLUMNS
nestedRowsreferenceNodata type=reference; lov=COMPONENT; references=dataProfileColumn
Applies whentype supports SOURCE_LOCATION and location = jsonDualityView and jsonDualityView supports HAS_ARRAY_COLUMNS
nestedRowsreferenceNodata type=reference; lov=COMPONENT; references=dataProfileColumn
Applies whentype supports SOURCE_LOCATION and location = 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 whentype = chart and lazyLoading = false
onDataChangeenumYesautodata type=string; lov=STATIC
Valid values: auto slideToLeft slideToRight none
Applies whentype = chart
animation {
  onDisplay: auto
  onDataChange: auto
}
restSynchronization
PropertyTypeRequiredDefault ValueDetails
useLocalTablebooleanYesfalsedata type=boolean
Applies whentype supports SOURCE_LOCATION and location = restSource and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNStype supports SOURCE_LOCATION and location = restSource and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNStype supports SOURCE_LOCATION and location = restSource and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED
restSynchronization {
  useLocalTable: false
}
tooltip
PropertyTypeRequiredDefault ValueDetails
showbooleanYestruedata type=boolean
Applies whentype = chart
showSeriesNamebooleanYestruedata type=boolean
Applies whentype = chart and show = true
showGroupNamebooleanYestruedata type=boolean
Applies whentype = chart and show = true
showValuebooleanYestruedata type=boolean
Applies whentype = chart and show = true
showRowbooleanYestruedata type=boolean
Applies whentype = chart and show = true and type = gantt
showLabelbooleanYestruedata type=boolean
Applies whentype = chart and show = true and type = gantt
showStartDatebooleanYestruedata type=boolean
Applies whentype = chart and show = true and type = gantt
showEndDatebooleanYestruedata type=boolean
Applies whentype = chart and show = true and type = gantt
showProgressbooleanYestruedata type=boolean
Applies whentype = chart and show = true and type = gantt
showBaselinebooleanYestruedata type=boolean
Applies whentype = chart and show = 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 whentype supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in (false)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in ($NULL$)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false)type supports SOURCE_LOCATION and 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 whentype supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false) and enabled = truetype supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = truetype supports SOURCE_LOCATION and location = 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 = truetype supports SOURCE_LOCATION and location = 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 = truetype supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false) and enabled = truetype supports SOURCE_LOCATION and location = 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 whentype supports ORDER_BY and type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false) and enabled = truetype supports ORDER_BY and type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = truetype supports ORDER_BY and type supports SOURCE_LOCATION and location = 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 = truetype supports ORDER_BY and type supports SOURCE_LOCATION and location = 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 = truetype supports ORDER_BY and type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false) and enabled = truetype supports ORDER_BY and type supports SOURCE_LOCATION and location = 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 whentype supports ORDER_BY and type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false) and enabled = true and orderByType = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = true and orderByType = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location = 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 = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location = 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 = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location = 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 = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location = 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 = staticValuetype supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false) and enabled = true and type in (interactiveGrid)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false) and enabled = true and type in (interactiveReport)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false) and enabled = true and type in (map)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false) and enabled = true and type in (form)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = true and type in (interactiveGrid)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = true and type in (interactiveReport)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = true and type in (map)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = true and type in (form)type supports SOURCE_LOCATION and location = 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 type in (interactiveGrid)type supports SOURCE_LOCATION and location = 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 type in (interactiveReport)type supports SOURCE_LOCATION and location = 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 type in (map)type supports SOURCE_LOCATION and location = 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 type in (form)type supports SOURCE_LOCATION and location = 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 type in (interactiveGrid)type supports SOURCE_LOCATION and location = 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 type in (interactiveReport)type supports SOURCE_LOCATION and location = 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 type in (map)type supports SOURCE_LOCATION and location = 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 type in (form)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false) and enabled = true and type in (interactiveGrid)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false) and enabled = true and type in (interactiveReport)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false) and enabled = true and type in (map)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false) and enabled = true and type in (form)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in ($NULL$) and enabled = true and type in (interactiveGrid)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in ($NULL$) and enabled = true and type in (interactiveReport)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in ($NULL$) and enabled = true and type in (map)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in ($NULL$) and enabled = true and type in (form)
itemcomplexYesdata type=complex; maxLen=4000
Applies whentype supports ORDER_BY and type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false) and enabled = true and orderByType = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = true and orderByType = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location = 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 = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location = 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 = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location = 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 = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location = 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
Applies whentype = interactiveReporttype = interactiveGrid
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
Applies whentype supports REGION_TEMPLATE
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 whentype supports REGION_TEMPLATE and template supports NOT_REGION_IMAGE_URL
imageTagAttributesstringNodata type=string; maxLen=255
Applies whentype supports REGION_TEMPLATE and template supports NOT_REGION_IMAGE_URL and regionImage is set
staticIdstringYesdata type=string; maxLen=255
regionDisplaySelectorbooleanYesfalsedata type=boolean
Applies whentype supports REGION_TEMPLATE and template is set
excludeTitleFromTranslationbooleanYesfalsedata type=boolean
schemaOverrideItemstringNodata type=string; maxLen=4000; textCase=UPPER
Applies whentype in (classicReport)type in (interactiveReport)
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
Applies whentype = interactiveGrid

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 whentype supports SOURCE_LOCATION and location = restSource and restSource is set
whereClausemultiline stringNodata type=multiline string; maxLen=4000
Applies whentype supports SOURCE_LOCATION and location = restSource and restSource is set and type = whereOrderByClause
sqlQuerymultiline stringYesdata type=multiline string; maxLen=32767
Applies whentype supports SOURCE_LOCATION and location = restSource and restSource is set and type = sqlQuery
languageenumYesplsqldata type=string; lov=STATIC
Valid values: plsql javaScript-mle
Applies whentype supports SOURCE_LOCATION and location = restSource and restSource is set and type = plsqlFunctionBody
plsqlFunctionBodymultiline stringYesdata type=multiline string; maxLen=32767
Applies whentype supports SOURCE_LOCATION and location = restSource and restSource is set and type = plsqlFunctionBody and language = plsql
javaScriptFunctionBodymultiline stringYesdata type=multiline string; maxLen=32767
Applies whentype supports SOURCE_LOCATION and location = restSource and restSource is set and type = plsqlFunctionBody and language = javaScript-mle
orderByTypeenumNodata type=string; lov=STATIC
Valid values: staticValue item
Applies whentype supports SOURCE_LOCATION and location = restSource and restSource is set and type = whereOrderByClause
orderByClausemultiline stringYesdata type=multiline string; maxLen=255
Applies whentype supports SOURCE_LOCATION and location = restSource and restSource is set and type = whereOrderByClause and orderByType = staticValue
itemcomplexYesdata type=complex; maxLen=32767
Applies whentype supports SOURCE_LOCATION and location = restSource and restSource is set and type = whereOrderByClause and orderByType = item
orderByItemcomplexNodata type=complex; maxLen=32767
Applies whentype supports SOURCE_LOCATION and location = restSource and restSource is set and type in (sqlQuery)type supports SOURCE_LOCATION and location = restSource and restSource is set and type in (plsqlFunctionBody)
typeenumNodata type=string; lov=STATIC
Valid values: whereOrderByClause sqlQuery plsqlFunctionBody
Applies whentype supports SOURCE_LOCATION and location = jsonDualityView and jsonDualityView is set
whereClausemultiline stringNodata type=multiline string; maxLen=4000
Applies whentype supports SOURCE_LOCATION and location = jsonDualityView and jsonDualityView is set and type = whereOrderByClause
sqlQuerymultiline stringYesdata type=multiline string; maxLen=32767
Applies whentype supports SOURCE_LOCATION and location = jsonDualityView and jsonDualityView is set and type = sqlQuery
languageenumYesplsqldata type=string; lov=STATIC
Valid values: plsql javaScript-mle
Applies whentype supports SOURCE_LOCATION and location = jsonDualityView and jsonDualityView is set and type = plsqlFunctionBody
plsqlFunctionBodymultiline stringYesdata type=multiline string; maxLen=32767
Applies whentype supports SOURCE_LOCATION and location = jsonDualityView and jsonDualityView is set and type = plsqlFunctionBody and language = plsql
javaScriptFunctionBodymultiline stringYesdata type=multiline string; maxLen=32767
Applies whentype supports SOURCE_LOCATION and location = jsonDualityView and jsonDualityView is set and type = plsqlFunctionBody and language = javaScript-mle
orderByTypeenumNodata type=string; lov=STATIC
Valid values: staticValue item
Applies whentype supports SOURCE_LOCATION and location = jsonDualityView and jsonDualityView is set and type = whereOrderByClause
orderByClausemultiline stringYesdata type=multiline string; maxLen=255
Applies whentype supports SOURCE_LOCATION and location = jsonDualityView and jsonDualityView is set and type = whereOrderByClause and orderByType = staticValue
itemcomplexYesdata type=complex; maxLen=32767
Applies whentype supports SOURCE_LOCATION and location = jsonDualityView and jsonDualityView is set and type = whereOrderByClause and orderByType = item
orderByItemcomplexNodata type=complex; maxLen=32767
Applies whentype supports SOURCE_LOCATION and location = jsonDualityView and jsonDualityView is set and type in (sqlQuery)type supports SOURCE_LOCATION and location = jsonDualityView and jsonDualityView is set and type in (plsqlFunctionBody)
typeenumNodata type=string; lov=STATIC
Valid values: whereOrderByClause sqlQuery plsqlFunctionBody
Applies whentype supports SOURCE_LOCATION and location = jsonSource and jsonSource is set
whereClausemultiline stringNodata type=multiline string; maxLen=4000
Applies whentype supports SOURCE_LOCATION and location = jsonSource and jsonSource is set and type = whereOrderByClause
sqlQuerymultiline stringYesdata type=multiline string; maxLen=32767
Applies whentype supports SOURCE_LOCATION and location = jsonSource and jsonSource is set and type = sqlQuery
languageenumYesplsqldata type=string; lov=STATIC
Valid values: plsql javaScript-mle
Applies whentype supports SOURCE_LOCATION and location = jsonSource and jsonSource is set and type = plsqlFunctionBody
plsqlFunctionBodymultiline stringYesdata type=multiline string; maxLen=32767
Applies whentype supports SOURCE_LOCATION and location = jsonSource and jsonSource is set and type = plsqlFunctionBody and language = plsql
javaScriptFunctionBodymultiline stringYesdata type=multiline string; maxLen=32767
Applies whentype supports SOURCE_LOCATION and location = jsonSource and jsonSource is set and type = plsqlFunctionBody and language = javaScript-mle
orderByTypeenumNodata type=string; lov=STATIC
Valid values: staticValue item
Applies whentype supports SOURCE_LOCATION and location = jsonSource and jsonSource is set and type = whereOrderByClause
orderByClausemultiline stringYesdata type=multiline string; maxLen=255
Applies whentype supports SOURCE_LOCATION and location = jsonSource and jsonSource is set and type = whereOrderByClause and orderByType = staticValue
itemcomplexYesdata type=complex; maxLen=32767
Applies whentype supports SOURCE_LOCATION and location = jsonSource and jsonSource is set and type = whereOrderByClause and orderByType = item
orderByItemcomplexNodata type=complex; maxLen=32767
Applies whentype supports SOURCE_LOCATION and location = jsonSource and jsonSource is set and type in (sqlQuery)type supports SOURCE_LOCATION and 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
Applies whentype = chart
autoRefresh {
  interval: 42
}
remoteCache
PropertyTypeRequiredDefault ValueDetails
cachingenumNodata type=string; lov=STATIC
Valid values: allUsers user session
Applies whentype supports SOURCE_LOCATION and location = restEnabledSql
timeoutmultiline stringYesdata type=multiline string; maxLen=255
Applies whentype supports SOURCE_LOCATION and location = 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
Applies whentype = interactiveReport
Enter a description for this Interactive Report.
description {
  description: ```
    value
  ```
}
appearance
PropertyTypeRequiredDefault ValueDetails
templatereferenceNodata type=reference; lov=COMPONENT; references=regionTemplate
Applies whentype supports REGION_TEMPLATE
templateOptionsarray of stringsNodata type=string; lov=TEMPLATE_OPTIONS
Applies whentype supports REGION_TEMPLATE and template is set
cssClassesarray of stringsNodata type=string; maxLen=255
Applies whentype supports REGION_TEMPLATE and template 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 whentype supports REGION_TEMPLATE and template is set
renderComponentsenumYesaboveContentdata type=string; lov=STATIC
Valid values: aboveContent belowContent
Applies whentype supports REGION_TEMPLATE
appearance {
  template: @component
  templateOptions: [
    value
    value
  ]
  cssClasses: [
    value
    value
  ]
  icon: value
  renderComponents: aboveContent
}
accessibility
PropertyTypeRequiredDefault ValueDetails
useLandmarkbooleanYestruedata type=boolean
Applies whentype supports REGION_TEMPLATE and template supports REGION_LANDMARK_ATTRIBUTES
landmarkTypeenumNodata type=string; lov=STATIC
Valid values: banner complementary contentInfo form main navigation region search
Applies whentype supports REGION_TEMPLATE and template supports REGION_LANDMARK_ATTRIBUTES and useLandmark = true
landmarkLabelstringNodata type=string; maxLen=255
Applies whentype supports REGION_TEMPLATE and template supports REGION_LANDMARK_ATTRIBUTES and useLandmark = true
accessibility {
  useLandmark: false
  landmarkType: banner
  landmarkLabel: value
}
image
PropertyTypeRequiredDefault ValueDetails
fileUrlstringNodata type=string; maxLen=255
Applies whentype supports REGION_TEMPLATE and template supports REGION_IMAGEtype supports REGION_TEMPLATE and template supports REGION_IMAGE_URL
accessibleDescriptionstringNodata type=string; maxLen=255
Applies whentype supports REGION_TEMPLATE and template supports REGION_IMAGE_ALT_TEXT and template supports REGION_IMAGE and fileUrl is settype supports REGION_TEMPLATE and template supports REGION_IMAGE_ALT_TEXT and template supports REGION_IMAGE_URL and fileUrl is set
customAttributesstringNodata type=string; maxLen=255
Applies whentype supports REGION_TEMPLATE and template supports REGION_IMAGE_ATTRIBUTES and template supports REGION_IMAGE and fileUrl is settype supports REGION_TEMPLATE and template 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
Applies whentype = interactiveGrid
masterDetail {
  masterRegion: @component
}
headerAndFooter
PropertyTypeRequiredDefault ValueDetails
headerTextmultiline stringNodata type=multiline string; maxLen=4000
Applies whentype supports REGION_TEMPLATE
Enter HTML text displayed at the top of the region, before the #BODY# content.
footerTextmultiline stringNodata type=multiline string; maxLen=4000
Applies whentype supports REGION_TEMPLATE

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
Applies whentype supports ESCAPE_OUTPUT
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 whentype supports ROW_SELECTION and display = report
currentSelectionPageItemstringNodata type=string; maxLen=255; textCase=UPPER
Applies whentype supports ROW_SELECTION and display = report and type in (singleSelection)type supports ROW_SELECTION and display = report and type in (multipleSelection)
selectAllPageItemstringNodata type=string; maxLen=255; textCase=UPPER
Applies whentype supports ROW_SELECTION and display = 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: breadcrumb
    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
    }
)