region (svgChart)
type = svgChart| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
name | string | Yes | data type=string; maxLen=255Enter 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. | |
title | string | No | data type=string; maxLen=255Enter a region title. The region title is optional, it only displays when it is defined in the region template. | |
type | enum | Yes | data type=string; lov=PLUGINSValid values: svgChart |
chart
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
type | enum | Yes | bar | data type=string; lov=STATICValid values: area bar boxPlot bubble combination statusMeterGauge donut funnel gantt line lineWithArea pie polar pyramid radar range scatter stock |
chart {
type: area
}componentAppearance
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
display | enum | Yes | data type=string; lov=STATICValid values: report partial regionOnly | |
layout | enum | Yes | grid | data type=string; lov=STATICValid values: grid float horizontal |
gridColumns | enum | No | data type=string; lov=STATICValid values: 2 3 4 5Applies when layout = grid | |
listTemplate | reference | Yes | data type=reference; lov=COMPONENT; references=listTemplate | |
breadcrumbTemplate | reference | Yes | data type=reference; lov=COMPONENT; references=breadcrumbTemplate | |
cssClasses | array of strings | No | data type=string; maxLen=255Applies when templateType = theme | |
templateOptions | array of strings | No | data type=string; lov=TEMPLATE_OPTIONSApplies when breadcrumbTemplate is setlistTemplate is settemplateType = theme and template is set | |
templateType | enum | Yes | theme | data type=string; lov=STATICValid values: theme predefined |
template | reference | Yes | data type=reference; lov=COMPONENT; references=classicReportTemplateApplies when templateType = theme | |
template | enum | Yes | html | data type=string; lov=STATICValid values: html verticalReport csv xmlApplies when templateType = predefined |
customAttributes | string | No | data type=string; maxLen=2000The 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. | |
showNullValuesAs | string | No | data type=string; maxLen=255 | |
selectFirstRow | boolean | Yes | true | data type=boolean |
fixedRowHeight | boolean | Yes | true | data type=boolean |
componentAppearance {
display: report
layout: grid
gridColumns: "2"
listTemplate: @component
breadcrumbTemplate: @component
cssClasses: [
value
value
]
templateOptions: [
value
value
]
templateType: theme
template: @component
customAttributes: value
showNullValuesAs: value
selectFirstRow: false
fixedRowHeight: false
}edit
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
enabled | boolean | Yes | false | data type=boolean |
allowedOperations | array of enums | No | data type=string; lov=STATICValid values: add update deleteApplies when enabled = true | |
allowedRowOperationsColumn | string | No | data type=string; maxLen=32767Applies when enabled = true and allowedOperations in (update)enabled = true and allowedOperations in (delete) | |
lostUpdateType | enum | Yes | rowValues | data type=string; lov=STATICValid values: rowValues rowVersionColumnApplies when enabled = true |
rowVersionColumn | string | Yes | data type=string; maxLen=32767Applies when enabled = true and lostUpdateType = rowVersionColumn | |
addRowIfEmpty | boolean | Yes | true | data type=booleanApplies when enabled = true and allowedOperations = add |
edit {
enabled: false
allowedOperations: [
add
update
]
allowedRowOperationsColumn: value
lostUpdateType: rowValues
rowVersionColumn: value
addRowIfEmpty: false
}link
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
linkColumn | enum | Yes | exclude | data type=string; lov=STATICValid values: singleRowView customTarget exclude |
uniquelyIdentifyRowsBy | enum | Yes | rowid | data type=string; lov=STATICValid values: rowid uniqueColumnApplies when linkColumn = singleRowView |
uniqueColumn | string | Yes | data type=string; maxLen=32767Applies when linkColumn = singleRowView and uniquelyIdentifyRowsBy = uniqueColumn | |
target | complex | Yes | data type=complex; maxLen=32767Applies when linkColumn = customTarget | |
linkIcon | multiline string | No | data type=multiline string; maxLen=4000Applies when linkColumn in (singleRowView)linkColumn in (customTarget) | |
linkAttributes | string | No | data type=string; maxLen=4000Applies when linkColumn in (singleRowView)linkColumn in (customTarget) | |
authorizationScheme | enum | No | data type=reference; lov=COMPONENT; references=authorizationValid values: mustNotBePublicUserApplies when linkColumn in (singleRowView)linkColumn in (customTarget) | |
conditionType | enum | No | data type=string; lov=STATICValid 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 neverApplies when linkColumn in (singleRowView)linkColumn in (customTarget) | |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=4000Applies when linkColumn in (singleRowView) and conditionType in (rowsReturned)linkColumn in (singleRowView) and conditionType in (noRowsReturned)linkColumn in (customTarget) and conditionType in (rowsReturned)linkColumn in (customTarget) and conditionType in (noRowsReturned) | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: sql plsql javaScript-mleApplies when linkColumn in (singleRowView) and conditionType = expressionlinkColumn in (customTarget) and conditionType = expression |
sqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when linkColumn in (singleRowView) and conditionType = expression and language = sqllinkColumn in (customTarget) and conditionType = expression and language = sql | |
plsqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when linkColumn in (singleRowView) and conditionType = expression and language = plsqllinkColumn in (customTarget) and conditionType = expression and language = plsql | |
javaScriptExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when linkColumn in (singleRowView) and conditionType = expression and language = javaScript-mlelinkColumn in (customTarget) and conditionType = expression and language = javaScript-mle | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when linkColumn in (singleRowView) and conditionType = functionBodylinkColumn in (customTarget) and conditionType = functionBody |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when linkColumn in (singleRowView) and conditionType = functionBody and language = plsqllinkColumn in (customTarget) and conditionType = functionBody and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when linkColumn in (singleRowView) and conditionType = functionBody and language = javaScript-mlelinkColumn in (customTarget) and conditionType = functionBody and language = javaScript-mle | |
value | string | Yes | data type=string; maxLen=4000Applies when linkColumn in (singleRowView) and conditionType in (request=Value)linkColumn in (singleRowView) and conditionType in (request!=Value)linkColumn in (singleRowView) and conditionType in (requestIsContainedInValue)linkColumn in (singleRowView) and conditionType in (requestIsNotContainedInValue)linkColumn in (singleRowView) and conditionType in (currentLanguageIsContainedInValue)linkColumn in (singleRowView) and conditionType in (currentLanguageIsNotContainedInValue)linkColumn in (singleRowView) and conditionType in (currentLanguage!=value)linkColumn in (singleRowView) and conditionType in (currentLanguage=value)linkColumn in (singleRowView) and conditionType in (cgiEnvDadName=value)linkColumn in (singleRowView) and conditionType in (cgiEnvDadName!=value)linkColumn in (singleRowView) and conditionType in (cgiEnvServerName=value)linkColumn in (singleRowView) and conditionType in (cgiEnvServerName!=value)linkColumn in (singleRowView) and conditionType in (cgiEnvHttpHost=value)linkColumn in (singleRowView) and conditionType in (cgiEnvHttpHost!=value)linkColumn in (customTarget) and conditionType in (request=Value)linkColumn in (customTarget) and conditionType in (request!=Value)linkColumn in (customTarget) and conditionType in (requestIsContainedInValue)linkColumn in (customTarget) and conditionType in (requestIsNotContainedInValue)linkColumn in (customTarget) and conditionType in (currentLanguageIsContainedInValue)linkColumn in (customTarget) and conditionType in (currentLanguageIsNotContainedInValue)linkColumn in (customTarget) and conditionType in (currentLanguage!=value)linkColumn in (customTarget) and conditionType in (currentLanguage=value)linkColumn in (customTarget) and conditionType in (cgiEnvDadName=value)linkColumn in (customTarget) and conditionType in (cgiEnvDadName!=value)linkColumn in (customTarget) and conditionType in (cgiEnvServerName=value)linkColumn in (customTarget) and conditionType in (cgiEnvServerName!=value)linkColumn in (customTarget) and conditionType in (cgiEnvHttpHost=value)linkColumn in (customTarget) and conditionType in (cgiEnvHttpHost!=value) | |
item | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when linkColumn in (singleRowView) and conditionType in (item=value)linkColumn in (singleRowView) and conditionType in (item!=value)linkColumn in (singleRowView) and conditionType in (VALUE_OF_ITEM_IN_COND_1_EQ_COND_2)linkColumn in (singleRowView) and conditionType in (VALUE_OF_ITEM_IN_COND_1_NOT_EQ_COND_2)linkColumn in (singleRowView) and conditionType in (itemIsNull)linkColumn in (singleRowView) and conditionType in (itemIsNotNull)linkColumn in (singleRowView) and conditionType in (itemIsZero)linkColumn in (singleRowView) and conditionType in (itemIsNotZero)linkColumn in (singleRowView) and conditionType in (itemIsNullOrZero)linkColumn in (singleRowView) and conditionType in (itemIsNotNullAndNotZero)linkColumn in (singleRowView) and conditionType in (itemContainsNoSpaces)linkColumn in (singleRowView) and conditionType in (itemIsNumeric)linkColumn in (singleRowView) and conditionType in (itemIsNotNumeric)linkColumn in (singleRowView) and conditionType in (itemIsAlphanumeric)linkColumn in (singleRowView) and conditionType in (itemIsInColonDelimitedList)linkColumn in (singleRowView) and conditionType in (itemIsNotInColonDelimitedList)linkColumn in (customTarget) and conditionType in (item=value)linkColumn in (customTarget) and conditionType in (item!=value)linkColumn in (customTarget) and conditionType in (VALUE_OF_ITEM_IN_COND_1_EQ_COND_2)linkColumn in (customTarget) and conditionType in (VALUE_OF_ITEM_IN_COND_1_NOT_EQ_COND_2)linkColumn in (customTarget) and conditionType in (itemIsNull)linkColumn in (customTarget) and conditionType in (itemIsNotNull)linkColumn in (customTarget) and conditionType in (itemIsZero)linkColumn in (customTarget) and conditionType in (itemIsNotZero)linkColumn in (customTarget) and conditionType in (itemIsNullOrZero)linkColumn in (customTarget) and conditionType in (itemIsNotNullAndNotZero)linkColumn in (customTarget) and conditionType in (itemContainsNoSpaces)linkColumn in (customTarget) and conditionType in (itemIsNumeric)linkColumn in (customTarget) and conditionType in (itemIsNotNumeric)linkColumn in (customTarget) and conditionType in (itemIsAlphanumeric)linkColumn in (customTarget) and conditionType in (itemIsInColonDelimitedList)linkColumn in (customTarget) and conditionType in (itemIsNotInColonDelimitedList) | |
preference | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when linkColumn in (singleRowView) and conditionType in (userPreference=value)linkColumn in (singleRowView) and conditionType in (userPreference!=value)linkColumn in (customTarget) and conditionType in (userPreference=value)linkColumn in (customTarget) and conditionType in (userPreference!=value) | |
page | integer | Yes | data type=integer; maxLen=4000Applies when linkColumn in (singleRowView) and conditionType in (currentPage=page)linkColumn in (singleRowView) and conditionType in (currentPage!=page)linkColumn in (customTarget) and conditionType in (currentPage=page)linkColumn in (customTarget) and conditionType in (currentPage!=page) | |
pages | array of integers | Yes | data type=integer; maxLen=4000Applies when linkColumn in (singleRowView) and conditionType in (currentPageInList)linkColumn in (singleRowView) and conditionType in (currentPageNotInList)linkColumn in (customTarget) and conditionType in (currentPageInList)linkColumn in (customTarget) and conditionType in (currentPageNotInList) | |
text | string | Yes | data type=string; maxLen=4000Applies when linkColumn in (singleRowView) and conditionType in (textIsContainedInItem)linkColumn in (singleRowView) and conditionType in (textIsContainedInValue)linkColumn in (singleRowView) and conditionType in (textIsNotContainedInValue)linkColumn in (singleRowView) and conditionType in (text=value)linkColumn in (singleRowView) and conditionType in (text!=value)linkColumn in (customTarget) and conditionType in (textIsContainedInItem)linkColumn in (customTarget) and conditionType in (textIsContainedInValue)linkColumn in (customTarget) and conditionType in (textIsNotContainedInValue)linkColumn in (customTarget) and conditionType in (text=value)linkColumn in (customTarget) and conditionType in (text!=value) | |
value | string | Yes | data type=string; maxLen=4000Applies when linkColumn in (singleRowView) and conditionType in (item=value)linkColumn in (singleRowView) and conditionType in (item!=value)linkColumn in (singleRowView) and conditionType in (VALUE_OF_ITEM_IN_COND_1_EQ_COND_2)linkColumn in (singleRowView) and conditionType in (VALUE_OF_ITEM_IN_COND_1_NOT_EQ_COND_2)linkColumn in (singleRowView) and conditionType in (userPreference=value)linkColumn in (singleRowView) and conditionType in (userPreference!=value)linkColumn in (customTarget) and conditionType in (item=value)linkColumn in (customTarget) and conditionType in (item!=value)linkColumn in (customTarget) and conditionType in (VALUE_OF_ITEM_IN_COND_1_EQ_COND_2)linkColumn in (customTarget) and conditionType in (VALUE_OF_ITEM_IN_COND_1_NOT_EQ_COND_2)linkColumn in (customTarget) and conditionType in (userPreference=value)linkColumn in (customTarget) and conditionType in (userPreference!=value) | |
list | array of strings | Yes | data type=string; maxLen=4000Applies when linkColumn in (singleRowView) and conditionType in (itemIsInColonDelimitedList)linkColumn in (singleRowView) and conditionType in (itemIsNotInColonDelimitedList)linkColumn in (customTarget) and conditionType in (itemIsInColonDelimitedList)linkColumn in (customTarget) and conditionType in (itemIsNotInColonDelimitedList) | |
item | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when linkColumn in (singleRowView) and conditionType = textIsContainedInItemlinkColumn in (customTarget) and conditionType = textIsContainedInItem | |
value | string | Yes | data type=string; maxLen=4000Applies when linkColumn in (singleRowView) and conditionType in (textIsContainedInValue)linkColumn in (singleRowView) and conditionType in (textIsNotContainedInValue)linkColumn in (singleRowView) and conditionType in (text=value)linkColumn in (singleRowView) and conditionType in (text!=value)linkColumn in (customTarget) and conditionType in (textIsContainedInValue)linkColumn in (customTarget) and conditionType in (textIsNotContainedInValue)linkColumn in (customTarget) and conditionType in (text=value)linkColumn in (customTarget) and conditionType in (text!=value) |
link {
linkColumn: singleRowView
uniquelyIdentifyRowsBy: rowid
uniqueColumn: value
target: {
type: in_app
url: value
app: value
page: value
items: [
value
value
]
clearCache: value
action: value
request: value
anchor: value
session: "&SESSION."
debug: "&DEBUG."
printerFriendly: N
otherArgs: value
}
linkIcon: ```
value
```
linkAttributes: value
authorizationScheme: mustNotBePublicUser
conditionType: always
sqlQuery: ```sql
value
```
language: sql
sqlExpression: ```sql
value
```
plsqlExpression: ```plsql
value
```
javaScriptExpression: ```javascript-mle
value
```
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
value: value
item: value
preference: value
page: 42
pages: [
42
42
]
text: value
list: [
value
value
]
}map
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
background | enum | Yes | default | data type=string; lov=STATICValid values: default builtIn sharedComponent |
standard | enum | Yes | openstreetmapPositron | data type=string; lov=STATICValid values: openstreetmapPositron openstreetmapDark openstreetmapBright oracleWorldMap oracleBiWorldMapApplies when background = builtIn |
darkMode | enum | No | data type=string; lov=STATICValid values: openstreetmapDark openstreetmapPositron openstreetmapBright oracleWorldMap oracleBiWorldMapApplies when background = builtIn | |
standard | reference | Yes | data type=reference; lov=COMPONENT; references=mapBackgroundApplies when background = sharedComponent | |
darkMode | reference | No | data type=reference; lov=COMPONENT; references=mapBackgroundApplies when background = sharedComponent | |
height | number | Yes | 640 | data type=number; maxLen=22 |
map {
background: default
standard: openstreetmapPositron
darkMode: openstreetmapDark
height: 42
}output
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
layout | reference | No | data type=reference; lov=COMPONENT; references=reportLayoutApplies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = true | |
linkText | string | No | data type=string; maxLen=255Applies when enabled = true | |
format | enum | No | data type=string; lov=STATICValid values: pdf word excel html xmlApplies when enabled = true | |
viewFileAs | enum | Yes | attachment | data type=string; lov=STATICValid values: attachment inlineApplies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = true |
formatItem | string | Yes | data type=string; maxLen=255; textCase=UPPERApplies when enabled = true | |
fileName | string | No | data type=string; maxLen=255Applies when enabled = true |
output {
layout: @component
linkText: value
format: pdf
viewFileAs: attachment
formatItem: value
fileName: value
}page
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
size | enum | Yes | letter | data type=string; lov=STATICValid values: letter legal tabloid a4 a3 customApplies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
orientation | enum | Yes | landscape | data type=string; lov=STATICValid values: portrait landscapeApplies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
units | enum | Yes | inches | data type=string; lov=STATICValid values: inches millimeters centimeters pointsApplies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
width | number | Yes | 11 | data type=number; maxLen=22Applies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
height | number | Yes | 8.5 | data type=number; maxLen=22Applies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
borderWidth | number | No | data type=number; maxLen=255Applies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) | |
borderColor | string | No | data type=string; maxLen=255Applies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
page {
size: letter
orientation: portrait
units: inches
width: 42
height: 42
borderWidth: 42
borderColor: value
}reportLayout
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
numberOfRowsType | enum | Yes | staticValue | data type=string; lov=STATICValid values: staticValue itemValue |
numberOfRows | integer | Yes | 15 | data type=integer; maxLen=32767Applies when numberOfRowsType = staticValue |
item | string | Yes | data type=string; maxLen=255; textCase=UPPERApplies when numberOfRowsType = itemValue |
reportLayout {
numberOfRowsType: staticValue
numberOfRows: 42
item: value
}title
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
title | string | No | data type=string; maxLen=255 | |
advancedFormatting | boolean | Yes | false | data type=boolean |
column | string | No | data type=string; maxLen=32767Applies when advancedFormatting = false | |
htmlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when advancedFormatting = true | |
cssClasses | array of strings | No | data type=string; maxLen=255Applies when advancedFormatting = false |
title {
title: value
advancedFormatting: false
column: value
htmlExpression: ```html
value
```
cssClasses: [
value
value
]
}chartAppearance
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
orientation | enum | Yes | vertical | data type=string; lov=STATICValid values: vertical horizontalApplies when type in (area)type in (bar)type in (combination)type in (funnel)type in (line)type in (lineWithArea)type in (boxPlot)type in (range) |
stack | boolean | Yes | off | data type=booleanApplies when type in (area)type in (bar)type in (line)type in (lineWithArea)type in (combination)type in (polar)type in (radar) |
stackLabel | boolean | Yes | off | data type=booleanApplies when type = bar and type in (area) and stack = ontype = bar and type in (bar) and stack = ontype = bar and type in (line) and stack = ontype = bar and type in (lineWithArea) and stack = ontype = bar and type in (combination) and stack = ontype = bar and type in (polar) and stack = ontype = bar and type in (radar) and stack = on |
fontFamily | enum | No | data type=string; lov=STATICValid values: arial arialBlack bookman comicSansMs courier courierNew garamond georgia helvetica impact palatino times timesNewRoman trebuchetMs verdanaApplies when type = bar and type in (area) and stack = on and stackLabel = ontype = bar and type in (bar) and stack = on and stackLabel = ontype = bar and type in (line) and stack = on and stackLabel = ontype = bar and type in (lineWithArea) and stack = on and stackLabel = ontype = bar and type in (combination) and stack = on and stackLabel = ontype = bar and type in (polar) and stack = on and stackLabel = ontype = bar and type in (radar) and stack = on and stackLabel = on | |
fontStyle | enum | No | data type=string; lov=STATICValid values: normal italic obliqueApplies when type = bar and type in (area) and stack = on and stackLabel = ontype = bar and type in (bar) and stack = on and stackLabel = ontype = bar and type in (line) and stack = on and stackLabel = ontype = bar and type in (lineWithArea) and stack = on and stackLabel = ontype = bar and type in (combination) and stack = on and stackLabel = ontype = bar and type in (polar) and stack = on and stackLabel = ontype = bar and type in (radar) and stack = on and stackLabel = on | |
fontSize | enum | No | data type=string; lov=STATICValid values: 8 10 12 14 16 18 20 22Applies when type = bar and type in (area) and stack = on and stackLabel = ontype = bar and type in (bar) and stack = on and stackLabel = ontype = bar and type in (line) and stack = on and stackLabel = ontype = bar and type in (lineWithArea) and stack = on and stackLabel = ontype = bar and type in (combination) and stack = on and stackLabel = ontype = bar and type in (polar) and stack = on and stackLabel = ontype = bar and type in (radar) and stack = on and stackLabel = on | |
fontColor | string | No | data type=string; maxLen=255Applies when type = bar and type in (area) and stack = on and stackLabel = ontype = bar and type in (bar) and stack = on and stackLabel = ontype = bar and type in (line) and stack = on and stackLabel = ontype = bar and type in (lineWithArea) and stack = on and stackLabel = ontype = bar and type in (combination) and stack = on and stackLabel = ontype = bar and type in (polar) and stack = on and stackLabel = ontype = bar and type in (radar) and stack = on and stackLabel = on |
chartAppearance {
orientation: vertical
stack: false
stackLabel: false
fontFamily: arial
fontStyle: normal
fontSize: "8"
fontColor: value
}card
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
cssClasses | array of strings | No | data type=string; maxLen=255 | |
primaryKeyColumn1 | string | No | data type=string; maxLen=32767 | |
primaryKeyColumn2 | string | No | data type=string; maxLen=32767Applies when primaryKeyColumn1 is set |
card {
cssClasses: [
value
value
]
primaryKeyColumn1: value
primaryKeyColumn2: value
}source
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
sqlQuery | multiline string | No | data type=multiline string; maxLen=32767 | |
plsqlCode | multiline string | No | data type=multiline string; maxLen=32767Enter the PL/SQL code to generate the HTML output. | |
plsqlFunctionBody | multiline string | No | data type=multiline string; maxLen=32767 | |
htmlCode | multiline string | No | data type=multiline string; maxLen=32767 | |
text | multiline string | No | data type=multiline string; maxLen=32767 | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mle |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=32767Applies when language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=32767Applies when language = javaScript-mle | |
location | enum | No | localDatabase | data type=string; lov=STATICValid values: localDatabase restEnabledSql restSource jsonDualityView jsonSource sampleData |
remoteServer | reference | Yes | data type=reference; lov=COMPONENT; references=restEnabledSqlDatabaseApplies when location = restEnabledSql | |
sampleData | enum | Yes | data type=string; lov=STATICValid values: employees tasks products projectsApplies when location = sampleData | |
type | enum | Yes | tableView | data type=string; lov=STATICValid values: tableView sqlQuery functionBody propertyGraphApplies when location in (localDatabase)location in (restEnabledSql) |
tableOwner | string | No | data type=string; maxLen=32767Applies when location in (localDatabase) and type = tableViewlocation in (restEnabledSql) and type = tableView | |
tableName | string | Yes | data type=string; maxLen=128Applies when location in (localDatabase) and type = tableViewlocation in (restEnabledSql) and type = tableView | |
includeRowidColumn | boolean | Yes | false | data type=booleanApplies when location in (localDatabase) and type = tableView and location = restEnabledSql and remoteServer supports IS_ORACLElocation in (restEnabledSql) and type = tableView and location = restEnabledSql and remoteServer supports IS_ORACLE |
whereClause | multiline string | No | data type=multiline string; maxLen=4000Applies when location in (localDatabase) and type = tableViewlocation in (restEnabledSql) and type = tableView | |
graphOwner | string | No | data type=string; maxLen=32767Applies when location in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type = propertyGraph | |
graphName | string | Yes | data type=string; maxLen=32767Applies when location in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type = propertyGraph | |
matchClause | multiline string | Yes | data type=multiline string; maxLen=4000Applies when location in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type = propertyGraph | |
columnsClause | multiline string | Yes | data type=multiline string; maxLen=4000Applies when location in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type = propertyGraph | |
whereClause | multiline string | No | data type=multiline string; maxLen=4000Applies when location in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type = propertyGraph | |
orderByClause | multiline string | No | data type=multiline string; maxLen=255Applies when location in (localDatabase) and type = tableViewlocation in (restEnabledSql) and type = tableView | |
orderByClause | multiline string | No | data type=multiline string; maxLen=255Applies when location in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type = propertyGraph | |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=32767Applies when location in (localDatabase) and type = sqlQuerylocation in (restEnabledSql) and type = sqlQuery | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when location in (localDatabase) and type = functionBodylocation in (restEnabledSql) and type = functionBody |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=32767Applies when location in (localDatabase) and type = functionBody and language = plsqllocation in (restEnabledSql) and type = functionBody and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=32767Applies when location in (localDatabase) and type = functionBody and language = javaScript-mlelocation in (restEnabledSql) and type = functionBody and language = javaScript-mle | |
restSource | reference | Yes | data type=reference; lov=COMPONENT; references=restDataSourceApplies when location = restSource | |
jsonDualityView | reference | Yes | data type=reference; lov=COMPONENT; references=jsonDualityViewApplies when location = jsonDualityView | |
jsonSource | reference | Yes | data type=reference; lov=COMPONENT; references=jsonSourceApplies when location = jsonSource | |
list | reference | Yes | data type=reference; lov=COMPONENT; references=list | |
breadcrumb | reference | Yes | data type=reference; lov=COMPONENT; references=breadcrumb | |
filteredRegion | reference | Yes | data type=reference; lov=COMPONENT; references=region | |
pageItemsToSubmit | array of strings | No | data type=string; maxLen=4000; textCase=UPPER | |
optimizerHint | string | No | data type=string; maxLen=255Applies when location in (localDatabase)location in (restEnabledSql)location in (restSource)location in (jsonDualityView)location in (jsonSource) | |
useGenericColumnNames | boolean | Yes | DERIVED_REPORT_COLUMNS | data type=booleanApplies when location in (localDatabase) and type = functionBodylocation in (restEnabledSql) and type = functionBody |
genericColumnCount | integer | Yes | data type=integer; maxLen=3Applies when location in (localDatabase) and type = functionBody and useGenericColumnNames = GENERIC_REPORT_COLUMNSlocation in (restEnabledSql) and type = functionBody and useGenericColumnNames = GENERIC_REPORT_COLUMNS |
source {
plsqlCode: ```plsql
value
```
htmlCode: ```html
value
```
text: ```
value
```
language: plsql
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
location: localDatabase
remoteServer: @component
sampleData: employees
type: tableView
tableOwner: value
tableName: value
includeRowidColumn: false
whereClause: ```sql
value
```
graphOwner: value
graphName: value
matchClause: ```
value
```
columnsClause: ```
value
```
orderByClause: ```sql
value
```
sqlQuery: ```sql
value
```
restSource: @component
jsonDualityView: @component
jsonSource: @component
list: @component
breadcrumb: @component
filteredRegion: @component
pageItemsToSubmit: [
value
value
]
optimizerHint: value
useGenericColumnNames: false
genericColumnCount: 42
}controls
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
navigationBar | enum | Yes | zoomAndCompass | data type=string; lov=STATICValid values: none zoomOnly zoomAndCompass |
navigationBarPosition | enum | Yes | end | data type=string; lov=STATICValid values: start end |
options | array of enums | No | data type=string; lov=STATICValid values: mousewheelZoom rectangleZoom scaleBar overviewMap infiniteMap getBrowserLocation circleTool distanceTool |
controls {
navigationBar: none
navigationBarPosition: start
options: [
mousewheelZoom
rectangleZoom
]
}editAuthorization
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
add | enum | No | data type=reference; lov=COMPONENT; references=authorizationValid values: mustNotBePublicUserApplies when enabled = true and allowedOperations = add | |
update | enum | No | data type=reference; lov=COMPONENT; references=authorizationValid values: mustNotBePublicUserApplies when enabled = true and allowedOperations = update | |
delete | enum | No | data type=reference; lov=COMPONENT; references=authorizationValid values: mustNotBePublicUserApplies when enabled = true and allowedOperations = delete |
editAuthorization {
add: mustNotBePublicUser
update: mustNotBePublicUser
delete: mustNotBePublicUser
}pageHeader
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
font | enum | Yes | helvetica | data type=string; lov=STATICValid values: helvetica times courierApplies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
fontWeight | enum | Yes | normal | data type=string; lov=STATICValid values: normal boldApplies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
fontSize | integer | Yes | 12 | data type=integer; maxLen=32767Applies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
fontColor | string | Yes | #000000 | data type=string; maxLen=255Applies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
alignment | enum | Yes | center | data type=string; lov=STATICValid values: start center endApplies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
pageHeaderText | multiline string | No | data type=multiline string; maxLen=4000Applies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
pageHeader {
font: helvetica
fontWeight: normal
fontSize: 42
fontColor: value
alignment: start
pageHeaderText: ```
value
```
}chartLayout
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
maxWidth | integer | No | data type=integer; maxLen=32767 | |
height | integer | No | data type=integer; maxLen=32767 |
chartLayout {
maxWidth: 42
height: 42
}initialPositionAndZoom
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
getPositionFromBrowser | boolean | Yes | false | data type=booleanApplies when options = getBrowserLocation |
type | enum | Yes | basedOnSpatialResults | data type=string; lov=STATICValid values: staticValues sqlQuery basedOnSpatialResults |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=32767Applies when type = sqlQuery | |
geometryColumnDataType | enum | Yes | data type=string; lov=STATICValid values: sdoGeometry geojson longitudeLatitudeApplies when type = sqlQuery | |
initialLongitudeColumn | string | Yes | data type=string; maxLen=32767Applies when type = sqlQuery and geometryColumnDataType = longitudeLatitude | |
initialLatitudeColumn | string | Yes | data type=string; maxLen=32767Applies when type = sqlQuery and geometryColumnDataType = longitudeLatitude | |
geometryColumn | string | Yes | data type=string; maxLen=32767Applies when type = sqlQuery and geometryColumnDataType = sdoGeometry | |
geojsonColumn | string | Yes | data type=string; maxLen=32767Applies when type = sqlQuery and geometryColumnDataType = geojson | |
initialZoomlevelColumn | string | No | data type=string; maxLen=32767Applies when type = sqlQuery | |
longitude | string | Yes | data type=string; maxLen=32767Applies when type = staticValues | |
latitude | string | Yes | data type=string; maxLen=32767Applies when type = staticValues | |
zoomLevel | string | No | data type=string; maxLen=32767Applies when type in (staticValues)type in (basedOnSpatialResults) |
initialPositionAndZoom {
getPositionFromBrowser: false
type: staticValues
sqlQuery: ```sql
value
```
geometryColumnDataType: sdoGeometry
initialLongitudeColumn: value
initialLatitudeColumn: value
geometryColumn: value
geojsonColumn: value
initialZoomlevelColumn: value
longitude: value
latitude: value
zoomLevel: value
}performance
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
lazyLoading | boolean | Yes | false | data type=booleanApplies when partialPageRefresh = truelocation is set |
maxRowsToProcess | integer | No | data type=integer; maxLen=32767 | |
lazyLoading | boolean | Yes | false | data type=boolean |
performance {
lazyLoading: false
maxRowsToProcess: 42
}pagination
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
type | enum | Yes | nextAndPreviousLinks | data type=string; lov=STATICValid values: showAll rowRangesXToYNoPagination rowRangesXToYOfZNoPagination rowRangesXToYOfZWithPagination setPaginationLinks setPaginationSelectList setPaginationSearchEngine externalPaginationButtons nextAndPreviousLinks |
displayPosition | enum | Yes | bottomRight | data type=string; lov=STATICValid values: bottomLeft bottomRight topLeft topRight topAndBottomLeft topAndBottomRightApplies when type is set |
partialPageRefresh | boolean | Yes | true | data type=boolean |
type | enum | Yes | scroll | data type=string; lov=STATICValid values: page scrollApplies when display = report |
showTotalCount | boolean | Yes | true | data type=booleanApplies when display = report |
type | enum | No | data type=string; lov=STATICValid values: rowRangesXToYOfZ rowRangesXToY | |
maxRowsToDisplay | string | No | data type=string; maxLen=32767 | |
cardsPerPage | integer | Yes | 15 | data type=integer; maxLen=32767Applies when type = page |
entitiesPerPage | integer | Yes | 15 | data type=integer; maxLen=32767Applies when display = report and type = page |
initialEntitiesCount | integer | No | data type=integer; maxLen=32767Applies when display = report and type = scroll |
pagination {
type: showAll
displayPosition: bottomLeft
partialPageRefresh: false
showTotalCount: false
maxRowsToDisplay: value
cardsPerPage: 42
entitiesPerPage: 42
initialEntitiesCount: 42
}gauge
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
orientation | enum | Yes | circular | data type=string; lov=STATICValid values: circular horizontal verticalApplies when type = statusMeterGauge |
showPlotArea | boolean | Yes | on | data type=booleanApplies when type = statusMeterGauge |
indicatorSize | number | Yes | 1 | data type=number; maxLen=22Applies when type = statusMeterGauge |
innerRadius | number | Yes | 0.7 | data type=number; maxLen=22Applies when type = statusMeterGauge and orientation = circular |
startAngle | number | Yes | 90 | data type=number; maxLen=22Applies when type = statusMeterGauge and orientation = circular |
angleExtent | number | Yes | 360 | data type=number; maxLen=22Applies when type = statusMeterGauge and orientation = circular |
gauge {
orientation: circular
showPlotArea: false
indicatorSize: 42
innerRadius: 42
startAngle: 42
angleExtent: 42
}columnHeadings
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
font | enum | Yes | helvetica | data type=string; lov=STATICValid values: helvetica times courierApplies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
fontWeight | enum | Yes | bold | data type=string; lov=STATICValid values: normal boldApplies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
fontSize | integer | Yes | 10 | data type=integer; maxLen=32767Applies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
fontColor | string | Yes | #000000 | data type=string; maxLen=255Applies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
backgroundColor | string | Yes | #EEEEEE | data type=string; maxLen=255Applies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
columnHeadings {
font: helvetica
fontWeight: normal
fontSize: 42
fontColor: value
backgroundColor: value
}subtitle
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
advancedFormatting | boolean | Yes | false | data type=boolean |
column | string | No | data type=string; maxLen=32767Applies when advancedFormatting = false | |
htmlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when advancedFormatting = true | |
cssClasses | array of strings | No | data type=string; maxLen=255Applies when advancedFormatting = false |
subtitle {
advancedFormatting: false
column: value
htmlExpression: ```html
value
```
cssClasses: [
value
value
]
}messages
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
whenNoDataFound | multiline string | No | data type=multiline string; maxLen=4000Applies when display = report | |
whenMoreDataFound | multiline string | No | data type=multiline string; maxLen=4000 | |
noDataFoundIcon | string | No | data type=string; maxLen=4000Applies when whenNoDataFound is setdisplay = report and whenNoDataFound is set |
messages {
whenNoDataFound: ```
value
```
whenMoreDataFound: ```
value
```
noDataFoundIcon: value
}toolbar
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
show | boolean | Yes | true | data type=boolean |
controls | array of enums | No | data type=string; lov=STATICValid values: searchCol searchField actionsMenu resetButton saveButtonApplies when show = true | |
addButtonLabel | string | No | data type=string; maxLen=255Applies when show = true and enabled = true and allowedOperations = add |
toolbar {
show: false
controls: [
searchCol
searchField
]
addButtonLabel: value
}body
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
advancedFormatting | boolean | Yes | false | data type=boolean |
column | string | No | data type=string; maxLen=32767Applies when advancedFormatting = false | |
htmlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when advancedFormatting = true | |
cssClasses | array of strings | No | data type=string; maxLen=255Applies when advancedFormatting = false |
body {
advancedFormatting: false
column: value
htmlExpression: ```html
value
```
cssClasses: [
value
value
]
}breakFormatting
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
reportSumLabel | string | No | data type=string; maxLen=255 | |
breakColumns | enum | No | data type=string; lov=STATICValid values: col1 cols1-2 cols1-3 | |
style | enum | Yes | default | data type=string; lov=STATICValid values: repeatHeadings defaultApplies when breakColumns is set |
repeatHeadingFormat | multiline string | No | data type=multiline string; maxLen=4000Applies when breakColumns is set and style = repeatHeadings | |
reportBreakFormat | string | No | data type=string; maxLen=2000Applies when breakColumns is set | |
beforeRow | string | No | data type=string; maxLen=2000Applies when breakColumns is set | |
columnBreakFormat | string | No | data type=string; maxLen=2000Applies when breakColumns is set | |
afterRow | string | No | data type=string; maxLen=2000Applies when breakColumns is set |
breakFormatting {
reportSumLabel: value
breakColumns: col1
style: repeatHeadings
repeatHeadingFormat: ```
value
```
reportBreakFormat: value
beforeRow: value
columnBreakFormat: value
afterRow: value
}columns
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
font | enum | Yes | helvetica | data type=string; lov=STATICValid values: helvetica times courierApplies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
fontWeight | enum | Yes | normal | data type=string; lov=STATICValid values: normal boldApplies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
fontSize | integer | Yes | 10 | data type=integer; maxLen=32767Applies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
fontColor | string | Yes | #000000 | data type=string; maxLen=255Applies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
backgroundColor | string | Yes | #FFFFFF | data type=string; maxLen=255Applies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
widthUnits | enum | Yes | percent | data type=string; lov=STATICValid values: percent pointApplies when enabled = true |
columns {
font: helvetica
fontWeight: normal
fontSize: 42
fontColor: value
backgroundColor: value
widthUnits: percent
}dataCursor
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
cursor | enum | Yes | auto | data type=string; lov=STATICValid values: auto true false |
behavior | enum | Yes | auto | data type=string; lov=STATICValid values: auto smooth snapApplies when cursor in (auto)cursor in (true) |
dimOnHover | boolean | Yes | dim | data type=boolean |
dataCursor {
cursor: auto
behavior: auto
dimOnHover: false
}enableUsersTo
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
savePublicReport | boolean | Yes | false | data type=boolean |
savePublicReportAuthorization | enum | No | data type=reference; lov=COMPONENT; references=authorizationValid values: mustNotBePublicUserApplies when savePublicReport = true | |
flashback | boolean | Yes | true | data type=boolean |
defineChartView | boolean | Yes | true | data type=boolean |
download | boolean | Yes | true | data type=boolean |
enableUsersTo {
savePublicReport: false
savePublicReportAuthorization: mustNotBePublicUser
flashback: false
defineChartView: false
download: false
}boundingBox
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
type | enum | No | data type=string; lov=STATICValid values: staticValues sqlQuery | |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = sqlQuery | |
geometryColumnDataType | enum | Yes | sdoGeometry | data type=string; lov=STATICValid values: sdoGeometry longitudeLatitudeApplies when type = sqlQuery |
minLongitude | string | Yes | data type=string; maxLen=32767Applies when type = sqlQuery and geometryColumnDataType = longitudeLatitude | |
minLatitude | string | Yes | data type=string; maxLen=32767Applies when type = sqlQuery and geometryColumnDataType = longitudeLatitude | |
maxLongitude | string | Yes | data type=string; maxLen=32767Applies when type = sqlQuery and geometryColumnDataType = longitudeLatitude | |
maxLatitude | string | Yes | data type=string; maxLen=32767Applies when type = sqlQuery and geometryColumnDataType = longitudeLatitude | |
geometryColumn | string | Yes | data type=string; maxLen=32767Applies when type = sqlQuery and geometryColumnDataType = sdoGeometry | |
minLongitude | string | Yes | data type=string; maxLen=128Applies when type = staticValues | |
minLatitude | string | Yes | data type=string; maxLen=128Applies when type = staticValues | |
maxLongitude | string | Yes | data type=string; maxLen=128Applies when type = staticValues | |
maxLatitude | string | Yes | data type=string; maxLen=128Applies when type = staticValues | |
currentBoundsItem | string | No | data type=string; maxLen=32767; textCase=UPPER |
boundingBox {
type: staticValues
sqlQuery: ```sql
value
```
geometryColumnDataType: sdoGeometry
minLongitude: value
minLatitude: value
maxLongitude: value
maxLatitude: value
geometryColumn: value
currentBoundsItem: value
}multiSeriesChartData
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
fillGapsInChartData | boolean | Yes | true | data type=boolean |
sortOrder | enum | Yes | labelAsc | data type=string; lov=STATICValid values: valueAsc valueDesc labelAsc labelDescApplies when fillGapsInChartData = true |
renderGapAsZero | boolean | Yes | true | data type=booleanApplies when type in (line) and fillGapsInChartData = truetype in (lineWithArea) and fillGapsInChartData = truetype in (area) and fillGapsInChartData = truetype in (scatter) and fillGapsInChartData = truetype in (bar) and fillGapsInChartData = truetype in (combination) and fillGapsInChartData = true |
multiSeriesChartData {
fillGapsInChartData: false
sortOrder: valueAsc
renderGapAsZero: false
}secondaryBody
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
advancedFormatting | boolean | Yes | false | data type=boolean |
column | string | No | data type=string; maxLen=32767Applies when advancedFormatting = false | |
htmlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when advancedFormatting = true | |
cssClasses | array of strings | No | data type=string; maxLen=255Applies when advancedFormatting = false |
secondaryBody {
advancedFormatting: false
column: value
htmlExpression: ```html
value
```
cssClasses: [
value
value
]
}pageFooter
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
font | enum | Yes | helvetica | data type=string; lov=STATICValid values: helvetica times courierApplies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
fontWeight | enum | Yes | normal | data type=string; lov=STATICValid values: normal boldApplies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
fontSize | integer | Yes | 12 | data type=integer; maxLen=32767Applies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
fontColor | string | Yes | #000000 | data type=string; maxLen=255Applies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
alignment | enum | Yes | center | data type=string; lov=STATICValid values: start center endApplies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
pageFooterText | multiline string | No | data type=multiline string; maxLen=4000Applies when includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)enabled = truedownload = true and formats in (excel)download = true and formats in (pdf) |
pageFooter {
font: helvetica
fontWeight: normal
fontSize: 42
fontColor: value
alignment: start
pageFooterText: ```
value
```
}download
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
authorization | enum | No | data type=reference; lov=COMPONENT; references=authorizationValid values: mustNotBePublicUserApplies when download = trueincludeSearchBar = true and includeActionsMenu = true and download = true | |
formats | array of enums | No | data type=string; lov=STATICValid values: csv html pdf excelApplies when download = true | |
sendAsEmail | boolean | Yes | true | data type=booleanApplies when download = trueincludeSearchBar = true and includeActionsMenu = true and download = true |
csvSeparator | string | No | data type=string; maxLen=2Applies when csvExportEnabled = truedownload = true and formats = csvincludeSearchBar = true and includeActionsMenu = true and download = true and formats = csv | |
csvEnclosedBy | string | No | data type=string; maxLen=1Applies when csvExportEnabled = truedownload = true and formats = csvincludeSearchBar = true and includeActionsMenu = true and download = true and formats = csv | |
csvExportEnabled | boolean | Yes | false | data type=boolean |
filename | string | No | data type=string; maxLen=255Applies when csvExportEnabled = truedownload = trueincludeSearchBar = true and includeActionsMenu = true and download = true | |
supplementalText | multiline string | No | data type=multiline string; maxLen=4000Applies when download = true and formats is setincludeSearchBar = true and includeActionsMenu = true and download = true and formats is set | |
linkText | string | Yes | Download | data type=string; maxLen=255Applies when csvExportEnabled = true |
formats | array of enums | Yes | CSV:HTML:XLSX:PDF | data type=string; lov=STATICValid values: csv html excel pdfApplies when 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
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
timeAxisType | enum | No | data type=string; lov=STATICValid values: auto disabled enabled mixedFrequency skipGapsApplies when type in (area)type in (bar)type in (line)type in (lineWithArea)type in (stock)type in (boxPlot)type in (combination) | |
zoomAndScroll | enum | Yes | false | data type=string; lov=STATICValid values: false delayed delayedScrollOnly live liveScrollOnlySpecify 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. |
zoomDirection | enum | Yes | bothAxes | data type=string; lov=STATICValid values: bothAxes xAxis yAxisApplies when type in (bubble)type in (scatter) |
initialZooming | enum | Yes | none | data type=string; lov=STATICValid values: first last noneApplies when type in (bar)type in (line)type in (area)type in (lineWithArea)type in (combination)type in (stock) |
showHorizontalGrid | enum | Yes | auto | data type=string; lov=STATICValid values: auto true falseApplies when type = gantt |
showVerticalGrid | enum | Yes | auto | data type=string; lov=STATICValid values: auto true falseApplies when type = gantt |
showRowAxis | boolean | Yes | on | data type=booleanApplies when type = gantt |
axisPosition | enum | Yes | top | data type=string; lov=STATICValid values: top bottomApplies when type = gantt |
pieSelectionEffect | enum | Yes | highlight | data type=string; lov=STATICValid values: explode highlightAndExplode highlightApplies when type in (pie)type in (donut) |
renderAs | enum | Yes | candlestick | data type=string; lov=STATICValid values: area bar candlestick line lineWithAreaApplies when type = stock |
settings {
timeAxisType: auto
zoomAndScroll: false
zoomDirection: bothAxes
initialZooming: first
showHorizontalGrid: auto
showVerticalGrid: auto
showRowAxis: false
axisPosition: top
pieSelectionEffect: explode
renderAs: area
}iconAndBadge
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
iconSource | enum | No | data type=string; lov=STATICValid values: initials iconClass iconClassColumn imageUrl imageBlobColumn | |
iconColumn | string | Yes | data type=string; maxLen=32767Applies when iconSource in (initials)iconSource in (iconClassColumn) | |
imageColumn | string | Yes | data type=string; maxLen=32767Applies when iconSource = imageBlobColumn | |
imageUrl | string | Yes | data type=string; maxLen=4000Applies when iconSource = imageUrl | |
iconCssClasses | string | No | data type=string; maxLen=255Applies when iconSource is set | |
iconPosition | enum | Yes | start | data type=string; lov=STATICValid values: top start endApplies when iconSource is set |
iconDescription | string | No | data type=string; maxLen=255Applies when iconSource is set | |
badgeColumn | string | No | data type=string; maxLen=32767 | |
badgeLabel | string | No | data type=string; maxLen=255Applies when badgeColumn is set | |
badgeCssClasses | array of strings | No | data type=string; maxLen=255Applies when 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
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
stripHtml | boolean | Yes | false | data type=boolean |
sortNulls | enum | Yes | last | data type=string; lov=STATICValid values: first last |
customSvgStyles | multiline string | No | data type=multiline string; maxLen=32767 | |
oracleTextIndexColumn | string | No | data type=string; maxLen=32767 | |
emailFromAddress | string | No | data type=string; maxLen=255 | |
initJavaScriptFunction | multiline string | No | data type=multiline string; maxLen=4000Enter 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. | |
regionAlias | string | No | data type=string; maxLen=255 | |
reportIdItem | string | No | data type=string; maxLen=255; textCase=UPPER | |
maxRowsPerPageInSelector | string | No | data type=string; maxLen=4000Applies when includeSearchBar = true and includeActionsMenu = true and rowsPerPage = trueincludeSearchBar = true and rowsPerPageSelector = true |
componentAdvanced {
stripHtml: false
sortNulls: first
customSvgStyles: ```
value
```
oracleTextIndexColumn: value
emailFromAddress: value
initJavaScriptFunction: ```javascript-browser
value
```
regionAlias: value
reportIdItem: value
maxRowsPerPageInSelector: value
}singleRowView
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
excludeNullValues | boolean | Yes | false | data type=booleanApplies when linkColumn = singleRowView |
onlyDisplayedColumns | boolean | Yes | false | data type=booleanApplies when linkColumn = singleRowView |
singleRowView {
excludeNullValues: false
onlyDisplayedColumns: false
}heading
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
type | enum | Yes | customHeadings | data type=string; lov=STATICValid values: columnNames columnNamesInitcap customHeadings plsqlFunctionBody none |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = plsqlFunctionBody | |
fixedTo | enum | Yes | page | data type=string; lov=STATICValid values: none region page |
fixedReportHeight | integer | Yes | data type=integer; maxLen=32767Applies when fixedTo = region | |
maxReportHeight | integer | Yes | data type=integer; maxLen=32767Applies when fixedTo = region |
heading {
type: columnNames
plsqlFunctionBody: ```plsql
value
```
fixedTo: none
fixedReportHeight: 42
maxReportHeight: 42
}iconView
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
show | boolean | Yes | false | data type=booleanSpecify 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. |
custom | boolean | Yes | false | data type=booleanApplies when show = true |
customIcon | multiline string | Yes | data type=multiline string; maxLen=4000Applies when show = true and custom = true | |
iconType | enum | Yes | iconCssClasses | data type=string; lov=STATICValid values: imageInUrl iconCssClassesApplies when show = true and custom = false |
iconUrl | string | Yes | data type=string; maxLen=32767Applies when show = true and custom = false and iconType = imageInUrl | |
icon | string | Yes | data type=string; maxLen=32767Applies when show = true and custom = false and iconType = iconCssClasses | |
iconAttributes | string | No | data type=string; maxLen=255Applies when show = true and custom = false and iconType = imageInUrl | |
linkTarget | complex | No | data type=complex; maxLen=32767Applies when show = true | |
linkAttributes | string | No | data type=string; maxLen=255Applies when show = true and linkTarget is set and custom = false | |
labelColumn | string | Yes | data type=string; maxLen=32767Applies when show = true and custom = false | |
columnsPerRow | enum | Yes | 6 | data type=string; lov=STATICValid values: 1 2 3 4 5 6 7 8 9Applies when show = true |
linkColumn | string | Yes | data type=string; maxLen=32767Applies when show = true and custom = false | |
imageSourceColumn | string | Yes | data type=string; maxLen=32767Applies when show = true and custom = false | |
labelColumn | string | Yes | data type=string; maxLen=32767Applies when show = true and custom = false | |
imageAttributes | string | No | data type=string; maxLen=512Applies when show = true and custom = false | |
htmlAltText | string | No | data type=string; maxLen=512Applies when show = true and custom = false | |
htmlTitleText | string | No | data type=string; maxLen=512Applies when show = true and custom = false | |
customLink | multiline string | Yes | data type=multiline string; maxLen=4000Applies when 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
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
advancedFormatting | boolean | Yes | false | data type=boolean |
htmlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when advancedFormatting = true | |
source | enum | No | data type=string; lov=STATICValid values: imageUrl urlColumn blobColumnApplies when advancedFormatting = false | |
url | string | Yes | data type=string; maxLen=4000Applies when advancedFormatting = false and source = imageUrl | |
urlColumn | string | Yes | data type=string; maxLen=32767Applies when advancedFormatting = false and source = urlColumn | |
blobColumn | string | Yes | data type=string; maxLen=32767Applies when advancedFormatting = false and source = blobColumn | |
position | enum | Yes | body | data type=string; lov=STATICValid values: first body backgroundApplies when advancedFormatting = false and source is set and advancedFormatting = true and htmlExpression is set |
appearance | enum | No | data type=string; lov=STATICValid values: square widescreenApplies when advancedFormatting = false and source is set | |
sizing | enum | Yes | fit | data type=string; lov=STATICValid values: fit coverApplies when advancedFormatting = false and source is set |
cssClasses | array of strings | No | data type=string; maxLen=255 | |
imageDescription | string | No | data type=string; maxLen=255Applies when 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
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
show | boolean | Yes | true | data type=boolean |
title | string | No | data type=string; maxLen=255Applies when show = trueshow = onSpecify the title of the legend. | |
position | enum | Yes | end | data type=string; lov=STATICValid values: start end selectorApplies when show = true |
selector | string | Yes | data type=string; maxLen=32767Applies when show = true and position = selector | |
cssClasses | array of strings | No | data type=string; maxLen=255Applies when show = true | |
show | boolean | Yes | on | data type=boolean |
position | enum | Yes | auto | data type=string; lov=STATICValid values: auto start end top bottomApplies when show = on |
hideAndShowBehavior | enum | Yes | rescale | data type=string; lov=STATICValid values: none rescale noRescalingApplies when show = on |
fontFamily | enum | No | data type=string; lov=STATICValid values: arial arialBlack bookman comicSansMs courier courierNew garamond georgia helvetica impact palatino times timesNewRoman trebuchetMs verdanaApplies when show = on | |
fontStyle | enum | No | data type=string; lov=STATICValid values: normal italic obliqueApplies when show = on | |
fontSize | enum | No | data type=string; lov=STATICValid values: 8 10 12 14 16 18 20 22Applies when show = on | |
fontColor | string | No | data type=string; maxLen=255Applies when 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
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
show | boolean | Yes | on | data type=booleanApplies when type in (area)type in (bar)type in (line)type in (stock)type in (boxPlot)type in (lineWithArea)type in (combination) |
height | string | No | data type=string; maxLen=5Applies when type in (area) and show = ontype in (bar) and show = ontype in (line) and show = ontype in (stock) and show = ontype in (boxPlot) and show = ontype in (lineWithArea) and show = ontype in (combination) and show = on |
overview {
show: false
height: value
}printing
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
enabled | boolean | Yes | false | data type=boolean |
printing {
enabled: false
}externalProcessing
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
enabled | boolean | Yes | false | data type=boolean |
url | string | Yes | data type=string; maxLen=2000Applies when enabled = true | |
linkText | string | Yes | data type=string; maxLen=2000Applies when enabled = true |
externalProcessing {
enabled: false
url: value
linkText: value
}genAI
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
naturalLanguageSupport | boolean | Yes | false | data type=boolean |
defaultSearchMode | enum | Yes | searchModeAI | data type=string; lov=STATICValid values: searchModeRow searchModeAIApplies when naturalLanguageSupport = true |
reportContext | multiline string | No | data type=multiline string; maxLen=32767Applies when naturalLanguageSupport = true | |
enabled | boolean | Yes | false | data type=boolean |
agent | reference | No | data type=reference; lov=COMPONENT; references=aiAgentApplies when enabled = true | |
service | reference | No | data type=reference; lov=COMPONENT; references=genAIServiceApplies when enabled = true | |
systemPrompt | multiline string | No | data type=multiline string; maxLen=32767Applies when enabled = true | |
welcomeMessage | multiline string | No | data type=multiline string; maxLen=32767Applies when enabled = true |
genAI {
naturalLanguageSupport: false
defaultSearchMode: searchModeRow
reportContext: ```
value
```
enabled: false
agent: @component
service: @component
systemPrompt: ```
value
```
welcomeMessage: ```html
value
```
}value
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
pieChartOtherThreshold | number | Yes | 0 | data type=number; maxLen=22Applies when type in (pie)type in (donut) |
min | integer | No | data type=integer; maxLen=32767Applies when type in (pie)type in (donut) | |
show | boolean | Yes | true | data type=booleanApplies when type = statusMeterGauge |
valueType | enum | Yes | number | data type=string; lov=STATICValid values: number percentApplies when type = statusMeterGauge |
position | enum | Yes | auto | data type=string; lov=STATICValid values: auto center insideIndicatorEdge outsideIndicatorEdge outsidePlotArea withLabelApplies when type = statusMeterGauge |
format | enum | No | data type=string; lov=STATICValid values: dateShort dateMedium dateLong dateFull timeShort timeMedium timeLong timeFull datetimeShort datetimeMedium datetimeLong datetimeFull decimal currency percentApplies when type in (statusMeterGauge)type in (funnel)type in (pyramid)type in (pie)type in (donut)Specify the type of formatting to be applied to the value on the chart. The formats Decimal,Percent or Currency only apply to numeric values. The Date,Time and DateTime formats will only apply to values of that data type on the chart. | |
decimalPlaces | integer | No | data type=integer; maxLen=32767Applies when type in (statusMeterGauge) and format in (decimal)type in (statusMeterGauge) and format in (currency)type in (statusMeterGauge) and format in (percent)type in (statusMeterGauge) and type in (funnel) and format in (decimal)type in (statusMeterGauge) and type in (funnel) and format in (currency)type in (statusMeterGauge) and type in (funnel) and format in (percent)type in (statusMeterGauge) and type in (pyramid) and format in (decimal)type in (statusMeterGauge) and type in (pyramid) and format in (currency)type in (statusMeterGauge) and type in (pyramid) and format in (percent)type in (statusMeterGauge) and type in (pie) and format in (decimal)type in (statusMeterGauge) and type in (pie) and format in (currency)type in (statusMeterGauge) and type in (pie) and format in (percent)type in (statusMeterGauge) and type in (donut) and format in (decimal)type in (statusMeterGauge) and type in (donut) and format in (currency)type in (statusMeterGauge) and type in (donut) and format in (percent)type in (funnel) and type in (statusMeterGauge) and format in (decimal)type in (funnel) and type in (statusMeterGauge) and format in (currency)type in (funnel) and type in (statusMeterGauge) and format in (percent)type in (funnel) and format in (decimal)type in (funnel) and format in (currency)type in (funnel) and format in (percent)type in (funnel) and type in (pyramid) and format in (decimal)type in (funnel) and type in (pyramid) and format in (currency)type in (funnel) and type in (pyramid) and format in (percent)type in (funnel) and type in (pie) and format in (decimal)type in (funnel) and type in (pie) and format in (currency)type in (funnel) and type in (pie) and format in (percent)type in (funnel) and type in (donut) and format in (decimal)type in (funnel) and type in (donut) and format in (currency)type in (funnel) and type in (donut) and format in (percent)type in (pyramid) and type in (statusMeterGauge) and format in (decimal)type in (pyramid) and type in (statusMeterGauge) and format in (currency)type in (pyramid) and type in (statusMeterGauge) and format in (percent)type in (pyramid) and type in (funnel) and format in (decimal)type in (pyramid) and type in (funnel) and format in (currency)type in (pyramid) and type in (funnel) and format in (percent)type in (pyramid) and format in (decimal)type in (pyramid) and format in (currency)type in (pyramid) and format in (percent)type in (pyramid) and type in (pie) and format in (decimal)type in (pyramid) and type in (pie) and format in (currency)type in (pyramid) and type in (pie) and format in (percent)type in (pyramid) and type in (donut) and format in (decimal)type in (pyramid) and type in (donut) and format in (currency)type in (pyramid) and type in (donut) and format in (percent)type in (pie) and type in (statusMeterGauge) and format in (decimal)type in (pie) and type in (statusMeterGauge) and format in (currency)type in (pie) and type in (statusMeterGauge) and format in (percent)type in (pie) and type in (funnel) and format in (decimal)type in (pie) and type in (funnel) and format in (currency)type in (pie) and type in (funnel) and format in (percent)type in (pie) and type in (pyramid) and format in (decimal)type in (pie) and type in (pyramid) and format in (currency)type in (pie) and type in (pyramid) and format in (percent)type in (pie) and format in (decimal)type in (pie) and format in (currency)type in (pie) and format in (percent)type in (pie) and type in (donut) and format in (decimal)type in (pie) and type in (donut) and format in (currency)type in (pie) and type in (donut) and format in (percent)type in (donut) and type in (statusMeterGauge) and format in (decimal)type in (donut) and type in (statusMeterGauge) and format in (currency)type in (donut) and type in (statusMeterGauge) and format in (percent)type in (donut) and type in (funnel) and format in (decimal)type in (donut) and type in (funnel) and format in (currency)type in (donut) and type in (funnel) and format in (percent)type in (donut) and type in (pyramid) and format in (decimal)type in (donut) and type in (pyramid) and format in (currency)type in (donut) and type in (pyramid) and format in (percent)type in (donut) and type in (pie) and format in (decimal)type in (donut) and type in (pie) and format in (currency)type in (donut) and type in (pie) and format in (percent)type in (donut) and format in (decimal)type in (donut) and format in (currency)type in (donut) and format in (percent)Specify the number of decimal places to be applied to the numeric value on the chart. | |
currency | string | No | data type=string; maxLen=128Applies when type in (statusMeterGauge) and format = currencytype in (statusMeterGauge) and type in (funnel) and format = currencytype in (statusMeterGauge) and type in (pyramid) and format = currencytype in (statusMeterGauge) and type in (pie) and format = currencytype in (statusMeterGauge) and type in (donut) and format = currencytype in (funnel) and type in (statusMeterGauge) and format = currencytype in (funnel) and format = currencytype in (funnel) and type in (pyramid) and format = currencytype in (funnel) and type in (pie) and format = currencytype in (funnel) and type in (donut) and format = currencytype in (pyramid) and type in (statusMeterGauge) and format = currencytype in (pyramid) and type in (funnel) and format = currencytype in (pyramid) and format = currencytype in (pyramid) and type in (pie) and format = currencytype in (pyramid) and type in (donut) and format = currencytype in (pie) and type in (statusMeterGauge) and format = currencytype in (pie) and type in (funnel) and format = currencytype in (pie) and type in (pyramid) and format = currencytype in (pie) and format = currencytype in (pie) and type in (donut) and format = currencytype in (donut) and type in (statusMeterGauge) and format = currencytype in (donut) and type in (funnel) and format = currencytype in (donut) and type in (pyramid) and format = currencytype in (donut) and type in (pie) and format = currencytype in (donut) and format = currency | |
pattern | string | No | data type=string; maxLen=30Applies when type in (statusMeterGauge) and format in (decimal)type in (statusMeterGauge) and format in (currency)type in (statusMeterGauge) and format in (percent)type in (statusMeterGauge) and type in (funnel) and format in (decimal)type in (statusMeterGauge) and type in (funnel) and format in (currency)type in (statusMeterGauge) and type in (funnel) and format in (percent)type in (statusMeterGauge) and type in (pyramid) and format in (decimal)type in (statusMeterGauge) and type in (pyramid) and format in (currency)type in (statusMeterGauge) and type in (pyramid) and format in (percent)type in (statusMeterGauge) and type in (pie) and format in (decimal)type in (statusMeterGauge) and type in (pie) and format in (currency)type in (statusMeterGauge) and type in (pie) and format in (percent)type in (statusMeterGauge) and type in (donut) and format in (decimal)type in (statusMeterGauge) and type in (donut) and format in (currency)type in (statusMeterGauge) and type in (donut) and format in (percent)type in (funnel) and type in (statusMeterGauge) and format in (decimal)type in (funnel) and type in (statusMeterGauge) and format in (currency)type in (funnel) and type in (statusMeterGauge) and format in (percent)type in (funnel) and format in (decimal)type in (funnel) and format in (currency)type in (funnel) and format in (percent)type in (funnel) and type in (pyramid) and format in (decimal)type in (funnel) and type in (pyramid) and format in (currency)type in (funnel) and type in (pyramid) and format in (percent)type in (funnel) and type in (pie) and format in (decimal)type in (funnel) and type in (pie) and format in (currency)type in (funnel) and type in (pie) and format in (percent)type in (funnel) and type in (donut) and format in (decimal)type in (funnel) and type in (donut) and format in (currency)type in (funnel) and type in (donut) and format in (percent)type in (pyramid) and type in (statusMeterGauge) and format in (decimal)type in (pyramid) and type in (statusMeterGauge) and format in (currency)type in (pyramid) and type in (statusMeterGauge) and format in (percent)type in (pyramid) and type in (funnel) and format in (decimal)type in (pyramid) and type in (funnel) and format in (currency)type in (pyramid) and type in (funnel) and format in (percent)type in (pyramid) and format in (decimal)type in (pyramid) and format in (currency)type in (pyramid) and format in (percent)type in (pyramid) and type in (pie) and format in (decimal)type in (pyramid) and type in (pie) and format in (currency)type in (pyramid) and type in (pie) and format in (percent)type in (pyramid) and type in (donut) and format in (decimal)type in (pyramid) and type in (donut) and format in (currency)type in (pyramid) and type in (donut) and format in (percent)type in (pie) and type in (statusMeterGauge) and format in (decimal)type in (pie) and type in (statusMeterGauge) and format in (currency)type in (pie) and type in (statusMeterGauge) and format in (percent)type in (pie) and type in (funnel) and format in (decimal)type in (pie) and type in (funnel) and format in (currency)type in (pie) and type in (funnel) and format in (percent)type in (pie) and type in (pyramid) and format in (decimal)type in (pie) and type in (pyramid) and format in (currency)type in (pie) and type in (pyramid) and format in (percent)type in (pie) and format in (decimal)type in (pie) and format in (currency)type in (pie) and format in (percent)type in (pie) and type in (donut) and format in (decimal)type in (pie) and type in (donut) and format in (currency)type in (pie) and type in (donut) and format in (percent)type in (donut) and type in (statusMeterGauge) and format in (decimal)type in (donut) and type in (statusMeterGauge) and format in (currency)type in (donut) and type in (statusMeterGauge) and format in (percent)type in (donut) and type in (funnel) and format in (decimal)type in (donut) and type in (funnel) and format in (currency)type in (donut) and type in (funnel) and format in (percent)type in (donut) and type in (pyramid) and format in (decimal)type in (donut) and type in (pyramid) and format in (currency)type in (donut) and type in (pyramid) and format in (percent)type in (donut) and type in (pie) and format in (decimal)type in (donut) and type in (pie) and format in (currency)type in (donut) and type in (pie) and format in (percent)type in (donut) and format in (decimal)type in (donut) and format in (currency)type in (donut) and format in (percent)Specify the numeric pattern to be applied to the numeric value on the chart. | |
formatScaling | enum | Yes | auto | data type=string; lov=STATICValid values: none auto thousand million billion trillion quadrillionApplies when type in (statusMeterGauge)type in (funnel)type in (pyramid)type in (pie)type in (donut) |
value {
pieChartOtherThreshold: 42
min: 42
show: false
valueType: number
position: auto
format: dateShort
decimalPlaces: 42
currency: value
pattern: value
formatScaling: none
}attributes
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
messagesPosition | enum | No | data type=string; lov=STATICValid values: above below selector | |
messageSelector | string | Yes | data type=string; maxLen=32767Applies when messagesPosition = selector | |
unitSystem | enum | Yes | metric | data type=string; lov=STATICValid values: metric imperial deriveFromItem |
unitSystemItem | string | Yes | data type=string; maxLen=32767; textCase=UPPERApplies when unitSystem = deriveFromItem | |
copyrightNotice | multiline string | No | data type=multiline string; maxLen=32767 |
attributes {
messagesPosition: above
messageSelector: value
unitSystem: metric
unitSystemItem: value
copyrightNotice: ```html
value
```
}searchBar
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
includeSearchBar | boolean | Yes | true | data type=boolean |
searchField | boolean | Yes | true | data type=booleanApplies when includeSearchBar = true |
finderDropDown | boolean | Yes | true | data type=booleanApplies when includeSearchBar = true and searchField = true |
reportsSelectList | boolean | Yes | TABS | data type=booleanApplies when includeSearchBar = true |
rowsPerPageSelector | boolean | Yes | false | data type=booleanApplies when includeSearchBar = true |
searchButtonLabel | string | No | data type=string; maxLen=4000Applies when includeSearchBar = true |
searchBar {
includeSearchBar: false
searchField: false
finderDropDown: false
reportsSelectList: false
rowsPerPageSelector: false
searchButtonLabel: value
}orderBy
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
type | enum | No | data type=string; lov=STATICValid values: staticValue itemApplies when location in (localDatabase) and type in (tableView)location in (localDatabase) and type in (propertyGraph)location in (localDatabase) and type in (sqlQuery)location in (localDatabase) and type in (functionBody)location in (localDatabase) and type in ($NULL$)location in (localDatabase) and location in (restEnabledSql) and type in (tableView)location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph)location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery)location in (localDatabase) and location in (restEnabledSql) and type in (functionBody)location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$)location in (restEnabledSql) and location in (localDatabase) and type in (tableView)location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph)location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery)location in (restEnabledSql) and location in (localDatabase) and type in (functionBody)location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$)location in (restEnabledSql) and type in (tableView)location in (restEnabledSql) and type in (propertyGraph)location in (restEnabledSql) and type in (sqlQuery)location in (restEnabledSql) and type in (functionBody)location in (restEnabledSql) and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (tableView)location in (sampleData) and location in (localDatabase) and type in (propertyGraph)location in (sampleData) and location in (localDatabase) and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) | |
orderByClause | multiline string | Yes | data type=multiline string; maxLen=4000Applies when location in (localDatabase) and type in (tableView) and type = staticValuelocation in (localDatabase) and type in (tableView) and type = staticValue and type in (sqlQuery)location in (localDatabase) and type in (tableView) and type = staticValue and type in (functionBody)location in (localDatabase) and type in (tableView) and type = staticValue and type in ($NULL$)location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql)location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type in (functionBody)location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (tableView)location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (sqlQuery)location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (functionBody)location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in ($NULL$)location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in (tableView)location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in (functionBody)location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in (tableView)location in (localDatabase) and type in (sqlQuery) and type = staticValuelocation in (localDatabase) and type in (sqlQuery) and type = staticValue and type in (functionBody)location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in ($NULL$)location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type in (tableView)location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql)location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type in (functionBody)location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)location in (localDatabase) and type in (functionBody) and type = staticValue and type in (tableView)location in (localDatabase) and type in (functionBody) and type = staticValue and type in (sqlQuery)location in (localDatabase) and type in (functionBody) and type = staticValuelocation in (localDatabase) and type in (functionBody) and type = staticValue and type in ($NULL$)location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type in (tableView)location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql)location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (tableView)location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (sqlQuery)location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (functionBody)location in (localDatabase) and type in ($NULL$) and type = staticValuelocation in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type in (tableView)location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type in (functionBody)location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql)location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = staticValuelocation in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in (sqlQuery)location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in (functionBody)location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in ($NULL$)location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (tableView)location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (sqlQuery)location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (functionBody)location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in ($NULL$)location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in (tableView)location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValuelocation in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in (functionBody)location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in ($NULL$)location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in (tableView)location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in (sqlQuery)location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = staticValuelocation in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in ($NULL$)location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (tableView)location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (sqlQuery)location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (functionBody)location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = staticValuelocation in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = staticValuelocation in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = staticValue and type in (sqlQuery)location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = staticValue and type in (functionBody)location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = staticValue and type in ($NULL$)location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (tableView)location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (sqlQuery)location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (functionBody)location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in ($NULL$)location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in (tableView)location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = staticValuelocation in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in (functionBody)location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in ($NULL$)location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = staticValue and type in (tableView)location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = staticValue and type in (sqlQuery)location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = staticValuelocation in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = staticValue and type in ($NULL$)location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (tableView)location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (sqlQuery)location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (functionBody)location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = staticValuelocation in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase)location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type in (sqlQuery)location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type in (functionBody)location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type in ($NULL$)location in (restEnabledSql) and type in (tableView) and type = staticValuelocation in (restEnabledSql) and type in (tableView) and type = staticValue and type in (sqlQuery)location in (restEnabledSql) and type in (tableView) and type = staticValue and type in (functionBody)location in (restEnabledSql) and type in (tableView) and type = staticValue and type in ($NULL$)location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in (tableView)location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in (sqlQuery)location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in (functionBody)location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in ($NULL$)location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (tableView)location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (sqlQuery)location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (functionBody)location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in ($NULL$)location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type in (tableView)location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase)location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type in (functionBody)location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type in ($NULL$)location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in (tableView)location in (restEnabledSql) and type in (sqlQuery) and type = staticValuelocation in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in (functionBody)location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in ($NULL$)location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type in (tableView)location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type in (sqlQuery)location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase)location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type in ($NULL$)location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in (tableView)location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in (sqlQuery)location in (restEnabledSql) and type in (functionBody) and type = staticValuelocation in (restEnabledSql) and type in (functionBody) and type = staticValue and type in ($NULL$)location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type in (tableView)location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type in (sqlQuery)location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type in (functionBody)location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase)location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (tableView)location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (sqlQuery)location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (functionBody)location in (restEnabledSql) and type in ($NULL$) and type = staticValuelocation in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValuelocation in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql)location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (tableView)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in (tableView)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in (tableView)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValuelocation in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type in (tableView)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and type in (tableView)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValuelocation in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type in (tableView)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (tableView)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValuelocation in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type in (tableView)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValuelocation in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValuelocation in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValuelocation in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue | |
item | complex | Yes | data type=complex; maxLen=32767Applies when location in (localDatabase) and type in (tableView) and type = itemlocation in (localDatabase) and type in (tableView) and type = item and type in (sqlQuery)location in (localDatabase) and type in (tableView) and type = item and type in (functionBody)location in (localDatabase) and type in (tableView) and type = item and type in ($NULL$)location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql)location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type in (sqlQuery)location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type in (functionBody)location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type in ($NULL$)location in (localDatabase) and type in (propertyGraph) and type = item and type in (tableView)location in (localDatabase) and type in (propertyGraph) and type = item and type in (sqlQuery)location in (localDatabase) and type in (propertyGraph) and type = item and type in (functionBody)location in (localDatabase) and type in (propertyGraph) and type = item and type in ($NULL$)location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in (tableView)location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in (sqlQuery)location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in (functionBody)location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in ($NULL$)location in (localDatabase) and type in (sqlQuery) and type = item and type in (tableView)location in (localDatabase) and type in (sqlQuery) and type = itemlocation in (localDatabase) and type in (sqlQuery) and type = item and type in (functionBody)location in (localDatabase) and type in (sqlQuery) and type = item and type in ($NULL$)location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type in (tableView)location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql)location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type in (functionBody)location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type in ($NULL$)location in (localDatabase) and type in (functionBody) and type = item and type in (tableView)location in (localDatabase) and type in (functionBody) and type = item and type in (sqlQuery)location in (localDatabase) and type in (functionBody) and type = itemlocation in (localDatabase) and type in (functionBody) and type = item and type in ($NULL$)location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type in (tableView)location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type in (sqlQuery)location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql)location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type in ($NULL$)location in (localDatabase) and type in ($NULL$) and type = item and type in (tableView)location in (localDatabase) and type in ($NULL$) and type = item and type in (sqlQuery)location in (localDatabase) and type in ($NULL$) and type = item and type in (functionBody)location in (localDatabase) and type in ($NULL$) and type = itemlocation in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type in (tableView)location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type in (sqlQuery)location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type in (functionBody)location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql)location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = itemlocation in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = item and type in (sqlQuery)location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = item and type in (functionBody)location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = item and type in ($NULL$)location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (tableView)location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (sqlQuery)location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (functionBody)location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in ($NULL$)location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in (tableView)location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = itemlocation in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in (functionBody)location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in ($NULL$)location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = item and type in (tableView)location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = item and type in (sqlQuery)location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = itemlocation in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = item and type in ($NULL$)location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (tableView)location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (sqlQuery)location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (functionBody)location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = itemlocation in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = itemlocation in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = item and type in (sqlQuery)location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = item and type in (functionBody)location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = item and type in ($NULL$)location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = item and type in (tableView)location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = item and type in (sqlQuery)location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = item and type in (functionBody)location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = item and type in ($NULL$)location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = item and type in (tableView)location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = itemlocation in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = item and type in (functionBody)location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = item and type in ($NULL$)location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = item and type in (tableView)location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = item and type in (sqlQuery)location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = itemlocation in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = item and type in ($NULL$)location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = item and type in (tableView)location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = item and type in (sqlQuery)location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = item and type in (functionBody)location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = itemlocation in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase)location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type in (sqlQuery)location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type in (functionBody)location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type in ($NULL$)location in (restEnabledSql) and type in (tableView) and type = itemlocation in (restEnabledSql) and type in (tableView) and type = item and type in (sqlQuery)location in (restEnabledSql) and type in (tableView) and type = item and type in (functionBody)location in (restEnabledSql) and type in (tableView) and type = item and type in ($NULL$)location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in (tableView)location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in (sqlQuery)location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in (functionBody)location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in ($NULL$)location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (tableView)location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (sqlQuery)location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (functionBody)location in (restEnabledSql) and type in (propertyGraph) and type = item and type in ($NULL$)location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type in (tableView)location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase)location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type in (functionBody)location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type in ($NULL$)location in (restEnabledSql) and type in (sqlQuery) and type = item and type in (tableView)location in (restEnabledSql) and type in (sqlQuery) and type = itemlocation in (restEnabledSql) and type in (sqlQuery) and type = item and type in (functionBody)location in (restEnabledSql) and type in (sqlQuery) and type = item and type in ($NULL$)location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type in (tableView)location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type in (sqlQuery)location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase)location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type in ($NULL$)location in (restEnabledSql) and type in (functionBody) and type = item and type in (tableView)location in (restEnabledSql) and type in (functionBody) and type = item and type in (sqlQuery)location in (restEnabledSql) and type in (functionBody) and type = itemlocation in (restEnabledSql) and type in (functionBody) and type = item and type in ($NULL$)location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type in (tableView)location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type in (sqlQuery)location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type in (functionBody)location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase)location in (restEnabledSql) and type in ($NULL$) and type = item and type in (tableView)location in (restEnabledSql) and type in ($NULL$) and type = item and type in (sqlQuery)location in (restEnabledSql) and type in ($NULL$) and type = item and type in (functionBody)location in (restEnabledSql) and type in ($NULL$) and type = itemlocation in (sampleData) and location in (localDatabase) and type in (tableView) and type = itemlocation in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql)location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and type in (tableView)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in (tableView)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and type in (tableView)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = itemlocation in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type in (tableView)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and type in (tableView)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = itemlocation in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type in (tableView)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql)location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type in ($NULL$)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and type in (tableView)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = itemlocation in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type in (tableView)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type in (sqlQuery)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type in (functionBody)location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = itemlocation in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = itemlocation in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = itemlocation in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and type in ($NULL$)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (tableView)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (sqlQuery)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (functionBody)location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item | |
orderByClause | multiline string | Yes | data type=multiline string; maxLen=4000Applies when location in (localDatabase) and type in (tableView) and type = staticValue and type = propertyGraphlocation in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type = propertyGraphlocation in (localDatabase) and type in (propertyGraph) and type = staticValue and type = propertyGraphlocation in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type = propertyGraphlocation in (localDatabase) and type in (sqlQuery) and type = staticValue and type = propertyGraphlocation in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type = propertyGraphlocation in (localDatabase) and type in (functionBody) and type = staticValue and type = propertyGraphlocation in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type = propertyGraphlocation in (localDatabase) and type in ($NULL$) and type = staticValue and type = propertyGraphlocation in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type = propertyGraphlocation in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type = propertyGraphlocation in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type = propertyGraphlocation in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type = propertyGraphlocation in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type = propertyGraphlocation in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type = propertyGraphlocation in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = staticValue and type = propertyGraphlocation in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type = propertyGraphlocation in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type = propertyGraphlocation in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = staticValue and type = propertyGraphlocation in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type = propertyGraphlocation in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type in (tableView) and type = staticValue and type = propertyGraphlocation in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type = propertyGraphlocation in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type = propertyGraphlocation in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type in (functionBody) and type = staticValue and type = propertyGraphlocation in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type in ($NULL$) and type = staticValue and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type = propertyGraph | |
item | complex | Yes | data type=complex; maxLen=32767Applies when location in (localDatabase) and type in (tableView) and type = item and type = propertyGraphlocation in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type = propertyGraphlocation in (localDatabase) and type in (propertyGraph) and type = item and type = propertyGraphlocation in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type = propertyGraphlocation in (localDatabase) and type in (sqlQuery) and type = item and type = propertyGraphlocation in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type = propertyGraphlocation in (localDatabase) and type in (functionBody) and type = item and type = propertyGraphlocation in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type = propertyGraphlocation in (localDatabase) and type in ($NULL$) and type = item and type = propertyGraphlocation in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type = propertyGraphlocation in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = item and type = propertyGraphlocation in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type = propertyGraphlocation in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type = propertyGraphlocation in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = item and type = propertyGraphlocation in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = item and type = propertyGraphlocation in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = item and type = propertyGraphlocation in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = item and type = propertyGraphlocation in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = item and type = propertyGraphlocation in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = item and type = propertyGraphlocation in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = item and type = propertyGraphlocation in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type in (tableView) and type = item and type = propertyGraphlocation in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type in (propertyGraph) and type = item and type = propertyGraphlocation in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type in (sqlQuery) and type = item and type = propertyGraphlocation in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type in (functionBody) and type = item and type = propertyGraphlocation in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type = propertyGraphlocation in (restEnabledSql) and type in ($NULL$) and type = item and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and type = propertyGraphlocation in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type = propertyGraphlocation in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and type = propertyGraph |
orderBy {
type: staticValue
orderByClause: ```sql
value
```
item: {
itemName: value
orderBys: [
value
value
]
}
}blobAttributes
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
mimeTypeColumn | string | No | data type=string; maxLen=32767Applies when iconSource = imageBlobColumnadvancedFormatting = false and source = blobColumn | |
lastUpdatedColumn | string | No | data type=string; maxLen=32767Applies when iconSource = imageBlobColumnadvancedFormatting = false and source = blobColumn |
blobAttributes {
mimeTypeColumn: value
lastUpdatedColumn: value
}detailView
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
show | boolean | Yes | false | data type=booleanSpecify 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. |
beforeRows | multiline string | No | data type=multiline string; maxLen=4000Applies when show = true | |
forEachRow | multiline string | Depends | data type=multiline string; maxLen=4000Applies when show = trueEnter the body for report rows in the Detail View. The following substitution strings are available:
| |
afterRows | multiline string | No | data type=multiline string; maxLen=4000Applies when show = true |
detailView {
show: false
beforeRows: ```html
value
```
forEachRow: ```html
value
```
afterRows: ```html
value
```
}actionsMenu
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
includeActionsMenu | boolean | Yes | true | data type=booleanApplies when includeSearchBar = true |
filter | boolean | Yes | true | data type=booleanApplies when includeSearchBar = true and includeActionsMenu = true |
selectColumns | boolean | Yes | true | data type=booleanApplies when includeSearchBar = true and includeActionsMenu = true |
rowsPerPage | boolean | Yes | true | data type=booleanApplies when includeSearchBar = true and includeActionsMenu = true |
sort | boolean | Yes | true | data type=booleanApplies when includeSearchBar = true and includeActionsMenu = true |
controlBreak | boolean | Yes | true | data type=booleanApplies when includeSearchBar = true and includeActionsMenu = true |
highlight | boolean | Yes | true | data type=booleanApplies when includeSearchBar = true and includeActionsMenu = true |
compute | boolean | Yes | true | data type=booleanApplies when includeSearchBar = true and includeActionsMenu = true |
aggregate | boolean | Yes | true | data type=booleanApplies when includeSearchBar = true and includeActionsMenu = true |
chart | boolean | Yes | true | data type=booleanApplies when includeSearchBar = true and includeActionsMenu = true |
groupBy | boolean | Yes | true | data type=booleanApplies when includeSearchBar = true and includeActionsMenu = true |
pivot | boolean | Yes | true | data type=booleanApplies when includeSearchBar = true and includeActionsMenu = true |
flashback | boolean | Yes | true | data type=booleanApplies when includeSearchBar = true and includeActionsMenu = true |
saveReport | boolean | Yes | true | data type=booleanApplies when includeSearchBar = true and includeActionsMenu = true |
savePublicReport | boolean | Yes | false | data type=booleanApplies when includeSearchBar = true and includeActionsMenu = true and saveReport = true |
savePublicReportAuthorization | enum | No | data type=reference; lov=COMPONENT; references=authorizationValid values: mustNotBePublicUserApplies when includeSearchBar = true and includeActionsMenu = true and saveReport = true and savePublicReport = true | |
reset | boolean | Yes | true | data type=booleanApplies when includeSearchBar = true and includeActionsMenu = true |
help | boolean | Yes | true | data type=booleanApplies when includeSearchBar = true and includeActionsMenu = true |
download | boolean | Yes | true | data type=booleanApplies when includeSearchBar = true and includeActionsMenu = true |
subscription | boolean | Yes | true | data type=booleanApplies when 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
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
nestedRows | reference | No | data type=reference; lov=COMPONENT; references=dataProfileColumnApplies when location = restSource and restSource supports HAS_ARRAY_COLUMNS | |
nestedRows | reference | No | data type=reference; lov=COMPONENT; references=dataProfileColumnApplies when location = jsonDualityView and jsonDualityView supports HAS_ARRAY_COLUMNS | |
nestedRows | reference | No | data type=reference; lov=COMPONENT; references=dataProfileColumnApplies when location = jsonSource and jsonSource supports HAS_ARRAY_COLUMNS |
dataProfile {
nestedRows: @component
}animation
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
onDisplay | enum | Yes | auto | data type=string; lov=STATICValid values: auto alphaFade zoom noneApplies when lazyLoading = false |
onDataChange | enum | Yes | auto | data type=string; lov=STATICValid values: auto slideToLeft slideToRight none |
animation {
onDisplay: auto
onDataChange: auto
}restSynchronization
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
useLocalTable | boolean | Yes | false | data type=booleanApplies when location = restSource and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNSlocation = restSource and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNSlocation = restSource and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED |
restSynchronization {
useLocalTable: false
}tooltip
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
show | boolean | Yes | true | data type=boolean |
showSeriesName | boolean | Yes | true | data type=booleanApplies when show = true |
showGroupName | boolean | Yes | true | data type=booleanApplies when show = true |
showValue | boolean | Yes | true | data type=booleanApplies when show = true |
showRow | boolean | Yes | true | data type=booleanApplies when show = true and type = gantt |
showLabel | boolean | Yes | true | data type=booleanApplies when show = true and type = gantt |
showStartDate | boolean | Yes | true | data type=booleanApplies when show = true and type = gantt |
showEndDate | boolean | Yes | true | data type=booleanApplies when show = true and type = gantt |
showProgress | boolean | Yes | true | data type=booleanApplies when show = true and type = gantt |
showBaseline | boolean | Yes | true | data type=booleanApplies when 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
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
enabled | boolean | Yes | false | data type=booleanApplies when location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false)location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$)location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in (false)location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in ($NULL$)location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false)location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in ($NULL$) |
filter | multiline string | No | data type=multiline string; maxLen=4000Applies when location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in (false) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in ($NULL$) and enabled = true | |
orderByType | enum | No | data type=string; lov=STATICValid values: staticValue itemApplies when location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in (false) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in ($NULL$) and enabled = true | |
orderBy | multiline string | No | data type=multiline string; maxLen=255Applies when location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false) and enabled = true and orderByType = staticValuelocation = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = true and orderByType = staticValuelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in (false) and enabled = true and orderByType = staticValuelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = true and orderByType = staticValuelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false) and enabled = true and orderByType = staticValuelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in ($NULL$) and enabled = true and orderByType = staticValuelocation = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in (false) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false) and enabled = truelocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in ($NULL$) and enabled = true | |
item | complex | Yes | data type=complex; maxLen=4000Applies when location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false) and enabled = true and orderByType = itemlocation = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = true and orderByType = itemlocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in (false) and enabled = true and orderByType = itemlocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = true and orderByType = itemlocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false) and enabled = true and orderByType = itemlocation = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in ($NULL$) and enabled = true and orderByType = item |
externalFilterAndOrderBy {
enabled: false
filter: ```
value
```
orderByType: staticValue
orderBy: ```
value
```
item: {
itemName: value
orderBys: [
value
value
]
}
}advanced
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
savedReportMappingIdentifier | string | No | data type=string; maxLen=32767 | |
htmlDomId | string | No | data type=string; maxLen=255Enter the DOM ID for this region. If defined, this is used as the ID for the region, using the substitution string Note: The template must include the | |
customAttributes | string | No | data type=string; maxLen=2000Enter the value substituted into region attributes. Region templates that contain the substitution string #REGION_ATTRIBUTES# are substituted with this value. | |
regionImage | string | No | data type=string; maxLen=255Applies when template supports NOT_REGION_IMAGE_URL | |
imageTagAttributes | string | No | data type=string; maxLen=255Applies when template supports NOT_REGION_IMAGE_URL and regionImage is set | |
staticId | string | Yes | data type=string; maxLen=255 | |
regionDisplaySelector | boolean | Yes | false | data type=booleanApplies when template is set |
excludeTitleFromTranslation | boolean | Yes | false | data type=boolean |
schemaOverrideItem | string | No | data type=string; maxLen=4000; textCase=UPPER |
advanced {
savedReportMappingIdentifier: value
htmlDomId: value
customAttributes: value
regionImage: value
imageTagAttributes: value
staticId: value
regionDisplaySelector: false
excludeTitleFromTranslation: false
schemaOverrideItem: value
}help
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
helpText | multiline string | No | data type=multiline string; maxLen=4000Use 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
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
type | enum | No | data type=string; lov=STATICValid values: whereOrderByClause sqlQuery plsqlFunctionBodyApplies when location = restSource and restSource is set | |
whereClause | multiline string | No | data type=multiline string; maxLen=4000Applies when location = restSource and restSource is set and type = whereOrderByClause | |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=32767Applies when location = restSource and restSource is set and type = sqlQuery | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when location = restSource and restSource is set and type = plsqlFunctionBody |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=32767Applies when location = restSource and restSource is set and type = plsqlFunctionBody and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=32767Applies when location = restSource and restSource is set and type = plsqlFunctionBody and language = javaScript-mle | |
orderByType | enum | No | data type=string; lov=STATICValid values: staticValue itemApplies when location = restSource and restSource is set and type = whereOrderByClause | |
orderByClause | multiline string | Yes | data type=multiline string; maxLen=255Applies when location = restSource and restSource is set and type = whereOrderByClause and orderByType = staticValue | |
item | complex | Yes | data type=complex; maxLen=32767Applies when location = restSource and restSource is set and type = whereOrderByClause and orderByType = item | |
orderByItem | complex | No | data type=complex; maxLen=32767Applies when location = restSource and restSource is set and type in (sqlQuery)location = restSource and restSource is set and type in (plsqlFunctionBody) | |
type | enum | No | data type=string; lov=STATICValid values: whereOrderByClause sqlQuery plsqlFunctionBodyApplies when location = jsonDualityView and jsonDualityView is set | |
whereClause | multiline string | No | data type=multiline string; maxLen=4000Applies when location = jsonDualityView and jsonDualityView is set and type = whereOrderByClause | |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=32767Applies when location = jsonDualityView and jsonDualityView is set and type = sqlQuery | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when location = jsonDualityView and jsonDualityView is set and type = plsqlFunctionBody |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=32767Applies when location = jsonDualityView and jsonDualityView is set and type = plsqlFunctionBody and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=32767Applies when location = jsonDualityView and jsonDualityView is set and type = plsqlFunctionBody and language = javaScript-mle | |
orderByType | enum | No | data type=string; lov=STATICValid values: staticValue itemApplies when location = jsonDualityView and jsonDualityView is set and type = whereOrderByClause | |
orderByClause | multiline string | Yes | data type=multiline string; maxLen=255Applies when location = jsonDualityView and jsonDualityView is set and type = whereOrderByClause and orderByType = staticValue | |
item | complex | Yes | data type=complex; maxLen=32767Applies when location = jsonDualityView and jsonDualityView is set and type = whereOrderByClause and orderByType = item | |
orderByItem | complex | No | data type=complex; maxLen=32767Applies when location = jsonDualityView and jsonDualityView is set and type in (sqlQuery)location = jsonDualityView and jsonDualityView is set and type in (plsqlFunctionBody) | |
type | enum | No | data type=string; lov=STATICValid values: whereOrderByClause sqlQuery plsqlFunctionBodyApplies when location = jsonSource and jsonSource is set | |
whereClause | multiline string | No | data type=multiline string; maxLen=4000Applies when location = jsonSource and jsonSource is set and type = whereOrderByClause | |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=32767Applies when location = jsonSource and jsonSource is set and type = sqlQuery | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when location = jsonSource and jsonSource is set and type = plsqlFunctionBody |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=32767Applies when location = jsonSource and jsonSource is set and type = plsqlFunctionBody and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=32767Applies when location = jsonSource and jsonSource is set and type = plsqlFunctionBody and language = javaScript-mle | |
orderByType | enum | No | data type=string; lov=STATICValid values: staticValue itemApplies when location = jsonSource and jsonSource is set and type = whereOrderByClause | |
orderByClause | multiline string | Yes | data type=multiline string; maxLen=255Applies when location = jsonSource and jsonSource is set and type = whereOrderByClause and orderByType = staticValue | |
item | complex | Yes | data type=complex; maxLen=32767Applies when location = jsonSource and jsonSource is set and type = whereOrderByClause and orderByType = item | |
orderByItem | complex | No | data type=complex; maxLen=32767Applies when location = jsonSource and jsonSource is set and type in (sqlQuery)location = jsonSource and jsonSource is set and type in (plsqlFunctionBody) |
localPostProcessing {
type: whereOrderByClause
whereClause: ```sql
value
```
sqlQuery: ```sql
value
```
language: plsql
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
orderByType: staticValue
orderByClause: ```sql
value
```
item: {
itemName: value
orderBys: [
value
value
]
}
orderByItem: {
itemName: value
orderBys: [
value
value
]
}
}autoRefresh
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
interval | integer | No | data type=integer; maxLen=32767 |
autoRefresh {
interval: 42
}remoteCache
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
caching | enum | No | data type=string; lov=STATICValid values: allUsers user sessionApplies when location = restEnabledSql | |
timeout | multiline string | Yes | data type=multiline string; maxLen=255Applies when location = restEnabledSql and caching is set |
remoteCache {
caching: allUsers
timeout: ```
value
```
}layout
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
sequence | number | Yes | data type=number; maxLen=22 | |
parentRegion | reference | No | data type=reference; lov=COMPONENT; references=region | |
slot | string | Yes | data type=string; lov=SLOTS | |
startNewLayout | boolean | Yes | false | data type=boolean |
startNewRow | boolean | Yes | true | data type=booleanApplies when startNewLayout = false |
rowCssClasses | array of strings | No | data type=string; maxLen=255 | |
column | string | No | data type=string; lov=GRID_COLUMNS | |
newColumn | boolean | Yes | true | data type=booleanApplies when startNewLayout = false and startNewRow = false |
columnSpan | string | No | data type=string; lov=GRID_COLUMNS | |
columnCssClasses | array of strings | No | data type=string; maxLen=255 | |
columnAttributes | array of strings | No | data 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
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
description | multiline string | No | data type=multiline string; maxLen=4000Enter a description for this Interactive Report. |
description {
description: ```
value
```
}appearance
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
template | reference | No | data type=reference; lov=COMPONENT; references=regionTemplate | |
templateOptions | array of strings | No | data type=string; lov=TEMPLATE_OPTIONSApplies when template is set | |
cssClasses | array of strings | No | data type=string; maxLen=255Applies when template is setEnter classes to add to this component. You may add multiple classes by separating them with spaces. | |
icon | string | No | data type=string; maxLen=255Applies when template is set | |
renderComponents | enum | Yes | aboveContent | data type=string; lov=STATICValid values: aboveContent belowContent |
appearance {
template: @component
templateOptions: [
value
value
]
cssClasses: [
value
value
]
icon: value
renderComponents: aboveContent
}accessibility
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
useLandmark | boolean | Yes | true | data type=booleanApplies when template supports REGION_LANDMARK_ATTRIBUTES |
landmarkType | enum | No | data type=string; lov=STATICValid values: banner complementary contentInfo form main navigation region searchApplies when template supports REGION_LANDMARK_ATTRIBUTES and useLandmark = true | |
landmarkLabel | string | No | data type=string; maxLen=255Applies when template supports REGION_LANDMARK_ATTRIBUTES and useLandmark = true |
accessibility {
useLandmark: false
landmarkType: banner
landmarkLabel: value
}image
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
fileUrl | string | No | data type=string; maxLen=255Applies when template supports REGION_IMAGEtemplate supports REGION_IMAGE_URL | |
accessibleDescription | string | No | data type=string; maxLen=255Applies when template supports REGION_IMAGE_ALT_TEXT and template supports REGION_IMAGE and fileUrl is settemplate supports REGION_IMAGE_ALT_TEXT and template supports REGION_IMAGE_URL and fileUrl is set | |
customAttributes | string | No | data type=string; maxLen=255Applies when template supports REGION_IMAGE_ATTRIBUTES and template supports REGION_IMAGE and fileUrl is settemplate supports REGION_IMAGE_ATTRIBUTES and template supports REGION_IMAGE_URL and fileUrl is set |
image {
fileUrl: value
accessibleDescription: value
customAttributes: value
}masterDetail
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
masterRegion | reference | No | data type=reference; lov=COMPONENT; references=region |
masterDetail {
masterRegion: @component
}headerAndFooter
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
headerText | multiline string | No | data type=multiline string; maxLen=4000Enter HTML text displayed at the top of the region, before the #BODY# content. | |
footerText | multiline string | No | data type=multiline string; maxLen=4000Enter a region footer that displays directly after the body content, after For report regions you can use the following pagination substitution strings:
|
headerAndFooter {
headerText: ```html
value
```
footerText: ```html
value
```
}serverSideCondition
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
type | enum | No | data type=string; lov=STATICValid 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 | |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type in (rowsReturned)type in (noRowsReturned) | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: sql plsql javaScript-mleApplies when type = expression |
sqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = expression and language = sql | |
plsqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = expression and language = plsql | |
javaScriptExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = expression and language = javaScript-mle | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when type = functionBody |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = functionBody and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = functionBody and language = javaScript-mle | |
value | string | Yes | data type=string; maxLen=4000Applies when type 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) | |
item | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when type 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) | |
preference | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when type in (userPreference=value)type in (userPreference!=value) | |
page | integer | Yes | data type=integer; maxLen=4000Applies when type in (currentPage=page)type in (currentPage!=page) | |
pages | array of integers | Yes | data type=integer; maxLen=4000Applies when type in (currentPageInList)type in (currentPageNotInList) | |
text | string | Yes | data type=string; maxLen=4000Applies when type in (textIsContainedInItem)type in (textIsContainedInValue)type in (textIsNotContainedInValue)type in (text=value)type in (text!=value) | |
value | string | Yes | data type=string; maxLen=4000Applies when type 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) | |
list | array of strings | Yes | data type=string; maxLen=4000Applies when type in (itemIsInColonDelimitedList)type in (itemIsNotInColonDelimitedList) | |
item | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when type = textIsContainedInItem | |
value | string | Yes | data type=string; maxLen=4000Applies when type 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
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
type | enum | No | data type=string; lov=STATICValid 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 neverSelect 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. | |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type in (rowsReturned)type in (noRowsReturned) | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: sql plsql javaScript-mleApplies when type = expression |
sqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = expression and language = sql | |
plsqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = expression and language = plsql | |
javaScriptExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = expression and language = javaScript-mle | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when type = functionBody |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = functionBody and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = functionBody and language = javaScript-mle | |
value | string | Yes | data type=string; maxLen=4000Applies when type 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) | |
item | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when type 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) | |
preference | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when type in (userPreference=value)type in (userPreference!=value) | |
page | integer | Yes | data type=integer; maxLen=4000Applies when type in (currentPage=page)type in (currentPage!=page) | |
pages | array of integers | Yes | data type=integer; maxLen=4000Applies when type in (currentPageInList)type in (currentPageNotInList) | |
text | string | Yes | data type=string; maxLen=4000Applies when type in (textIsContainedInItem)type in (textIsContainedInValue)type in (textIsNotContainedInValue)type in (text=value)type in (text!=value) | |
value | string | Yes | data type=string; maxLen=4000Applies when type 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) | |
list | array of strings | Yes | data type=string; maxLen=4000Applies when type in (itemIsInColonDelimitedList)type in (itemIsNotInColonDelimitedList) | |
item | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when type = textIsContainedInItem | |
value | string | Yes | data type=string; maxLen=4000Applies when type 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
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
authorizationScheme | enum | No | data type=reference; lov=COMPONENT; references=authorizationValid values: mustNotBePublicUser | |
escapeSpecialChars | boolean | Yes | true | data type=boolean |
security {
authorizationScheme: mustNotBePublicUser
escapeSpecialChars: false
}serverCache
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
caching | enum | Yes | false | data type=string; lov=STATICValid values: false true cacheByUser cacheBySession |
cacheTimeout | enum | Yes | 6Hours | data type=string; lov=STATICValid values: 10Seconds 1Minute 10Minutes 30Minutes 1Hour 2Hours 3Hours 4Hours 6Hours 12Hours 1Day 2Days 3Days 4Days 1Week 2Weeks 4Weeks 10Weeks 1Year |
dependsOnItems | array of strings | No | data type=string; maxLen=4000; textCase=UPPER | |
type | enum | No | data type=string; lov=STATICValid 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 neverSelect a condition type that must be met for the region to be cached. | |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type in (rowsReturned)type in (noRowsReturned) | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: sql plsql javaScript-mleApplies when type = expression |
sqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = expression and language = sql | |
plsqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = expression and language = plsql | |
javaScriptExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = expression and language = javaScript-mle | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when type = functionBody |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = functionBody and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = functionBody and language = javaScript-mle | |
value | string | Yes | data type=string; maxLen=4000Applies when type 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) | |
item | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when type 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) | |
preference | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when type in (userPreference=value)type in (userPreference!=value) | |
page | integer | Yes | data type=integer; maxLen=4000Applies when type in (currentPage=page)type in (currentPage!=page) | |
pages | array of integers | Yes | data type=integer; maxLen=4000Applies when type in (currentPageInList)type in (currentPageNotInList) | |
text | string | Yes | data type=string; maxLen=4000Applies when type in (textIsContainedInItem)type in (textIsContainedInValue)type in (textIsNotContainedInValue)type in (text=value)type in (text!=value) | |
value | string | Yes | data type=string; maxLen=4000Applies when type 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) | |
list | array of strings | Yes | data type=string; maxLen=4000Applies when type in (itemIsInColonDelimitedList)type in (itemIsNotInColonDelimitedList) | |
item | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when type = textIsContainedInItem | |
value | string | Yes | data type=string; maxLen=4000Applies when type 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
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
customizable | enum | Yes | false | data type=string; lov=STATICValid values: false shownByDefault notShownByDefault |
name | string | No | data type=string; maxLen=255Applies when customizable in (shownByDefault)customizable in (notShownByDefault) |
customization {
customizable: false
name: value
}config
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
buildOption | reference | No | data type=reference; lov=COMPONENT; references=buildOption |
config {
buildOption: @component
}comments
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
comments | multiline string | No | data type=multiline string; maxLen=4000 |
comments {
comments: ```
value
```
}rowSelection
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
type | enum | No | data type=string; lov=STATICValid values: focusOnly singleSelection multipleSelectionApplies when display = report | |
currentSelectionPageItem | string | No | data type=string; maxLen=255; textCase=UPPERApplies when display = report and type in (singleSelection)display = report and type in (multipleSelection) | |
selectAllPageItem | string | No | data type=string; maxLen=255; textCase=UPPERApplies when display = report and type = multipleSelection |
rowSelection {
type: focusOnly
currentSelectionPageItem: value
selectAllPageItem: value
}entityTitle
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
singular | string | No | data type=string; maxLen=255Applies when display = report | |
plural | string | No | data type=string; maxLen=255Applies when display = report |
entityTitle {
singular: value
plural: value
}APEXlang Example
region sample (
name: value
title: value
type: svgChart
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
}
)