region
| 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: breadcrumb calendar cards chart classicReport classicTree columnToggleReport dataUploadColMapping dynamicContent facetedSearch form helpText interactiveGrid interactiveReport legacyCalendar list listView map plSqlDynamicContent reflowReport regionDisplaySelector search simpleChart smartFilters staticContent svgChart tabform tree url workflowDiagram |
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 stockApplies when type = chart |
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 horizontalApplies when type = cards |
gridColumns | enum | No | data type=string; lov=STATICValid values: 2 3 4 5Applies when type = cards and layout = grid | |
listTemplate | reference | Yes | data type=reference; lov=COMPONENT; references=listTemplateApplies when type = list | |
breadcrumbTemplate | reference | Yes | data type=reference; lov=COMPONENT; references=breadcrumbTemplateApplies when type = breadcrumb | |
cssClasses | array of strings | No | data type=string; maxLen=255Applies when type = cardstype = classicReport and templateType = themetype = tabform and templateType = theme | |
templateOptions | array of strings | No | data type=string; lov=TEMPLATE_OPTIONSApplies when type = breadcrumb and breadcrumbTemplate is settype = list and listTemplate is settype = classicReport and templateType = theme and template is settype = tabform and templateType = theme and template is set | |
templateType | enum | Yes | theme | data type=string; lov=STATICValid values: theme predefinedApplies when type = classicReporttype = tabform |
template | reference | Yes | data type=reference; lov=COMPONENT; references=classicReportTemplateApplies when type = classicReport and templateType = themetype = tabform and templateType = theme | |
template | enum | Yes | html | data type=string; lov=STATICValid values: html verticalReport csv xmlApplies when type = classicReport and templateType = predefinedtype = tabform and templateType = predefined |
customAttributes | string | No | data type=string; maxLen=2000Applies when type = classicReporttype = tabformThe 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=255Applies when type = interactiveReporttype = classicReporttype = tabformtype = interactiveGrid | |
selectFirstRow | boolean | Yes | true | data type=booleanApplies when type = interactiveGrid |
fixedRowHeight | boolean | Yes | true | data type=booleanApplies when type = interactiveGrid |
componentAppearance {
display: report
layout: grid
gridColumns: "2"
listTemplate: @component
breadcrumbTemplate: @component
cssClasses: [
value
value
]
templateOptions: [
value
value
]
templateType: theme
template: @component
customAttributes: value
showNullValuesAs: value
selectFirstRow: false
fixedRowHeight: false
}edit
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
enabled | boolean | Yes | false | data type=booleanApplies when type = interactiveGridtype supports EDITABLE |
allowedOperations | array of enums | No | data type=string; lov=STATICValid values: add update deleteApplies when type = interactiveGrid and enabled = truetype supports EDITABLE and enabled = true | |
allowedRowOperationsColumn | string | No | data type=string; maxLen=32767Applies when type = interactiveGrid and enabled = true and allowedOperations in (update)type = interactiveGrid and enabled = true and allowedOperations in (delete)type supports EDITABLE and enabled = true and allowedOperations in (update)type supports EDITABLE and enabled = true and allowedOperations in (delete) | |
lostUpdateType | enum | Yes | rowValues | data type=string; lov=STATICValid values: rowValues rowVersionColumnApplies when type = interactiveGrid and enabled = truetype supports EDITABLE and enabled = true |
rowVersionColumn | string | Yes | data type=string; maxLen=32767Applies when type = interactiveGrid and enabled = true and lostUpdateType = rowVersionColumntype supports EDITABLE and enabled = true and lostUpdateType = rowVersionColumn | |
addRowIfEmpty | boolean | Yes | true | data type=booleanApplies when type = interactiveGrid and 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 excludeApplies when type = interactiveReport |
uniquelyIdentifyRowsBy | enum | Yes | rowid | data type=string; lov=STATICValid values: rowid uniqueColumnApplies when type = interactiveReport and linkColumn = singleRowView |
uniqueColumn | string | Yes | data type=string; maxLen=32767Applies when type = interactiveReport and linkColumn = singleRowView and uniquelyIdentifyRowsBy = uniqueColumn | |
target | complex | Yes | data type=complex; maxLen=32767Applies when type = interactiveReport and linkColumn = customTarget | |
linkIcon | multiline string | No | data type=multiline string; maxLen=4000Applies when type = interactiveReport and linkColumn in (singleRowView)type = interactiveReport and linkColumn in (customTarget) | |
linkAttributes | string | No | data type=string; maxLen=4000Applies when type = interactiveReport and linkColumn in (singleRowView)type = interactiveReport and linkColumn in (customTarget) | |
authorizationScheme | enum | No | data type=reference; lov=COMPONENT; references=authorizationValid values: mustNotBePublicUserApplies when type = interactiveReport and linkColumn in (singleRowView)type = interactiveReport and 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 type = interactiveReport and linkColumn in (singleRowView)type = interactiveReport and linkColumn in (customTarget) | |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = interactiveReport and linkColumn in (singleRowView) and conditionType in (rowsReturned)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (noRowsReturned)type = interactiveReport and linkColumn in (customTarget) and conditionType in (rowsReturned)type = interactiveReport and linkColumn in (customTarget) and conditionType in (noRowsReturned) | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: sql plsql javaScript-mleApplies when type = interactiveReport and linkColumn in (singleRowView) and conditionType = expressiontype = interactiveReport and linkColumn in (customTarget) and conditionType = expression |
sqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = interactiveReport and linkColumn in (singleRowView) and conditionType = expression and language = sqltype = interactiveReport and linkColumn in (customTarget) and conditionType = expression and language = sql | |
plsqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = interactiveReport and linkColumn in (singleRowView) and conditionType = expression and language = plsqltype = interactiveReport and linkColumn in (customTarget) and conditionType = expression and language = plsql | |
javaScriptExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = interactiveReport and linkColumn in (singleRowView) and conditionType = expression and language = javaScript-mletype = interactiveReport and linkColumn in (customTarget) and conditionType = expression and language = javaScript-mle | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when type = interactiveReport and linkColumn in (singleRowView) and conditionType = functionBodytype = interactiveReport and linkColumn in (customTarget) and conditionType = functionBody |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = interactiveReport and linkColumn in (singleRowView) and conditionType = functionBody and language = plsqltype = interactiveReport and linkColumn in (customTarget) and conditionType = functionBody and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = interactiveReport and linkColumn in (singleRowView) and conditionType = functionBody and language = javaScript-mletype = interactiveReport and linkColumn in (customTarget) and conditionType = functionBody and language = javaScript-mle | |
value | string | Yes | data type=string; maxLen=4000Applies when type = interactiveReport and linkColumn in (singleRowView) and conditionType in (request=Value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (request!=Value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (requestIsContainedInValue)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (requestIsNotContainedInValue)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (currentLanguageIsContainedInValue)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (currentLanguageIsNotContainedInValue)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (currentLanguage!=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (currentLanguage=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (cgiEnvDadName=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (cgiEnvDadName!=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (cgiEnvServerName=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (cgiEnvServerName!=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (cgiEnvHttpHost=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (cgiEnvHttpHost!=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (request=Value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (request!=Value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (requestIsContainedInValue)type = interactiveReport and linkColumn in (customTarget) and conditionType in (requestIsNotContainedInValue)type = interactiveReport and linkColumn in (customTarget) and conditionType in (currentLanguageIsContainedInValue)type = interactiveReport and linkColumn in (customTarget) and conditionType in (currentLanguageIsNotContainedInValue)type = interactiveReport and linkColumn in (customTarget) and conditionType in (currentLanguage!=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (currentLanguage=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (cgiEnvDadName=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (cgiEnvDadName!=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (cgiEnvServerName=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (cgiEnvServerName!=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (cgiEnvHttpHost=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (cgiEnvHttpHost!=value) | |
item | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when type = interactiveReport and linkColumn in (singleRowView) and conditionType in (item=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (item!=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (VALUE_OF_ITEM_IN_COND_1_EQ_COND_2)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (VALUE_OF_ITEM_IN_COND_1_NOT_EQ_COND_2)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemIsNull)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemIsNotNull)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemIsZero)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemIsNotZero)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemIsNullOrZero)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemIsNotNullAndNotZero)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemContainsNoSpaces)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemIsNumeric)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemIsNotNumeric)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemIsAlphanumeric)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemIsInColonDelimitedList)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemIsNotInColonDelimitedList)type = interactiveReport and linkColumn in (customTarget) and conditionType in (item=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (item!=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (VALUE_OF_ITEM_IN_COND_1_EQ_COND_2)type = interactiveReport and linkColumn in (customTarget) and conditionType in (VALUE_OF_ITEM_IN_COND_1_NOT_EQ_COND_2)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemIsNull)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemIsNotNull)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemIsZero)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemIsNotZero)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemIsNullOrZero)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemIsNotNullAndNotZero)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemContainsNoSpaces)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemIsNumeric)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemIsNotNumeric)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemIsAlphanumeric)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemIsInColonDelimitedList)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemIsNotInColonDelimitedList) | |
preference | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when type = interactiveReport and linkColumn in (singleRowView) and conditionType in (userPreference=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (userPreference!=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (userPreference=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (userPreference!=value) | |
page | integer | Yes | data type=integer; maxLen=4000Applies when type = interactiveReport and linkColumn in (singleRowView) and conditionType in (currentPage=page)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (currentPage!=page)type = interactiveReport and linkColumn in (customTarget) and conditionType in (currentPage=page)type = interactiveReport and linkColumn in (customTarget) and conditionType in (currentPage!=page) | |
pages | array of integers | Yes | data type=integer; maxLen=4000Applies when type = interactiveReport and linkColumn in (singleRowView) and conditionType in (currentPageInList)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (currentPageNotInList)type = interactiveReport and linkColumn in (customTarget) and conditionType in (currentPageInList)type = interactiveReport and linkColumn in (customTarget) and conditionType in (currentPageNotInList) | |
text | string | Yes | data type=string; maxLen=4000Applies when type = interactiveReport and linkColumn in (singleRowView) and conditionType in (textIsContainedInItem)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (textIsContainedInValue)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (textIsNotContainedInValue)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (text=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (text!=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (textIsContainedInItem)type = interactiveReport and linkColumn in (customTarget) and conditionType in (textIsContainedInValue)type = interactiveReport and linkColumn in (customTarget) and conditionType in (textIsNotContainedInValue)type = interactiveReport and linkColumn in (customTarget) and conditionType in (text=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (text!=value) | |
value | string | Yes | data type=string; maxLen=4000Applies when type = interactiveReport and linkColumn in (singleRowView) and conditionType in (item=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (item!=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (VALUE_OF_ITEM_IN_COND_1_EQ_COND_2)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (VALUE_OF_ITEM_IN_COND_1_NOT_EQ_COND_2)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (userPreference=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (userPreference!=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (item=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (item!=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (VALUE_OF_ITEM_IN_COND_1_EQ_COND_2)type = interactiveReport and linkColumn in (customTarget) and conditionType in (VALUE_OF_ITEM_IN_COND_1_NOT_EQ_COND_2)type = interactiveReport and linkColumn in (customTarget) and conditionType in (userPreference=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (userPreference!=value) | |
list | array of strings | Yes | data type=string; maxLen=4000Applies when type = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemIsInColonDelimitedList)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (itemIsNotInColonDelimitedList)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemIsInColonDelimitedList)type = interactiveReport and linkColumn in (customTarget) and conditionType in (itemIsNotInColonDelimitedList) | |
item | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when type = interactiveReport and linkColumn in (singleRowView) and conditionType = textIsContainedInItemtype = interactiveReport and linkColumn in (customTarget) and conditionType = textIsContainedInItem | |
value | string | Yes | data type=string; maxLen=4000Applies when type = interactiveReport and linkColumn in (singleRowView) and conditionType in (textIsContainedInValue)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (textIsNotContainedInValue)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (text=value)type = interactiveReport and linkColumn in (singleRowView) and conditionType in (text!=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (textIsContainedInValue)type = interactiveReport and linkColumn in (customTarget) and conditionType in (textIsNotContainedInValue)type = interactiveReport and linkColumn in (customTarget) and conditionType in (text=value)type = interactiveReport and linkColumn in (customTarget) and conditionType in (text!=value) |
link {
linkColumn: singleRowView
uniquelyIdentifyRowsBy: rowid
uniqueColumn: value
target: {
type: in_app
url: value
app: value
page: value
items: [
value
value
]
clearCache: value
action: value
request: value
anchor: value
session: "&SESSION."
debug: "&DEBUG."
printerFriendly: N
otherArgs: value
}
linkIcon: ```
value
```
linkAttributes: value
authorizationScheme: mustNotBePublicUser
conditionType: always
sqlQuery: ```sql
value
```
language: sql
sqlExpression: ```sql
value
```
plsqlExpression: ```plsql
value
```
javaScriptExpression: ```javascript-mle
value
```
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
value: value
item: value
preference: value
page: 42
pages: [
42
42
]
text: value
list: [
value
value
]
}map
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
background | enum | Yes | default | data type=string; lov=STATICValid values: default builtIn sharedComponentApplies when type = map |
standard | enum | Yes | openstreetmapPositron | data type=string; lov=STATICValid values: openstreetmapPositron openstreetmapDark openstreetmapBright oracleWorldMap oracleBiWorldMapApplies when type = map and background = builtIn |
darkMode | enum | No | data type=string; lov=STATICValid values: openstreetmapDark openstreetmapPositron openstreetmapBright oracleWorldMap oracleBiWorldMapApplies when type = map and background = builtIn | |
standard | reference | Yes | data type=reference; lov=COMPONENT; references=mapBackgroundApplies when type = map and background = sharedComponent | |
darkMode | reference | No | data type=reference; lov=COMPONENT; references=mapBackgroundApplies when type = map and background = sharedComponent | |
height | number | Yes | 640 | data type=number; maxLen=22Applies when type = map |
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 type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = true | |
linkText | string | No | data type=string; maxLen=255Applies when type = classicReport and enabled = truetype = tabform and enabled = true | |
format | enum | No | data type=string; lov=STATICValid values: pdf word excel html xmlApplies when type = classicReport and enabled = truetype = tabform and enabled = true | |
viewFileAs | enum | Yes | attachment | data type=string; lov=STATICValid values: attachment inlineApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = true |
formatItem | string | Yes | data type=string; maxLen=255; textCase=UPPERApplies when type = classicReport and enabled = truetype = tabform and enabled = true | |
fileName | string | No | data type=string; maxLen=255Applies when type = classicReport and enabled = truetype = tabform and 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 type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
orientation | enum | Yes | landscape | data type=string; lov=STATICValid values: portrait landscapeApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
units | enum | Yes | inches | data type=string; lov=STATICValid values: inches millimeters centimeters pointsApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
width | number | Yes | 11 | data type=number; maxLen=22Applies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
height | number | Yes | 8.5 | data type=number; maxLen=22Applies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
borderWidth | number | No | data type=number; maxLen=255Applies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) | |
borderColor | string | No | data type=string; maxLen=255Applies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
page {
size: letter
orientation: portrait
units: inches
width: 42
height: 42
borderWidth: 42
borderColor: value
}reportLayout
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
numberOfRowsType | enum | Yes | staticValue | data type=string; lov=STATICValid values: staticValue itemValueApplies when type = classicReporttype = tabformtype supports FETCHED_ROWS |
numberOfRows | integer | Yes | 15 | data type=integer; maxLen=32767Applies when type = classicReport and numberOfRowsType = staticValuetype = tabform and numberOfRowsType = staticValuetype supports FETCHED_ROWS and numberOfRowsType = staticValue |
item | string | Yes | data type=string; maxLen=255; textCase=UPPERApplies when type = classicReport and numberOfRowsType = itemValuetype = tabform and numberOfRowsType = itemValuetype supports FETCHED_ROWS and numberOfRowsType = itemValue |
reportLayout {
numberOfRowsType: staticValue
numberOfRows: 42
item: value
}title
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
title | string | No | data type=string; maxLen=255Applies when type = chart | |
advancedFormatting | boolean | Yes | false | data type=booleanApplies when type = cards |
column | string | No | data type=string; maxLen=32767Applies when type = cards and advancedFormatting = false | |
htmlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = cards and advancedFormatting = true | |
cssClasses | array of strings | No | data type=string; maxLen=255Applies when type = cards and 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 = chart and type in (area)type = chart and type in (bar)type = chart and type in (combination)type = chart and type in (funnel)type = chart and type in (line)type = chart and type in (lineWithArea)type = chart and type in (boxPlot)type = chart and type in (range) |
stack | boolean | Yes | off | data type=booleanApplies when type = chart and type in (area)type = chart and type in (bar)type = chart and type in (line)type = chart and type in (lineWithArea)type = chart and type in (combination)type = chart and type in (polar)type = chart and type in (radar) |
stackLabel | boolean | Yes | off | data type=booleanApplies when type = chart and type = bar and type in (area) and stack = ontype = chart and type = bar and type in (bar) and stack = ontype = chart and type = bar and type in (line) and stack = ontype = chart and type = bar and type in (lineWithArea) and stack = ontype = chart and type = bar and type in (combination) and stack = ontype = chart and type = bar and type in (polar) and stack = ontype = chart and type = bar and type in (radar) and stack = on |
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 = chart and type = bar and type in (area) and stack = on and stackLabel = ontype = chart and type = bar and type in (bar) and stack = on and stackLabel = ontype = chart and type = bar and type in (line) and stack = on and stackLabel = ontype = chart and type = bar and type in (lineWithArea) and stack = on and stackLabel = ontype = chart and type = bar and type in (combination) and stack = on and stackLabel = ontype = chart and type = bar and type in (polar) and stack = on and stackLabel = ontype = chart and type = bar and type in (radar) and stack = on and stackLabel = on | |
fontStyle | enum | No | data type=string; lov=STATICValid values: normal italic obliqueApplies when type = chart and type = bar and type in (area) and stack = on and stackLabel = ontype = chart and type = bar and type in (bar) and stack = on and stackLabel = ontype = chart and type = bar and type in (line) and stack = on and stackLabel = ontype = chart and type = bar and type in (lineWithArea) and stack = on and stackLabel = ontype = chart and type = bar and type in (combination) and stack = on and stackLabel = ontype = chart and type = bar and type in (polar) and stack = on and stackLabel = ontype = chart and type = bar and type in (radar) and stack = on and stackLabel = on | |
fontSize | enum | No | data type=string; lov=STATICValid values: 8 10 12 14 16 18 20 22Applies when type = chart and type = bar and type in (area) and stack = on and stackLabel = ontype = chart and type = bar and type in (bar) and stack = on and stackLabel = ontype = chart and type = bar and type in (line) and stack = on and stackLabel = ontype = chart and type = bar and type in (lineWithArea) and stack = on and stackLabel = ontype = chart and type = bar and type in (combination) and stack = on and stackLabel = ontype = chart and type = bar and type in (polar) and stack = on and stackLabel = ontype = chart and type = bar and type in (radar) and stack = on and stackLabel = on | |
fontColor | string | No | data type=string; maxLen=255Applies when type = chart and type = bar and type in (area) and stack = on and stackLabel = ontype = chart and type = bar and type in (bar) and stack = on and stackLabel = ontype = chart and type = bar and type in (line) and stack = on and stackLabel = ontype = chart and type = bar and type in (lineWithArea) and stack = on and stackLabel = ontype = chart and type = bar and type in (combination) and stack = on and stackLabel = ontype = chart and type = bar and type in (polar) and stack = on and stackLabel = ontype = chart and type = bar and type in (radar) and stack = on and stackLabel = on |
chartAppearance {
orientation: vertical
stack: false
stackLabel: false
fontFamily: arial
fontStyle: normal
fontSize: "8"
fontColor: value
}card
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
cssClasses | array of strings | No | data type=string; maxLen=255Applies when type = cards | |
primaryKeyColumn1 | string | No | data type=string; maxLen=32767Applies when type = cards | |
primaryKeyColumn2 | string | No | data type=string; maxLen=32767Applies when type = cards and 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=32767Applies when type supports SOURCE_SQL | |
plsqlCode | multiline string | No | data type=multiline string; maxLen=32767Applies when type supports SOURCE_PLSQLEnter the PL/SQL code to generate the HTML output. | |
plsqlFunctionBody | multiline string | No | data type=multiline string; maxLen=32767Applies when type supports SOURCE_PLSQL_FUNCTION | |
htmlCode | multiline string | No | data type=multiline string; maxLen=32767Applies when type supports SOURCE_HTML | |
text | multiline string | No | data type=multiline string; maxLen=32767Applies when type supports SOURCE_PLAIN | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when type = dynamicContent |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=32767Applies when type = dynamicContent and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=32767Applies when type = dynamicContent and language = javaScript-mle | |
location | enum | No | localDatabase | data type=string; lov=STATICValid values: localDatabase restEnabledSql restSource jsonDualityView jsonSource sampleDataApplies when type supports SOURCE_LOCATION |
remoteServer | reference | Yes | data type=reference; lov=COMPONENT; references=restEnabledSqlDatabaseApplies when type supports SOURCE_LOCATION and location = restEnabledSql | |
sampleData | enum | Yes | data type=string; lov=STATICValid values: employees tasks products projectsApplies when type supports SOURCE_LOCATION and location = sampleData | |
type | enum | Yes | tableView | data type=string; lov=STATICValid values: tableView sqlQuery functionBody propertyGraphApplies when type supports SOURCE_LOCATION and location in (localDatabase)type supports SOURCE_LOCATION and location in (restEnabledSql) |
tableOwner | string | No | data type=string; maxLen=32767Applies when type supports SOURCE_LOCATION and location in (localDatabase) and type = tableViewtype supports SOURCE_LOCATION and location in (restEnabledSql) and type = tableView | |
tableName | string | Yes | data type=string; maxLen=128Applies when type supports SOURCE_LOCATION and location in (localDatabase) and type = tableViewtype supports SOURCE_LOCATION and location in (restEnabledSql) and type = tableView | |
includeRowidColumn | boolean | Yes | false | data type=booleanApplies when type supports SOURCE_LOCATION and location in (localDatabase) and type = tableView and location = restEnabledSql and remoteServer supports IS_ORACLEtype supports SOURCE_LOCATION and location in (restEnabledSql) and type = tableView and location = restEnabledSql and remoteServer supports IS_ORACLE |
whereClause | multiline string | No | data type=multiline string; maxLen=4000Applies when type supports SOURCE_LOCATION and location in (localDatabase) and type = tableViewtype supports SOURCE_LOCATION and location in (restEnabledSql) and type = tableView | |
graphOwner | string | No | data type=string; maxLen=32767Applies when type supports SOURCE_LOCATION and location in (localDatabase) and type = propertyGraphtype supports SOURCE_LOCATION and location in (restEnabledSql) and type = propertyGraph | |
graphName | string | Yes | data type=string; maxLen=32767Applies when type supports SOURCE_LOCATION and location in (localDatabase) and type = propertyGraphtype supports SOURCE_LOCATION and location in (restEnabledSql) and type = propertyGraph | |
matchClause | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports SOURCE_LOCATION and location in (localDatabase) and type = propertyGraphtype supports SOURCE_LOCATION and location in (restEnabledSql) and type = propertyGraph | |
columnsClause | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports SOURCE_LOCATION and location in (localDatabase) and type = propertyGraphtype supports SOURCE_LOCATION and location in (restEnabledSql) and type = propertyGraph | |
whereClause | multiline string | No | data type=multiline string; maxLen=4000Applies when type supports SOURCE_LOCATION and location in (localDatabase) and type = propertyGraphtype supports SOURCE_LOCATION and location in (restEnabledSql) and type = propertyGraph | |
orderByClause | multiline string | No | data type=multiline string; maxLen=255Applies when type supports SOURCE_LOCATION and location in (localDatabase) and type = tableView and type in (interactiveGrid)type supports SOURCE_LOCATION and location in (localDatabase) and type = tableView and type in (interactiveReport)type supports SOURCE_LOCATION and location in (localDatabase) and type = tableView and type in (map)type supports SOURCE_LOCATION and location in (localDatabase) and type = tableView and type in (form)type supports SOURCE_LOCATION and location in (restEnabledSql) and type = tableView and type in (interactiveGrid)type supports SOURCE_LOCATION and location in (restEnabledSql) and type = tableView and type in (interactiveReport)type supports SOURCE_LOCATION and location in (restEnabledSql) and type = tableView and type in (map)type supports SOURCE_LOCATION and location in (restEnabledSql) and type = tableView and type in (form) | |
orderByClause | multiline string | No | data type=multiline string; maxLen=255Applies when type supports SOURCE_LOCATION and location in (localDatabase) and type = propertyGraph and type in (interactiveGrid)type supports SOURCE_LOCATION and location in (localDatabase) and type = propertyGraph and type in (interactiveReport)type supports SOURCE_LOCATION and location in (localDatabase) and type = propertyGraph and type in (map)type supports SOURCE_LOCATION and location in (localDatabase) and type = propertyGraph and type in (form)type supports SOURCE_LOCATION and location in (restEnabledSql) and type = propertyGraph and type in (interactiveGrid)type supports SOURCE_LOCATION and location in (restEnabledSql) and type = propertyGraph and type in (interactiveReport)type supports SOURCE_LOCATION and location in (restEnabledSql) and type = propertyGraph and type in (map)type supports SOURCE_LOCATION and location in (restEnabledSql) and type = propertyGraph and type in (form) | |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=32767Applies when type supports SOURCE_LOCATION and location in (localDatabase) and type = sqlQuerytype supports SOURCE_LOCATION and location in (restEnabledSql) and type = sqlQuery | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when type supports SOURCE_LOCATION and location in (localDatabase) and type = functionBodytype supports SOURCE_LOCATION and location in (restEnabledSql) and type = functionBody |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=32767Applies when type supports SOURCE_LOCATION and location in (localDatabase) and type = functionBody and language = plsqltype supports SOURCE_LOCATION and location in (restEnabledSql) and type = functionBody and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=32767Applies when type supports SOURCE_LOCATION and location in (localDatabase) and type = functionBody and language = javaScript-mletype supports SOURCE_LOCATION and location in (restEnabledSql) and type = functionBody and language = javaScript-mle | |
restSource | reference | Yes | data type=reference; lov=COMPONENT; references=restDataSourceApplies when type supports SOURCE_LOCATION and location = restSource | |
jsonDualityView | reference | Yes | data type=reference; lov=COMPONENT; references=jsonDualityViewApplies when type supports SOURCE_LOCATION and location = jsonDualityView | |
jsonSource | reference | Yes | data type=reference; lov=COMPONENT; references=jsonSourceApplies when type supports SOURCE_LOCATION and location = jsonSource | |
list | reference | Yes | data type=reference; lov=COMPONENT; references=listApplies when type in (list) | |
breadcrumb | reference | Yes | data type=reference; lov=COMPONENT; references=breadcrumbApplies when type in (breadcrumb) | |
filteredRegion | reference | Yes | data type=reference; lov=COMPONENT; references=regionApplies when type in (facetedSearch)type in (smartFilters) | |
pageItemsToSubmit | array of strings | No | data type=string; maxLen=4000; textCase=UPPERApplies when type supports AJAX_ITEMS_TO_SUBMIT | |
optimizerHint | string | No | data type=string; maxLen=255Applies when type supports SOURCE_LOCATION and location in (localDatabase)type supports SOURCE_LOCATION and location in (restEnabledSql)type supports SOURCE_LOCATION and location in (restSource)type supports SOURCE_LOCATION and location in (jsonDualityView)type supports SOURCE_LOCATION and location in (jsonSource) | |
useGenericColumnNames | boolean | Yes | DERIVED_REPORT_COLUMNS | data type=booleanApplies when type = classicReport and type supports SOURCE_LOCATION and location in (localDatabase) and type = functionBodytype = classicReport and type supports SOURCE_LOCATION and location in (restEnabledSql) and type = functionBody |
genericColumnCount | integer | Yes | data type=integer; maxLen=3Applies when type = classicReport and type supports SOURCE_LOCATION and location in (localDatabase) and type = functionBody and useGenericColumnNames = GENERIC_REPORT_COLUMNStype = classicReport and type supports SOURCE_LOCATION and location in (restEnabledSql) and type = functionBody and useGenericColumnNames = GENERIC_REPORT_COLUMNS |
source {
plsqlCode: ```plsql
value
```
htmlCode: ```html
value
```
text: ```
value
```
language: plsql
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
location: localDatabase
remoteServer: @component
sampleData: employees
type: tableView
tableOwner: value
tableName: value
includeRowidColumn: false
whereClause: ```sql
value
```
graphOwner: value
graphName: value
matchClause: ```
value
```
columnsClause: ```
value
```
orderByClause: ```sql
value
```
sqlQuery: ```sql
value
```
restSource: @component
jsonDualityView: @component
jsonSource: @component
list: @component
breadcrumb: @component
filteredRegion: @component
pageItemsToSubmit: [
value
value
]
optimizerHint: value
useGenericColumnNames: false
genericColumnCount: 42
}controls
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
navigationBar | enum | Yes | zoomAndCompass | data type=string; lov=STATICValid values: none zoomOnly zoomAndCompassApplies when type = map |
navigationBarPosition | enum | Yes | end | data type=string; lov=STATICValid values: start endApplies when type = map |
options | array of enums | No | data type=string; lov=STATICValid values: mousewheelZoom rectangleZoom scaleBar overviewMap infiniteMap getBrowserLocation circleTool distanceToolApplies when type = map |
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 type = interactiveGrid and enabled = true and allowedOperations = addtype supports EDITABLE and enabled = true and allowedOperations = add | |
update | enum | No | data type=reference; lov=COMPONENT; references=authorizationValid values: mustNotBePublicUserApplies when type = interactiveGrid and enabled = true and allowedOperations = updatetype supports EDITABLE and enabled = true and allowedOperations = update | |
delete | enum | No | data type=reference; lov=COMPONENT; references=authorizationValid values: mustNotBePublicUserApplies when type = interactiveGrid and enabled = true and allowedOperations = deletetype supports EDITABLE and 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 type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
fontWeight | enum | Yes | normal | data type=string; lov=STATICValid values: normal boldApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
fontSize | integer | Yes | 12 | data type=integer; maxLen=32767Applies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
fontColor | string | Yes | #000000 | data type=string; maxLen=255Applies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
alignment | enum | Yes | center | data type=string; lov=STATICValid values: start center endApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
pageHeaderText | multiline string | No | data type=multiline string; maxLen=4000Applies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
pageHeader {
font: helvetica
fontWeight: normal
fontSize: 42
fontColor: value
alignment: start
pageHeaderText: ```
value
```
}chartLayout
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
maxWidth | integer | No | data type=integer; maxLen=32767Applies when type = chart | |
height | integer | No | data type=integer; maxLen=32767Applies when type = chart |
chartLayout {
maxWidth: 42
height: 42
}initialPositionAndZoom
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
getPositionFromBrowser | boolean | Yes | false | data type=booleanApplies when type = map and options = getBrowserLocation |
type | enum | Yes | basedOnSpatialResults | data type=string; lov=STATICValid values: staticValues sqlQuery basedOnSpatialResultsApplies when type = map |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=32767Applies when type = map and type = sqlQuery | |
geometryColumnDataType | enum | Yes | data type=string; lov=STATICValid values: sdoGeometry geojson longitudeLatitudeApplies when type = map and type = sqlQuery | |
initialLongitudeColumn | string | Yes | data type=string; maxLen=32767Applies when type = map and type = sqlQuery and geometryColumnDataType = longitudeLatitude | |
initialLatitudeColumn | string | Yes | data type=string; maxLen=32767Applies when type = map and type = sqlQuery and geometryColumnDataType = longitudeLatitude | |
geometryColumn | string | Yes | data type=string; maxLen=32767Applies when type = map and type = sqlQuery and geometryColumnDataType = sdoGeometry | |
geojsonColumn | string | Yes | data type=string; maxLen=32767Applies when type = map and type = sqlQuery and geometryColumnDataType = geojson | |
initialZoomlevelColumn | string | No | data type=string; maxLen=32767Applies when type = map and type = sqlQuery | |
longitude | string | Yes | data type=string; maxLen=32767Applies when type = map and type = staticValues | |
latitude | string | Yes | data type=string; maxLen=32767Applies when type = map and type = staticValues | |
zoomLevel | string | No | data type=string; maxLen=32767Applies when type = map and type in (staticValues)type = map and type in (basedOnSpatialResults) |
initialPositionAndZoom {
getPositionFromBrowser: false
type: staticValues
sqlQuery: ```sql
value
```
geometryColumnDataType: sdoGeometry
initialLongitudeColumn: value
initialLatitudeColumn: value
geometryColumn: value
geojsonColumn: value
initialZoomlevelColumn: value
longitude: value
latitude: value
zoomLevel: value
}performance
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
lazyLoading | boolean | Yes | false | data type=booleanApplies when type = interactiveReporttype = charttype = interactiveGridtype = cardstype = maptype = classicReport and partialPageRefresh = truetype = tabform and partialPageRefresh = truetype supports LAZY_LOADING and type supports SOURCE_LOCATION and location is set |
maxRowsToProcess | integer | No | data type=integer; maxLen=32767Applies when type = classicReporttype = tabformtype = interactiveReport | |
lazyLoading | boolean | Yes | false | data type=booleanApplies when type supports LAZY_LOADING_ALWAYS |
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 nextAndPreviousLinksApplies when type = classicReporttype = tabform |
displayPosition | enum | Yes | bottomRight | data type=string; lov=STATICValid values: bottomLeft bottomRight topLeft topRight topAndBottomLeft topAndBottomRightApplies when type = interactiveReport and type is settype = classicReporttype = tabform |
partialPageRefresh | boolean | Yes | true | data type=booleanApplies when type = classicReporttype = tabform |
type | enum | Yes | scroll | data type=string; lov=STATICValid values: page scrollApplies when type = interactiveGridtype = cardsdisplay = report |
showTotalCount | boolean | Yes | true | data type=booleanApplies when type = interactiveGridtype = cardsdisplay = report |
type | enum | No | data type=string; lov=STATICValid values: rowRangesXToYOfZ rowRangesXToYApplies when type = interactiveReport | |
maxRowsToDisplay | string | No | data type=string; maxLen=32767Applies when type = interactiveReport | |
cardsPerPage | integer | Yes | 15 | data type=integer; maxLen=32767Applies when type = cards and 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 = chart and type = statusMeterGauge |
showPlotArea | boolean | Yes | on | data type=booleanApplies when type = chart and type = statusMeterGauge |
indicatorSize | number | Yes | 1 | data type=number; maxLen=22Applies when type = chart and type = statusMeterGauge |
innerRadius | number | Yes | 0.7 | data type=number; maxLen=22Applies when type = chart and type = statusMeterGauge and orientation = circular |
startAngle | number | Yes | 90 | data type=number; maxLen=22Applies when type = chart and type = statusMeterGauge and orientation = circular |
angleExtent | number | Yes | 360 | data type=number; maxLen=22Applies when type = chart and 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 type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
fontWeight | enum | Yes | bold | data type=string; lov=STATICValid values: normal boldApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
fontSize | integer | Yes | 10 | data type=integer; maxLen=32767Applies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
fontColor | string | Yes | #000000 | data type=string; maxLen=255Applies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
backgroundColor | string | Yes | #EEEEEE | data type=string; maxLen=255Applies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
columnHeadings {
font: helvetica
fontWeight: normal
fontSize: 42
fontColor: value
backgroundColor: value
}subtitle
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
advancedFormatting | boolean | Yes | false | data type=booleanApplies when type = cards |
column | string | No | data type=string; maxLen=32767Applies when type = cards and advancedFormatting = false | |
htmlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = cards and advancedFormatting = true | |
cssClasses | array of strings | No | data type=string; maxLen=255Applies when type = cards and 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 type = interactiveReporttype = classicReporttype = tabformtype = charttype = interactiveGridtype = cardstype supports NO_DATA_FOUND_MESSAGE and display = report | |
whenMoreDataFound | multiline string | No | data type=multiline string; maxLen=4000Applies when type = interactiveReporttype = classicReporttype = tabform | |
noDataFoundIcon | string | No | data type=string; maxLen=4000Applies when type = cards and whenNoDataFound is settype supports NO_DATA_FOUND_ICON and type supports NO_DATA_FOUND_MESSAGE and display = report and whenNoDataFound is set |
messages {
whenNoDataFound: ```
value
```
whenMoreDataFound: ```
value
```
noDataFoundIcon: value
}toolbar
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
show | boolean | Yes | true | data type=booleanApplies when type = interactiveGrid |
controls | array of enums | No | data type=string; lov=STATICValid values: searchCol searchField actionsMenu resetButton saveButtonApplies when type = interactiveGrid and show = true | |
addButtonLabel | string | No | data type=string; maxLen=255Applies when type = interactiveGrid and 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=booleanApplies when type = cards |
column | string | No | data type=string; maxLen=32767Applies when type = cards and advancedFormatting = false | |
htmlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = cards and advancedFormatting = true | |
cssClasses | array of strings | No | data type=string; maxLen=255Applies when type = cards and 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=255Applies when type = classicReporttype = tabform | |
breakColumns | enum | No | data type=string; lov=STATICValid values: col1 cols1-2 cols1-3Applies when type = classicReporttype = tabform | |
style | enum | Yes | default | data type=string; lov=STATICValid values: repeatHeadings defaultApplies when type = classicReport and breakColumns is settype = tabform and breakColumns is set |
repeatHeadingFormat | multiline string | No | data type=multiline string; maxLen=4000Applies when type = classicReport and breakColumns is set and style = repeatHeadingstype = tabform and breakColumns is set and style = repeatHeadings | |
reportBreakFormat | string | No | data type=string; maxLen=2000Applies when type = classicReport and breakColumns is settype = tabform and breakColumns is set | |
beforeRow | string | No | data type=string; maxLen=2000Applies when type = classicReport and breakColumns is settype = tabform and breakColumns is set | |
columnBreakFormat | string | No | data type=string; maxLen=2000Applies when type = classicReport and breakColumns is settype = tabform and breakColumns is set | |
afterRow | string | No | data type=string; maxLen=2000Applies when type = classicReport and breakColumns is settype = tabform and breakColumns is set |
breakFormatting {
reportSumLabel: value
breakColumns: col1
style: repeatHeadings
repeatHeadingFormat: ```
value
```
reportBreakFormat: value
beforeRow: value
columnBreakFormat: value
afterRow: value
}columns
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
font | enum | Yes | helvetica | data type=string; lov=STATICValid values: helvetica times courierApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
fontWeight | enum | Yes | normal | data type=string; lov=STATICValid values: normal boldApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
fontSize | integer | Yes | 10 | data type=integer; maxLen=32767Applies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
fontColor | string | Yes | #000000 | data type=string; maxLen=255Applies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
backgroundColor | string | Yes | #FFFFFF | data type=string; maxLen=255Applies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
widthUnits | enum | Yes | percent | data type=string; lov=STATICValid values: percent pointApplies when type = classicReport and enabled = truetype = tabform and 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 falseApplies when type = chart |
behavior | enum | Yes | auto | data type=string; lov=STATICValid values: auto smooth snapApplies when type = chart and cursor in (auto)type = chart and cursor in (true) |
dimOnHover | boolean | Yes | dim | data type=booleanApplies when type = chart |
dataCursor {
cursor: auto
behavior: auto
dimOnHover: false
}enableUsersTo
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
savePublicReport | boolean | Yes | false | data type=booleanApplies when type = interactiveGrid |
savePublicReportAuthorization | enum | No | data type=reference; lov=COMPONENT; references=authorizationValid values: mustNotBePublicUserApplies when type = interactiveGrid and savePublicReport = true | |
flashback | boolean | Yes | true | data type=booleanApplies when type = interactiveGrid |
defineChartView | boolean | Yes | true | data type=booleanApplies when type = interactiveGrid |
download | boolean | Yes | true | data type=booleanApplies when type = interactiveGrid |
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 sqlQueryApplies when type = map | |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = map and type = sqlQuery | |
geometryColumnDataType | enum | Yes | sdoGeometry | data type=string; lov=STATICValid values: sdoGeometry longitudeLatitudeApplies when type = map and type = sqlQuery |
minLongitude | string | Yes | data type=string; maxLen=32767Applies when type = map and type = sqlQuery and geometryColumnDataType = longitudeLatitude | |
minLatitude | string | Yes | data type=string; maxLen=32767Applies when type = map and type = sqlQuery and geometryColumnDataType = longitudeLatitude | |
maxLongitude | string | Yes | data type=string; maxLen=32767Applies when type = map and type = sqlQuery and geometryColumnDataType = longitudeLatitude | |
maxLatitude | string | Yes | data type=string; maxLen=32767Applies when type = map and type = sqlQuery and geometryColumnDataType = longitudeLatitude | |
geometryColumn | string | Yes | data type=string; maxLen=32767Applies when type = map and type = sqlQuery and geometryColumnDataType = sdoGeometry | |
minLongitude | string | Yes | data type=string; maxLen=128Applies when type = map and type = staticValues | |
minLatitude | string | Yes | data type=string; maxLen=128Applies when type = map and type = staticValues | |
maxLongitude | string | Yes | data type=string; maxLen=128Applies when type = map and type = staticValues | |
maxLatitude | string | Yes | data type=string; maxLen=128Applies when type = map and type = staticValues | |
currentBoundsItem | string | No | data type=string; maxLen=32767; textCase=UPPERApplies when type = map |
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=booleanApplies when type = chart |
sortOrder | enum | Yes | labelAsc | data type=string; lov=STATICValid values: valueAsc valueDesc labelAsc labelDescApplies when type = chart and fillGapsInChartData = true |
renderGapAsZero | boolean | Yes | true | data type=booleanApplies when type = chart and type in (line) and fillGapsInChartData = truetype = chart and type in (lineWithArea) and fillGapsInChartData = truetype = chart and type in (area) and fillGapsInChartData = truetype = chart and type in (scatter) and fillGapsInChartData = truetype = chart and type in (bar) and fillGapsInChartData = truetype = chart and type in (combination) and fillGapsInChartData = true |
multiSeriesChartData {
fillGapsInChartData: false
sortOrder: valueAsc
renderGapAsZero: false
}secondaryBody
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
advancedFormatting | boolean | Yes | false | data type=booleanApplies when type = cards |
column | string | No | data type=string; maxLen=32767Applies when type = cards and advancedFormatting = false | |
htmlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = cards and advancedFormatting = true | |
cssClasses | array of strings | No | data type=string; maxLen=255Applies when type = cards and 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 type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
fontWeight | enum | Yes | normal | data type=string; lov=STATICValid values: normal boldApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
fontSize | integer | Yes | 12 | data type=integer; maxLen=32767Applies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
fontColor | string | Yes | #000000 | data type=string; maxLen=255Applies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
alignment | enum | Yes | center | data type=string; lov=STATICValid values: start center endApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
pageFooterText | multiline string | No | data type=multiline string; maxLen=4000Applies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (excel)type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats in (pdf)type = classicReport and enabled = truetype = tabform and enabled = truetype = interactiveGrid and download = true and formats in (excel)type = interactiveGrid and download = true and formats in (pdf) |
pageFooter {
font: helvetica
fontWeight: normal
fontSize: 42
fontColor: value
alignment: start
pageFooterText: ```
value
```
}download
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
authorization | enum | No | data type=reference; lov=COMPONENT; references=authorizationValid values: mustNotBePublicUserApplies when type = interactiveGrid and download = truetype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true | |
formats | array of enums | No | data type=string; lov=STATICValid values: csv html pdf excelApplies when type = interactiveGrid and download = true | |
sendAsEmail | boolean | Yes | true | data type=booleanApplies when type = interactiveGrid and download = truetype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true |
csvSeparator | string | No | data type=string; maxLen=2Applies when type = classicReport and csvExportEnabled = truetype = tabform and csvExportEnabled = truetype = interactiveGrid and download = true and formats = csvtype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats = csv | |
csvEnclosedBy | string | No | data type=string; maxLen=1Applies when type = classicReport and csvExportEnabled = truetype = tabform and csvExportEnabled = truetype = interactiveGrid and download = true and formats = csvtype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats = csv | |
csvExportEnabled | boolean | Yes | false | data type=booleanApplies when type = classicReporttype = tabform |
filename | string | No | data type=string; maxLen=255Applies when type = classicReport and csvExportEnabled = truetype = tabform and csvExportEnabled = truetype = interactiveGrid and download = truetype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true | |
supplementalText | multiline string | No | data type=multiline string; maxLen=4000Applies when type = classicReporttype = tabformtype = interactiveGrid and download = true and formats is settype = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true and formats is set | |
linkText | string | Yes | Download | data type=string; maxLen=255Applies when type = classicReport and csvExportEnabled = truetype = tabform and csvExportEnabled = true |
formats | array of enums | Yes | CSV:HTML:XLSX:PDF | data type=string; lov=STATICValid values: csv html excel pdfApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true |
download {
authorization: mustNotBePublicUser
sendAsEmail: false
csvSeparator: value
csvEnclosedBy: value
csvExportEnabled: false
filename: value
supplementalText: ```
value
```
linkText: value
formats: [
csv
html
]
}settings
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
timeAxisType | enum | No | data type=string; lov=STATICValid values: auto disabled enabled mixedFrequency skipGapsApplies when type = chart and type in (area)type = chart and type in (bar)type = chart and type in (line)type = chart and type in (lineWithArea)type = chart and type in (stock)type = chart and type in (boxPlot)type = chart and type in (combination) | |
zoomAndScroll | enum | Yes | false | data type=string; lov=STATICValid values: false delayed delayedScrollOnly live liveScrollOnlyApplies when type = chartSpecify 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 = chart and type in (bubble)type = chart and type in (scatter) |
initialZooming | enum | Yes | none | data type=string; lov=STATICValid values: first last noneApplies when type = chart and type in (bar)type = chart and type in (line)type = chart and type in (area)type = chart and type in (lineWithArea)type = chart and type in (combination)type = chart and type in (stock) |
showHorizontalGrid | enum | Yes | auto | data type=string; lov=STATICValid values: auto true falseApplies when type = chart and type = gantt |
showVerticalGrid | enum | Yes | auto | data type=string; lov=STATICValid values: auto true falseApplies when type = chart and type = gantt |
showRowAxis | boolean | Yes | on | data type=booleanApplies when type = chart and type = gantt |
axisPosition | enum | Yes | top | data type=string; lov=STATICValid values: top bottomApplies when type = chart and type = gantt |
pieSelectionEffect | enum | Yes | highlight | data type=string; lov=STATICValid values: explode highlightAndExplode highlightApplies when type = chart and type in (pie)type = chart and type in (donut) |
renderAs | enum | Yes | candlestick | data type=string; lov=STATICValid values: area bar candlestick line lineWithAreaApplies when type = chart and type = stock |
settings {
timeAxisType: auto
zoomAndScroll: false
zoomDirection: bothAxes
initialZooming: first
showHorizontalGrid: auto
showVerticalGrid: auto
showRowAxis: false
axisPosition: top
pieSelectionEffect: explode
renderAs: area
}iconAndBadge
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
iconSource | enum | No | data type=string; lov=STATICValid values: initials iconClass iconClassColumn imageUrl imageBlobColumnApplies when type = cards | |
iconColumn | string | Yes | data type=string; maxLen=32767Applies when type = cards and iconSource in (initials)type = cards and iconSource in (iconClassColumn) | |
imageColumn | string | Yes | data type=string; maxLen=32767Applies when type = cards and iconSource = imageBlobColumn | |
imageUrl | string | Yes | data type=string; maxLen=4000Applies when type = cards and iconSource = imageUrl | |
iconCssClasses | string | No | data type=string; maxLen=255Applies when type = cards and iconSource is set | |
iconPosition | enum | Yes | start | data type=string; lov=STATICValid values: top start endApplies when type = cards and iconSource is set |
iconDescription | string | No | data type=string; maxLen=255Applies when type = cards and iconSource is set | |
badgeColumn | string | No | data type=string; maxLen=32767Applies when type = cards | |
badgeLabel | string | No | data type=string; maxLen=255Applies when type = cards and badgeColumn is set | |
badgeCssClasses | array of strings | No | data type=string; maxLen=255Applies when type = cards and badgeColumn is set |
iconAndBadge {
iconSource: initials
iconColumn: value
imageColumn: value
imageUrl: value
iconCssClasses: value
iconPosition: top
iconDescription: value
badgeColumn: value
badgeLabel: value
badgeCssClasses: [
value
value
]
}componentAdvanced
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
stripHtml | boolean | Yes | false | data type=booleanApplies when type = classicReporttype = tabform |
sortNulls | enum | Yes | last | data type=string; lov=STATICValid values: first lastApplies when type = classicReporttype = tabform |
customSvgStyles | multiline string | No | data type=multiline string; maxLen=32767Applies when type = map | |
oracleTextIndexColumn | string | No | data type=string; maxLen=32767Applies when type = interactiveReporttype = interactiveGrid | |
emailFromAddress | string | No | data type=string; maxLen=255Applies when type = interactiveReporttype = interactiveGrid | |
initJavaScriptFunction | multiline string | No | data type=multiline string; maxLen=4000Applies when type = charttype = interactiveGridtype = cardstype supports INIT_JAVASCRIPT_CODEEnter 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=255Applies when type = interactiveReport | |
reportIdItem | string | No | data type=string; maxLen=255; textCase=UPPERApplies when type = interactiveReport | |
maxRowsPerPageInSelector | string | No | data type=string; maxLen=4000Applies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and rowsPerPage = truetype = interactiveReport and includeSearchBar = true and rowsPerPageSelector = true |
componentAdvanced {
stripHtml: false
sortNulls: first
customSvgStyles: ```
value
```
oracleTextIndexColumn: value
emailFromAddress: value
initJavaScriptFunction: ```javascript-browser
value
```
regionAlias: value
reportIdItem: value
maxRowsPerPageInSelector: value
}singleRowView
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
excludeNullValues | boolean | Yes | false | data type=booleanApplies when type = interactiveReport and linkColumn = singleRowView |
onlyDisplayedColumns | boolean | Yes | false | data type=booleanApplies when type = interactiveReport and 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 noneApplies when type = classicReporttype = tabformtype supports COLUMN_HEADING |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = classicReport and type = plsqlFunctionBodytype = tabform and type = plsqlFunctionBodytype supports COLUMN_HEADING and type = plsqlFunctionBody | |
fixedTo | enum | Yes | page | data type=string; lov=STATICValid values: none region pageApplies when type = interactiveReporttype = interactiveGrid |
fixedReportHeight | integer | Yes | data type=integer; maxLen=32767Applies when type = interactiveGrid and fixedTo = region | |
maxReportHeight | integer | Yes | data type=integer; maxLen=32767Applies when type = interactiveReport and 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=booleanApplies when type = interactiveReporttype = interactiveGridSpecify 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 type = interactiveReport and show = truetype = interactiveGrid and show = true |
customIcon | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = interactiveGrid and show = true and custom = true | |
iconType | enum | Yes | iconCssClasses | data type=string; lov=STATICValid values: imageInUrl iconCssClassesApplies when type = interactiveGrid and show = true and custom = false |
iconUrl | string | Yes | data type=string; maxLen=32767Applies when type = interactiveGrid and show = true and custom = false and iconType = imageInUrl | |
icon | string | Yes | data type=string; maxLen=32767Applies when type = interactiveGrid and show = true and custom = false and iconType = iconCssClasses | |
iconAttributes | string | No | data type=string; maxLen=255Applies when type = interactiveGrid and show = true and custom = false and iconType = imageInUrl | |
linkTarget | complex | No | data type=complex; maxLen=32767Applies when type = interactiveGrid and show = true | |
linkAttributes | string | No | data type=string; maxLen=255Applies when type = interactiveGrid and show = true and linkTarget is set and custom = false | |
labelColumn | string | Yes | data type=string; maxLen=32767Applies when type = interactiveGrid and 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 type = interactiveReport and show = true |
linkColumn | string | Yes | data type=string; maxLen=32767Applies when type = interactiveReport and show = true and custom = false | |
imageSourceColumn | string | Yes | data type=string; maxLen=32767Applies when type = interactiveReport and show = true and custom = false | |
labelColumn | string | Yes | data type=string; maxLen=32767Applies when type = interactiveReport and show = true and custom = false | |
imageAttributes | string | No | data type=string; maxLen=512Applies when type = interactiveReport and show = true and custom = false | |
htmlAltText | string | No | data type=string; maxLen=512Applies when type = interactiveReport and show = true and custom = false | |
htmlTitleText | string | No | data type=string; maxLen=512Applies when type = interactiveReport and show = true and custom = false | |
customLink | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = interactiveReport and show = true and custom = true |
iconView {
show: false
custom: false
customIcon: ```html
value
```
iconType: imageInUrl
iconUrl: value
icon: value
iconAttributes: value
linkTarget: {
type: in_app
url: value
app: value
page: value
items: [
value
value
]
clearCache: value
action: value
request: value
anchor: value
session: "&SESSION."
debug: "&DEBUG."
printerFriendly: N
otherArgs: value
}
linkAttributes: value
labelColumn: value
columnsPerRow: "1"
linkColumn: value
imageSourceColumn: value
imageAttributes: value
htmlAltText: value
htmlTitleText: value
customLink: ```
value
```
}media
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
advancedFormatting | boolean | Yes | false | data type=booleanApplies when type = cards |
htmlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = cards and advancedFormatting = true | |
source | enum | No | data type=string; lov=STATICValid values: imageUrl urlColumn blobColumnApplies when type = cards and advancedFormatting = false | |
url | string | Yes | data type=string; maxLen=4000Applies when type = cards and advancedFormatting = false and source = imageUrl | |
urlColumn | string | Yes | data type=string; maxLen=32767Applies when type = cards and advancedFormatting = false and source = urlColumn | |
blobColumn | string | Yes | data type=string; maxLen=32767Applies when type = cards and advancedFormatting = false and source = blobColumn | |
position | enum | Yes | body | data type=string; lov=STATICValid values: first body backgroundApplies when type = cards and 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 type = cards and advancedFormatting = false and source is set | |
sizing | enum | Yes | fit | data type=string; lov=STATICValid values: fit coverApplies when type = cards and advancedFormatting = false and source is set |
cssClasses | array of strings | No | data type=string; maxLen=255Applies when type = cards | |
imageDescription | string | No | data type=string; maxLen=255Applies when type = cards and advancedFormatting = false and source is set |
media {
advancedFormatting: false
htmlExpression: ```html
value
```
source: imageUrl
url: value
urlColumn: value
blobColumn: value
position: first
appearance: square
sizing: fit
cssClasses: [
value
value
]
imageDescription: value
}legend
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
show | boolean | Yes | true | data type=booleanApplies when type = map |
title | string | No | data type=string; maxLen=255Applies when type = map and show = truetype = chart and show = onSpecify the title of the legend. | |
position | enum | Yes | end | data type=string; lov=STATICValid values: start end selectorApplies when type = map and show = true |
selector | string | Yes | data type=string; maxLen=32767Applies when type = map and show = true and position = selector | |
cssClasses | array of strings | No | data type=string; maxLen=255Applies when type = map and show = true | |
show | boolean | Yes | on | data type=booleanApplies when type = chart |
position | enum | Yes | auto | data type=string; lov=STATICValid values: auto start end top bottomApplies when type = chart and show = on |
hideAndShowBehavior | enum | Yes | rescale | data type=string; lov=STATICValid values: none rescale noRescalingApplies when type = chart and 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 type = chart and show = on | |
fontStyle | enum | No | data type=string; lov=STATICValid values: normal italic obliqueApplies when type = chart and show = on | |
fontSize | enum | No | data type=string; lov=STATICValid values: 8 10 12 14 16 18 20 22Applies when type = chart and show = on | |
fontColor | string | No | data type=string; maxLen=255Applies when type = chart and show = on |
legend {
show: false
title: value
position: start
selector: value
cssClasses: [
value
value
]
hideAndShowBehavior: none
fontFamily: arial
fontStyle: normal
fontSize: "8"
fontColor: value
}overview
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
show | boolean | Yes | on | data type=booleanApplies when type = chart and type in (area)type = chart and type in (bar)type = chart and type in (line)type = chart and type in (stock)type = chart and type in (boxPlot)type = chart and type in (lineWithArea)type = chart and type in (combination) |
height | string | No | data type=string; maxLen=5Applies when type = chart and type in (area) and show = ontype = chart and type in (bar) and show = ontype = chart and type in (line) and show = ontype = chart and type in (stock) and show = ontype = chart and type in (boxPlot) and show = ontype = chart and type in (lineWithArea) and show = ontype = chart and type in (combination) and show = on |
overview {
show: false
height: value
}printing
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
enabled | boolean | Yes | false | data type=booleanApplies when type = classicReporttype = tabform |
printing {
enabled: false
}externalProcessing
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
enabled | boolean | Yes | false | data type=booleanApplies when type = classicReporttype = tabform |
url | string | Yes | data type=string; maxLen=2000Applies when type = classicReport and enabled = truetype = tabform and enabled = true | |
linkText | string | Yes | data type=string; maxLen=2000Applies when type = classicReport and enabled = truetype = tabform and enabled = true |
externalProcessing {
enabled: false
url: value
linkText: value
}genAI
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
naturalLanguageSupport | boolean | Yes | false | data type=booleanApplies when type = interactiveReport |
defaultSearchMode | enum | Yes | searchModeAI | data type=string; lov=STATICValid values: searchModeRow searchModeAIApplies when type = interactiveReport and naturalLanguageSupport = true |
reportContext | multiline string | No | data type=multiline string; maxLen=32767Applies when type = interactiveReport and naturalLanguageSupport = true | |
enabled | boolean | Yes | false | data type=booleanApplies when type supports AI_ENABLED |
agent | reference | No | data type=reference; lov=COMPONENT; references=aiAgentApplies when type supports AI_ENABLED_ALWAYS and type supports AI_ENABLED and enabled = truetype supports AI_ENABLED and enabled = true | |
service | reference | No | data type=reference; lov=COMPONENT; references=genAIServiceApplies when type supports AI_ENABLED_ALWAYS and type supports AI_ENABLED and enabled = truetype supports AI_ENABLED and enabled = true | |
systemPrompt | multiline string | No | data type=multiline string; maxLen=32767Applies when type supports AI_SYSTEM_PROMPT and type supports AI_ENABLED_ALWAYS and type supports AI_ENABLED and enabled = truetype supports AI_SYSTEM_PROMPT and type supports AI_ENABLED and enabled = true | |
welcomeMessage | multiline string | No | data type=multiline string; maxLen=32767Applies when type supports AI_UI and type supports AI_ENABLED_ALWAYS and type supports AI_ENABLED and enabled = truetype supports AI_UI and type supports AI_ENABLED and enabled = true |
genAI {
naturalLanguageSupport: false
defaultSearchMode: searchModeRow
reportContext: ```
value
```
enabled: false
agent: @component
service: @component
systemPrompt: ```
value
```
welcomeMessage: ```html
value
```
}value
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
pieChartOtherThreshold | number | Yes | 0 | data type=number; maxLen=22Applies when type = chart and type in (pie)type = chart and type in (donut) |
min | integer | No | data type=integer; maxLen=32767Applies when type = chart and type in (pie)type = chart and type in (donut) | |
show | boolean | Yes | true | data type=booleanApplies when type = chart and type = statusMeterGauge |
valueType | enum | Yes | number | data type=string; lov=STATICValid values: number percentApplies when type = chart and type = statusMeterGauge |
position | enum | Yes | auto | data type=string; lov=STATICValid values: auto center insideIndicatorEdge outsideIndicatorEdge outsidePlotArea withLabelApplies when type = chart and 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 = chart and type in (statusMeterGauge)type = chart and type in (funnel)type = chart and type in (pyramid)type = chart and type in (pie)type = chart and type in (donut)Specify the type of formatting to be applied to the value on the chart. The formats Decimal,Percent or Currency only apply to numeric values. The Date,Time and DateTime formats will only apply to values of that data type on the chart. | |
decimalPlaces | integer | No | data type=integer; maxLen=32767Applies when type = chart and type in (statusMeterGauge) and format in (decimal)type = chart and type in (statusMeterGauge) and format in (currency)type = chart and type in (statusMeterGauge) and format in (percent)type = chart and type in (statusMeterGauge) and type in (funnel) and format in (decimal)type = chart and type in (statusMeterGauge) and type in (funnel) and format in (currency)type = chart and type in (statusMeterGauge) and type in (funnel) and format in (percent)type = chart and type in (statusMeterGauge) and type in (pyramid) and format in (decimal)type = chart and type in (statusMeterGauge) and type in (pyramid) and format in (currency)type = chart and type in (statusMeterGauge) and type in (pyramid) and format in (percent)type = chart and type in (statusMeterGauge) and type in (pie) and format in (decimal)type = chart and type in (statusMeterGauge) and type in (pie) and format in (currency)type = chart and type in (statusMeterGauge) and type in (pie) and format in (percent)type = chart and type in (statusMeterGauge) and type in (donut) and format in (decimal)type = chart and type in (statusMeterGauge) and type in (donut) and format in (currency)type = chart and type in (statusMeterGauge) and type in (donut) and format in (percent)type = chart and type in (funnel) and type in (statusMeterGauge) and format in (decimal)type = chart and type in (funnel) and type in (statusMeterGauge) and format in (currency)type = chart and type in (funnel) and type in (statusMeterGauge) and format in (percent)type = chart and type in (funnel) and format in (decimal)type = chart and type in (funnel) and format in (currency)type = chart and type in (funnel) and format in (percent)type = chart and type in (funnel) and type in (pyramid) and format in (decimal)type = chart and type in (funnel) and type in (pyramid) and format in (currency)type = chart and type in (funnel) and type in (pyramid) and format in (percent)type = chart and type in (funnel) and type in (pie) and format in (decimal)type = chart and type in (funnel) and type in (pie) and format in (currency)type = chart and type in (funnel) and type in (pie) and format in (percent)type = chart and type in (funnel) and type in (donut) and format in (decimal)type = chart and type in (funnel) and type in (donut) and format in (currency)type = chart and type in (funnel) and type in (donut) and format in (percent)type = chart and type in (pyramid) and type in (statusMeterGauge) and format in (decimal)type = chart and type in (pyramid) and type in (statusMeterGauge) and format in (currency)type = chart and type in (pyramid) and type in (statusMeterGauge) and format in (percent)type = chart and type in (pyramid) and type in (funnel) and format in (decimal)type = chart and type in (pyramid) and type in (funnel) and format in (currency)type = chart and type in (pyramid) and type in (funnel) and format in (percent)type = chart and type in (pyramid) and format in (decimal)type = chart and type in (pyramid) and format in (currency)type = chart and type in (pyramid) and format in (percent)type = chart and type in (pyramid) and type in (pie) and format in (decimal)type = chart and type in (pyramid) and type in (pie) and format in (currency)type = chart and type in (pyramid) and type in (pie) and format in (percent)type = chart and type in (pyramid) and type in (donut) and format in (decimal)type = chart and type in (pyramid) and type in (donut) and format in (currency)type = chart and type in (pyramid) and type in (donut) and format in (percent)type = chart and type in (pie) and type in (statusMeterGauge) and format in (decimal)type = chart and type in (pie) and type in (statusMeterGauge) and format in (currency)type = chart and type in (pie) and type in (statusMeterGauge) and format in (percent)type = chart and type in (pie) and type in (funnel) and format in (decimal)type = chart and type in (pie) and type in (funnel) and format in (currency)type = chart and type in (pie) and type in (funnel) and format in (percent)type = chart and type in (pie) and type in (pyramid) and format in (decimal)type = chart and type in (pie) and type in (pyramid) and format in (currency)type = chart and type in (pie) and type in (pyramid) and format in (percent)type = chart and type in (pie) and format in (decimal)type = chart and type in (pie) and format in (currency)type = chart and type in (pie) and format in (percent)type = chart and type in (pie) and type in (donut) and format in (decimal)type = chart and type in (pie) and type in (donut) and format in (currency)type = chart and type in (pie) and type in (donut) and format in (percent)type = chart and type in (donut) and type in (statusMeterGauge) and format in (decimal)type = chart and type in (donut) and type in (statusMeterGauge) and format in (currency)type = chart and type in (donut) and type in (statusMeterGauge) and format in (percent)type = chart and type in (donut) and type in (funnel) and format in (decimal)type = chart and type in (donut) and type in (funnel) and format in (currency)type = chart and type in (donut) and type in (funnel) and format in (percent)type = chart and type in (donut) and type in (pyramid) and format in (decimal)type = chart and type in (donut) and type in (pyramid) and format in (currency)type = chart and type in (donut) and type in (pyramid) and format in (percent)type = chart and type in (donut) and type in (pie) and format in (decimal)type = chart and type in (donut) and type in (pie) and format in (currency)type = chart and type in (donut) and type in (pie) and format in (percent)type = chart and type in (donut) and format in (decimal)type = chart and type in (donut) and format in (currency)type = chart and type in (donut) and format in (percent)Specify the number of decimal places to be applied to the numeric value on the chart. | |
currency | string | No | data type=string; maxLen=128Applies when type = chart and type in (statusMeterGauge) and format = currencytype = chart and type in (statusMeterGauge) and type in (funnel) and format = currencytype = chart and type in (statusMeterGauge) and type in (pyramid) and format = currencytype = chart and type in (statusMeterGauge) and type in (pie) and format = currencytype = chart and type in (statusMeterGauge) and type in (donut) and format = currencytype = chart and type in (funnel) and type in (statusMeterGauge) and format = currencytype = chart and type in (funnel) and format = currencytype = chart and type in (funnel) and type in (pyramid) and format = currencytype = chart and type in (funnel) and type in (pie) and format = currencytype = chart and type in (funnel) and type in (donut) and format = currencytype = chart and type in (pyramid) and type in (statusMeterGauge) and format = currencytype = chart and type in (pyramid) and type in (funnel) and format = currencytype = chart and type in (pyramid) and format = currencytype = chart and type in (pyramid) and type in (pie) and format = currencytype = chart and type in (pyramid) and type in (donut) and format = currencytype = chart and type in (pie) and type in (statusMeterGauge) and format = currencytype = chart and type in (pie) and type in (funnel) and format = currencytype = chart and type in (pie) and type in (pyramid) and format = currencytype = chart and type in (pie) and format = currencytype = chart and type in (pie) and type in (donut) and format = currencytype = chart and type in (donut) and type in (statusMeterGauge) and format = currencytype = chart and type in (donut) and type in (funnel) and format = currencytype = chart and type in (donut) and type in (pyramid) and format = currencytype = chart and type in (donut) and type in (pie) and format = currencytype = chart and type in (donut) and format = currency | |
pattern | string | No | data type=string; maxLen=30Applies when type = chart and type in (statusMeterGauge) and format in (decimal)type = chart and type in (statusMeterGauge) and format in (currency)type = chart and type in (statusMeterGauge) and format in (percent)type = chart and type in (statusMeterGauge) and type in (funnel) and format in (decimal)type = chart and type in (statusMeterGauge) and type in (funnel) and format in (currency)type = chart and type in (statusMeterGauge) and type in (funnel) and format in (percent)type = chart and type in (statusMeterGauge) and type in (pyramid) and format in (decimal)type = chart and type in (statusMeterGauge) and type in (pyramid) and format in (currency)type = chart and type in (statusMeterGauge) and type in (pyramid) and format in (percent)type = chart and type in (statusMeterGauge) and type in (pie) and format in (decimal)type = chart and type in (statusMeterGauge) and type in (pie) and format in (currency)type = chart and type in (statusMeterGauge) and type in (pie) and format in (percent)type = chart and type in (statusMeterGauge) and type in (donut) and format in (decimal)type = chart and type in (statusMeterGauge) and type in (donut) and format in (currency)type = chart and type in (statusMeterGauge) and type in (donut) and format in (percent)type = chart and type in (funnel) and type in (statusMeterGauge) and format in (decimal)type = chart and type in (funnel) and type in (statusMeterGauge) and format in (currency)type = chart and type in (funnel) and type in (statusMeterGauge) and format in (percent)type = chart and type in (funnel) and format in (decimal)type = chart and type in (funnel) and format in (currency)type = chart and type in (funnel) and format in (percent)type = chart and type in (funnel) and type in (pyramid) and format in (decimal)type = chart and type in (funnel) and type in (pyramid) and format in (currency)type = chart and type in (funnel) and type in (pyramid) and format in (percent)type = chart and type in (funnel) and type in (pie) and format in (decimal)type = chart and type in (funnel) and type in (pie) and format in (currency)type = chart and type in (funnel) and type in (pie) and format in (percent)type = chart and type in (funnel) and type in (donut) and format in (decimal)type = chart and type in (funnel) and type in (donut) and format in (currency)type = chart and type in (funnel) and type in (donut) and format in (percent)type = chart and type in (pyramid) and type in (statusMeterGauge) and format in (decimal)type = chart and type in (pyramid) and type in (statusMeterGauge) and format in (currency)type = chart and type in (pyramid) and type in (statusMeterGauge) and format in (percent)type = chart and type in (pyramid) and type in (funnel) and format in (decimal)type = chart and type in (pyramid) and type in (funnel) and format in (currency)type = chart and type in (pyramid) and type in (funnel) and format in (percent)type = chart and type in (pyramid) and format in (decimal)type = chart and type in (pyramid) and format in (currency)type = chart and type in (pyramid) and format in (percent)type = chart and type in (pyramid) and type in (pie) and format in (decimal)type = chart and type in (pyramid) and type in (pie) and format in (currency)type = chart and type in (pyramid) and type in (pie) and format in (percent)type = chart and type in (pyramid) and type in (donut) and format in (decimal)type = chart and type in (pyramid) and type in (donut) and format in (currency)type = chart and type in (pyramid) and type in (donut) and format in (percent)type = chart and type in (pie) and type in (statusMeterGauge) and format in (decimal)type = chart and type in (pie) and type in (statusMeterGauge) and format in (currency)type = chart and type in (pie) and type in (statusMeterGauge) and format in (percent)type = chart and type in (pie) and type in (funnel) and format in (decimal)type = chart and type in (pie) and type in (funnel) and format in (currency)type = chart and type in (pie) and type in (funnel) and format in (percent)type = chart and type in (pie) and type in (pyramid) and format in (decimal)type = chart and type in (pie) and type in (pyramid) and format in (currency)type = chart and type in (pie) and type in (pyramid) and format in (percent)type = chart and type in (pie) and format in (decimal)type = chart and type in (pie) and format in (currency)type = chart and type in (pie) and format in (percent)type = chart and type in (pie) and type in (donut) and format in (decimal)type = chart and type in (pie) and type in (donut) and format in (currency)type = chart and type in (pie) and type in (donut) and format in (percent)type = chart and type in (donut) and type in (statusMeterGauge) and format in (decimal)type = chart and type in (donut) and type in (statusMeterGauge) and format in (currency)type = chart and type in (donut) and type in (statusMeterGauge) and format in (percent)type = chart and type in (donut) and type in (funnel) and format in (decimal)type = chart and type in (donut) and type in (funnel) and format in (currency)type = chart and type in (donut) and type in (funnel) and format in (percent)type = chart and type in (donut) and type in (pyramid) and format in (decimal)type = chart and type in (donut) and type in (pyramid) and format in (currency)type = chart and type in (donut) and type in (pyramid) and format in (percent)type = chart and type in (donut) and type in (pie) and format in (decimal)type = chart and type in (donut) and type in (pie) and format in (currency)type = chart and type in (donut) and type in (pie) and format in (percent)type = chart and type in (donut) and format in (decimal)type = chart and type in (donut) and format in (currency)type = chart and type in (donut) and format in (percent)Specify the numeric pattern to be applied to the numeric value on the chart. | |
formatScaling | enum | Yes | auto | data type=string; lov=STATICValid values: none auto thousand million billion trillion quadrillionApplies when type = chart and type in (statusMeterGauge)type = chart and type in (funnel)type = chart and type in (pyramid)type = chart and type in (pie)type = chart and type in (donut) |
value {
pieChartOtherThreshold: 42
min: 42
show: false
valueType: number
position: auto
format: dateShort
decimalPlaces: 42
currency: value
pattern: value
formatScaling: none
}attributes
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
messagesPosition | enum | No | data type=string; lov=STATICValid values: above below selectorApplies when type = map | |
messageSelector | string | Yes | data type=string; maxLen=32767Applies when type = map and messagesPosition = selector | |
unitSystem | enum | Yes | metric | data type=string; lov=STATICValid values: metric imperial deriveFromItemApplies when type = map |
unitSystemItem | string | Yes | data type=string; maxLen=32767; textCase=UPPERApplies when type = map and unitSystem = deriveFromItem | |
copyrightNotice | multiline string | No | data type=multiline string; maxLen=32767Applies when type = map |
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=booleanApplies when type = interactiveReport |
searchField | boolean | Yes | true | data type=booleanApplies when type = interactiveReport and includeSearchBar = true |
finderDropDown | boolean | Yes | true | data type=booleanApplies when type = interactiveReport and includeSearchBar = true and searchField = true |
reportsSelectList | boolean | Yes | TABS | data type=booleanApplies when type = interactiveReport and includeSearchBar = true |
rowsPerPageSelector | boolean | Yes | false | data type=booleanApplies when type = interactiveReport and includeSearchBar = true |
searchButtonLabel | string | No | data type=string; maxLen=4000Applies when type = interactiveReport and 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 type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) | |
orderByClause | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue | |
item | complex | Yes | data type=complex; maxLen=32767Applies when type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and type in ($NULL$)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (tableView)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (sqlQuery)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and type in (functionBody)type supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item | |
orderByClause | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = staticValue and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = staticValue and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = staticValue and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = staticValue and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = staticValue and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = staticValue and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = staticValue and type = propertyGraph | |
item | complex | Yes | data type=complex; maxLen=32767Applies when type supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (tableView) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in (functionBody) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (localDatabase) and location in (restEnabledSql) and type in ($NULL$) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (tableView) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (propertyGraph) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (sqlQuery) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in (functionBody) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and location in (localDatabase) and type in ($NULL$) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (tableView) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (propertyGraph) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (sqlQuery) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in (functionBody) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (restEnabledSql) and type in ($NULL$) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (tableView) and type = item and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (propertyGraph) and type = item and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (sqlQuery) and type = item and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in (functionBody) and type = item and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (localDatabase) and type in ($NULL$) and type = item and location in (restEnabledSql) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (tableView) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (propertyGraph) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (sqlQuery) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in (functionBody) and type = item and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and location in (localDatabase) and type = propertyGraphtype supports ORDER_BY and type supports SOURCE_LOCATION and location in (sampleData) and location in (restEnabledSql) and type in ($NULL$) and type = item and type = propertyGraph |
orderBy {
type: staticValue
orderByClause: ```sql
value
```
item: {
itemName: value
orderBys: [
value
value
]
}
}blobAttributes
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
mimeTypeColumn | string | No | data type=string; maxLen=32767Applies when type = cards and iconSource = imageBlobColumntype = cards and advancedFormatting = false and source = blobColumn | |
lastUpdatedColumn | string | No | data type=string; maxLen=32767Applies when type = cards and iconSource = imageBlobColumntype = cards and advancedFormatting = false and source = blobColumn |
blobAttributes {
mimeTypeColumn: value
lastUpdatedColumn: value
}detailView
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
show | boolean | Yes | false | data type=booleanApplies when type = interactiveReporttype = interactiveGridSpecify 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 type = interactiveReport and show = truetype = interactiveGrid and show = true | |
forEachRow | multiline string | Depends | data type=multiline string; maxLen=4000Applies when type = interactiveReport and show = truetype = interactiveGrid and 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 type = interactiveReport and show = truetype = interactiveGrid and 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 type = interactiveReport and includeSearchBar = true |
filter | boolean | Yes | true | data type=booleanApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true |
selectColumns | boolean | Yes | true | data type=booleanApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true |
rowsPerPage | boolean | Yes | true | data type=booleanApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true |
sort | boolean | Yes | true | data type=booleanApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true |
controlBreak | boolean | Yes | true | data type=booleanApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true |
highlight | boolean | Yes | true | data type=booleanApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true |
compute | boolean | Yes | true | data type=booleanApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true |
aggregate | boolean | Yes | true | data type=booleanApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true |
chart | boolean | Yes | true | data type=booleanApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true |
groupBy | boolean | Yes | true | data type=booleanApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true |
pivot | boolean | Yes | true | data type=booleanApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true |
flashback | boolean | Yes | true | data type=booleanApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true |
saveReport | boolean | Yes | true | data type=booleanApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true |
savePublicReport | boolean | Yes | false | data type=booleanApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and saveReport = true |
savePublicReportAuthorization | enum | No | data type=reference; lov=COMPONENT; references=authorizationValid values: mustNotBePublicUserApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and saveReport = true and savePublicReport = true | |
reset | boolean | Yes | true | data type=booleanApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true |
help | boolean | Yes | true | data type=booleanApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true |
download | boolean | Yes | true | data type=booleanApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true |
subscription | boolean | Yes | true | data type=booleanApplies when type = interactiveReport and includeSearchBar = true and includeActionsMenu = true and download = true |
actionsMenu {
includeActionsMenu: false
filter: false
selectColumns: false
rowsPerPage: false
sort: false
controlBreak: false
highlight: false
compute: false
aggregate: false
chart: false
groupBy: false
pivot: false
flashback: false
saveReport: false
savePublicReport: false
savePublicReportAuthorization: mustNotBePublicUser
reset: false
help: false
download: false
subscription: false
}dataProfile
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
nestedRows | reference | No | data type=reference; lov=COMPONENT; references=dataProfileColumnApplies when type supports SOURCE_LOCATION and location = restSource and restSource supports HAS_ARRAY_COLUMNS | |
nestedRows | reference | No | data type=reference; lov=COMPONENT; references=dataProfileColumnApplies when type supports SOURCE_LOCATION and location = jsonDualityView and jsonDualityView supports HAS_ARRAY_COLUMNS | |
nestedRows | reference | No | data type=reference; lov=COMPONENT; references=dataProfileColumnApplies when type supports SOURCE_LOCATION and 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 type = chart and lazyLoading = false |
onDataChange | enum | Yes | auto | data type=string; lov=STATICValid values: auto slideToLeft slideToRight noneApplies when type = chart |
animation {
onDisplay: auto
onDataChange: auto
}restSynchronization
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
useLocalTable | boolean | Yes | false | data type=booleanApplies when type supports SOURCE_LOCATION and location = restSource and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNStype supports SOURCE_LOCATION and location = restSource and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNStype supports SOURCE_LOCATION and location = restSource and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED |
restSynchronization {
useLocalTable: false
}tooltip
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
show | boolean | Yes | true | data type=booleanApplies when type = chart |
showSeriesName | boolean | Yes | true | data type=booleanApplies when type = chart and show = true |
showGroupName | boolean | Yes | true | data type=booleanApplies when type = chart and show = true |
showValue | boolean | Yes | true | data type=booleanApplies when type = chart and show = true |
showRow | boolean | Yes | true | data type=booleanApplies when type = chart and show = true and type = gantt |
showLabel | boolean | Yes | true | data type=booleanApplies when type = chart and show = true and type = gantt |
showStartDate | boolean | Yes | true | data type=booleanApplies when type = chart and show = true and type = gantt |
showEndDate | boolean | Yes | true | data type=booleanApplies when type = chart and show = true and type = gantt |
showProgress | boolean | Yes | true | data type=booleanApplies when type = chart and show = true and type = gantt |
showBaseline | boolean | Yes | true | data type=booleanApplies when type = chart and show = true and type = gantt |
tooltip {
show: false
showSeriesName: false
showGroupName: false
showValue: false
showRow: false
showLabel: false
showStartDate: false
showEndDate: false
showProgress: false
showBaseline: false
}externalFilterAndOrderBy
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
enabled | boolean | Yes | false | data type=booleanApplies when type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in (false)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in ($NULL$)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in ($NULL$) |
filter | multiline string | No | data type=multiline string; maxLen=4000Applies when type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false) and enabled = truetype supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = truetype supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in (false) and enabled = truetype supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = truetype supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false) and enabled = truetype supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in ($NULL$) and enabled = true | |
orderByType | enum | No | data type=string; lov=STATICValid values: staticValue itemApplies when type supports ORDER_BY and type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false) and enabled = truetype supports ORDER_BY and type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = truetype supports ORDER_BY and type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in (false) and enabled = truetype supports ORDER_BY and type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = truetype supports ORDER_BY and type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false) and enabled = truetype supports ORDER_BY and type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in ($NULL$) and enabled = true | |
orderBy | multiline string | No | data type=multiline string; maxLen=255Applies when type supports ORDER_BY and type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false) and enabled = true and orderByType = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = true and orderByType = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in (false) and enabled = true and orderByType = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = true and orderByType = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false) and enabled = true and orderByType = staticValuetype supports ORDER_BY and type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in ($NULL$) and enabled = true and orderByType = staticValuetype supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false) and enabled = true and type in (interactiveGrid)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false) and enabled = true and type in (interactiveReport)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false) and enabled = true and type in (map)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false) and enabled = true and type in (form)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = true and type in (interactiveGrid)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = true and type in (interactiveReport)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = true and type in (map)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = true and type in (form)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in (false) and enabled = true and type in (interactiveGrid)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in (false) and enabled = true and type in (interactiveReport)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in (false) and enabled = true and type in (map)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in (false) and enabled = true and type in (form)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = true and type in (interactiveGrid)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = true and type in (interactiveReport)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = true and type in (map)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = true and type in (form)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false) and enabled = true and type in (interactiveGrid)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false) and enabled = true and type in (interactiveReport)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false) and enabled = true and type in (map)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false) and enabled = true and type in (form)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in ($NULL$) and enabled = true and type in (interactiveGrid)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in ($NULL$) and enabled = true and type in (interactiveReport)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in ($NULL$) and enabled = true and type in (map)type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in ($NULL$) and enabled = true and type in (form) | |
item | complex | Yes | data type=complex; maxLen=4000Applies when type supports ORDER_BY and type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in (false) and enabled = true and orderByType = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = true and orderByType = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in (false) and enabled = true and orderByType = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable in ($NULL$) and enabled = true and orderByType = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in (false) and enabled = true and orderByType = itemtype supports ORDER_BY and type supports SOURCE_LOCATION and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable in ($NULL$) and enabled = true and orderByType = item |
externalFilterAndOrderBy {
enabled: false
filter: ```
value
```
orderByType: staticValue
orderBy: ```
value
```
item: {
itemName: value
orderBys: [
value
value
]
}
}advanced
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
savedReportMappingIdentifier | string | No | data type=string; maxLen=32767Applies when type = interactiveReporttype = interactiveGrid | |
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=2000Applies when type supports REGION_TEMPLATEEnter 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 type supports REGION_TEMPLATE and template supports NOT_REGION_IMAGE_URL | |
imageTagAttributes | string | No | data type=string; maxLen=255Applies when type supports REGION_TEMPLATE and 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 type supports REGION_TEMPLATE and template is set |
excludeTitleFromTranslation | boolean | Yes | false | data type=boolean |
schemaOverrideItem | string | No | data type=string; maxLen=4000; textCase=UPPERApplies when type in (classicReport)type in (interactiveReport) |
advanced {
savedReportMappingIdentifier: value
htmlDomId: value
customAttributes: value
regionImage: value
imageTagAttributes: value
staticId: value
regionDisplaySelector: false
excludeTitleFromTranslation: false
schemaOverrideItem: value
}help
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
helpText | multiline string | No | data type=multiline string; maxLen=4000Applies when type = interactiveGridUse 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 type supports SOURCE_LOCATION and location = restSource and restSource is set | |
whereClause | multiline string | No | data type=multiline string; maxLen=4000Applies when type supports SOURCE_LOCATION and location = restSource and restSource is set and type = whereOrderByClause | |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=32767Applies when type supports SOURCE_LOCATION and location = restSource and restSource is set and type = sqlQuery | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when type supports SOURCE_LOCATION and location = restSource and restSource is set and type = plsqlFunctionBody |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=32767Applies when type supports SOURCE_LOCATION and location = restSource and restSource is set and type = plsqlFunctionBody and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=32767Applies when type supports SOURCE_LOCATION and 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 type supports SOURCE_LOCATION and location = restSource and restSource is set and type = whereOrderByClause | |
orderByClause | multiline string | Yes | data type=multiline string; maxLen=255Applies when type supports SOURCE_LOCATION and location = restSource and restSource is set and type = whereOrderByClause and orderByType = staticValue | |
item | complex | Yes | data type=complex; maxLen=32767Applies when type supports SOURCE_LOCATION and location = restSource and restSource is set and type = whereOrderByClause and orderByType = item | |
orderByItem | complex | No | data type=complex; maxLen=32767Applies when type supports SOURCE_LOCATION and location = restSource and restSource is set and type in (sqlQuery)type supports SOURCE_LOCATION and location = restSource and restSource is set and type in (plsqlFunctionBody) | |
type | enum | No | data type=string; lov=STATICValid values: whereOrderByClause sqlQuery plsqlFunctionBodyApplies when type supports SOURCE_LOCATION and location = jsonDualityView and jsonDualityView is set | |
whereClause | multiline string | No | data type=multiline string; maxLen=4000Applies when type supports SOURCE_LOCATION and location = jsonDualityView and jsonDualityView is set and type = whereOrderByClause | |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=32767Applies when type supports SOURCE_LOCATION and location = jsonDualityView and jsonDualityView is set and type = sqlQuery | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when type supports SOURCE_LOCATION and location = jsonDualityView and jsonDualityView is set and type = plsqlFunctionBody |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=32767Applies when type supports SOURCE_LOCATION and location = jsonDualityView and jsonDualityView is set and type = plsqlFunctionBody and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=32767Applies when type supports SOURCE_LOCATION and 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 type supports SOURCE_LOCATION and location = jsonDualityView and jsonDualityView is set and type = whereOrderByClause | |
orderByClause | multiline string | Yes | data type=multiline string; maxLen=255Applies when type supports SOURCE_LOCATION and location = jsonDualityView and jsonDualityView is set and type = whereOrderByClause and orderByType = staticValue | |
item | complex | Yes | data type=complex; maxLen=32767Applies when type supports SOURCE_LOCATION and location = jsonDualityView and jsonDualityView is set and type = whereOrderByClause and orderByType = item | |
orderByItem | complex | No | data type=complex; maxLen=32767Applies when type supports SOURCE_LOCATION and location = jsonDualityView and jsonDualityView is set and type in (sqlQuery)type supports SOURCE_LOCATION and location = jsonDualityView and jsonDualityView is set and type in (plsqlFunctionBody) | |
type | enum | No | data type=string; lov=STATICValid values: whereOrderByClause sqlQuery plsqlFunctionBodyApplies when type supports SOURCE_LOCATION and location = jsonSource and jsonSource is set | |
whereClause | multiline string | No | data type=multiline string; maxLen=4000Applies when type supports SOURCE_LOCATION and location = jsonSource and jsonSource is set and type = whereOrderByClause | |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=32767Applies when type supports SOURCE_LOCATION and location = jsonSource and jsonSource is set and type = sqlQuery | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when type supports SOURCE_LOCATION and location = jsonSource and jsonSource is set and type = plsqlFunctionBody |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=32767Applies when type supports SOURCE_LOCATION and location = jsonSource and jsonSource is set and type = plsqlFunctionBody and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=32767Applies when type supports SOURCE_LOCATION and 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 type supports SOURCE_LOCATION and location = jsonSource and jsonSource is set and type = whereOrderByClause | |
orderByClause | multiline string | Yes | data type=multiline string; maxLen=255Applies when type supports SOURCE_LOCATION and location = jsonSource and jsonSource is set and type = whereOrderByClause and orderByType = staticValue | |
item | complex | Yes | data type=complex; maxLen=32767Applies when type supports SOURCE_LOCATION and location = jsonSource and jsonSource is set and type = whereOrderByClause and orderByType = item | |
orderByItem | complex | No | data type=complex; maxLen=32767Applies when type supports SOURCE_LOCATION and location = jsonSource and jsonSource is set and type in (sqlQuery)type supports SOURCE_LOCATION and location = jsonSource and jsonSource is set and type in (plsqlFunctionBody) |
localPostProcessing {
type: whereOrderByClause
whereClause: ```sql
value
```
sqlQuery: ```sql
value
```
language: plsql
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
orderByType: staticValue
orderByClause: ```sql
value
```
item: {
itemName: value
orderBys: [
value
value
]
}
orderByItem: {
itemName: value
orderBys: [
value
value
]
}
}autoRefresh
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
interval | integer | No | data type=integer; maxLen=32767Applies when type = chart |
autoRefresh {
interval: 42
}remoteCache
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
caching | enum | No | data type=string; lov=STATICValid values: allUsers user sessionApplies when type supports SOURCE_LOCATION and location = restEnabledSql | |
timeout | multiline string | Yes | data type=multiline string; maxLen=255Applies when type supports SOURCE_LOCATION and 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=4000Applies when type = interactiveReportEnter 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=regionTemplateApplies when type supports REGION_TEMPLATE | |
templateOptions | array of strings | No | data type=string; lov=TEMPLATE_OPTIONSApplies when type supports REGION_TEMPLATE and template is set | |
cssClasses | array of strings | No | data type=string; maxLen=255Applies when type supports REGION_TEMPLATE and 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 type supports REGION_TEMPLATE and template is set | |
renderComponents | enum | Yes | aboveContent | data type=string; lov=STATICValid values: aboveContent belowContentApplies when type supports REGION_TEMPLATE |
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 type supports REGION_TEMPLATE and template supports REGION_LANDMARK_ATTRIBUTES |
landmarkType | enum | No | data type=string; lov=STATICValid values: banner complementary contentInfo form main navigation region searchApplies when type supports REGION_TEMPLATE and template supports REGION_LANDMARK_ATTRIBUTES and useLandmark = true | |
landmarkLabel | string | No | data type=string; maxLen=255Applies when type supports REGION_TEMPLATE and 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 type supports REGION_TEMPLATE and template supports REGION_IMAGEtype supports REGION_TEMPLATE and template supports REGION_IMAGE_URL | |
accessibleDescription | string | No | data type=string; maxLen=255Applies when type supports REGION_TEMPLATE and template supports REGION_IMAGE_ALT_TEXT and template supports REGION_IMAGE and fileUrl is settype supports REGION_TEMPLATE and template supports REGION_IMAGE_ALT_TEXT and template supports REGION_IMAGE_URL and fileUrl is set | |
customAttributes | string | No | data type=string; maxLen=255Applies when type supports REGION_TEMPLATE and template supports REGION_IMAGE_ATTRIBUTES and template supports REGION_IMAGE and fileUrl is settype supports REGION_TEMPLATE and template supports REGION_IMAGE_ATTRIBUTES and template supports REGION_IMAGE_URL and fileUrl is set |
image {
fileUrl: value
accessibleDescription: value
customAttributes: value
}masterDetail
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
masterRegion | reference | No | data type=reference; lov=COMPONENT; references=regionApplies when type = interactiveGrid |
masterDetail {
masterRegion: @component
}headerAndFooter
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
headerText | multiline string | No | data type=multiline string; maxLen=4000Applies when type supports REGION_TEMPLATEEnter HTML text displayed at the top of the region, before the #BODY# content. | |
footerText | multiline string | No | data type=multiline string; maxLen=4000Applies when type supports REGION_TEMPLATEEnter 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=booleanApplies when type supports ESCAPE_OUTPUT |
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 type supports ROW_SELECTION and display = report | |
currentSelectionPageItem | string | No | data type=string; maxLen=255; textCase=UPPERApplies when type supports ROW_SELECTION and display = report and type in (singleSelection)type supports ROW_SELECTION and display = report and type in (multipleSelection) | |
selectAllPageItem | string | No | data type=string; maxLen=255; textCase=UPPERApplies when type supports ROW_SELECTION and 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: breadcrumb
chart {
type: area
}
componentAppearance {
display: report
layout: grid
gridColumns: "2"
listTemplate: @component
breadcrumbTemplate: @component
cssClasses: [
value
value
]
templateOptions: [
value
value
]
templateType: theme
template: @component
customAttributes: value
showNullValuesAs: value
selectFirstRow: false
fixedRowHeight: false
}
edit {
enabled: false
allowedOperations: [
add
update
]
allowedRowOperationsColumn: value
lostUpdateType: rowValues
rowVersionColumn: value
addRowIfEmpty: false
}
link {
linkColumn: singleRowView
uniquelyIdentifyRowsBy: rowid
uniqueColumn: value
target: {
type: in_app
url: value
app: value
page: value
items: [
value
value
]
clearCache: value
action: value
request: value
anchor: value
session: "&SESSION."
debug: "&DEBUG."
printerFriendly: N
otherArgs: value
}
linkIcon: ```
value
```
linkAttributes: value
authorizationScheme: mustNotBePublicUser
conditionType: always
sqlQuery: ```sql
value
```
language: sql
sqlExpression: ```sql
value
```
plsqlExpression: ```plsql
value
```
javaScriptExpression: ```javascript-mle
value
```
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
value: value
item: value
preference: value
page: 42
pages: [
42
42
]
text: value
list: [
value
value
]
}
map {
background: default
standard: openstreetmapPositron
darkMode: openstreetmapDark
height: 42
}
output {
layout: @component
linkText: value
format: pdf
viewFileAs: attachment
formatItem: value
fileName: value
}
page {
size: letter
orientation: portrait
units: inches
width: 42
height: 42
borderWidth: 42
borderColor: value
}
reportLayout {
numberOfRowsType: staticValue
numberOfRows: 42
item: value
}
title {
title: value
advancedFormatting: false
column: value
htmlExpression: ```html
value
```
cssClasses: [
value
value
]
}
chartAppearance {
orientation: vertical
stack: false
stackLabel: false
fontFamily: arial
fontStyle: normal
fontSize: "8"
fontColor: value
}
card {
cssClasses: [
value
value
]
primaryKeyColumn1: value
primaryKeyColumn2: value
}
source {
plsqlCode: ```plsql
value
```
htmlCode: ```html
value
```
text: ```
value
```
language: plsql
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
location: localDatabase
remoteServer: @component
sampleData: employees
type: tableView
tableOwner: value
tableName: value
includeRowidColumn: false
whereClause: ```sql
value
```
graphOwner: value
graphName: value
matchClause: ```
value
```
columnsClause: ```
value
```
orderByClause: ```sql
value
```
sqlQuery: ```sql
value
```
restSource: @component
jsonDualityView: @component
jsonSource: @component
list: @component
breadcrumb: @component
filteredRegion: @component
pageItemsToSubmit: [
value
value
]
optimizerHint: value
useGenericColumnNames: false
genericColumnCount: 42
}
controls {
navigationBar: none
navigationBarPosition: start
options: [
mousewheelZoom
rectangleZoom
]
}
editAuthorization {
add: mustNotBePublicUser
update: mustNotBePublicUser
delete: mustNotBePublicUser
}
pageHeader {
font: helvetica
fontWeight: normal
fontSize: 42
fontColor: value
alignment: start
pageHeaderText: ```
value
```
}
chartLayout {
maxWidth: 42
height: 42
}
initialPositionAndZoom {
getPositionFromBrowser: false
type: staticValues
sqlQuery: ```sql
value
```
geometryColumnDataType: sdoGeometry
initialLongitudeColumn: value
initialLatitudeColumn: value
geometryColumn: value
geojsonColumn: value
initialZoomlevelColumn: value
longitude: value
latitude: value
zoomLevel: value
}
performance {
lazyLoading: false
maxRowsToProcess: 42
}
pagination {
type: showAll
displayPosition: bottomLeft
partialPageRefresh: false
showTotalCount: false
maxRowsToDisplay: value
cardsPerPage: 42
entitiesPerPage: 42
initialEntitiesCount: 42
}
gauge {
orientation: circular
showPlotArea: false
indicatorSize: 42
innerRadius: 42
startAngle: 42
angleExtent: 42
}
columnHeadings {
font: helvetica
fontWeight: normal
fontSize: 42
fontColor: value
backgroundColor: value
}
subtitle {
advancedFormatting: false
column: value
htmlExpression: ```html
value
```
cssClasses: [
value
value
]
}
messages {
whenNoDataFound: ```
value
```
whenMoreDataFound: ```
value
```
noDataFoundIcon: value
}
toolbar {
show: false
controls: [
searchCol
searchField
]
addButtonLabel: value
}
body {
advancedFormatting: false
column: value
htmlExpression: ```html
value
```
cssClasses: [
value
value
]
}
breakFormatting {
reportSumLabel: value
breakColumns: col1
style: repeatHeadings
repeatHeadingFormat: ```
value
```
reportBreakFormat: value
beforeRow: value
columnBreakFormat: value
afterRow: value
}
columns {
font: helvetica
fontWeight: normal
fontSize: 42
fontColor: value
backgroundColor: value
widthUnits: percent
}
dataCursor {
cursor: auto
behavior: auto
dimOnHover: false
}
enableUsersTo {
savePublicReport: false
savePublicReportAuthorization: mustNotBePublicUser
flashback: false
defineChartView: false
download: false
}
boundingBox {
type: staticValues
sqlQuery: ```sql
value
```
geometryColumnDataType: sdoGeometry
minLongitude: value
minLatitude: value
maxLongitude: value
maxLatitude: value
geometryColumn: value
currentBoundsItem: value
}
multiSeriesChartData {
fillGapsInChartData: false
sortOrder: valueAsc
renderGapAsZero: false
}
secondaryBody {
advancedFormatting: false
column: value
htmlExpression: ```html
value
```
cssClasses: [
value
value
]
}
pageFooter {
font: helvetica
fontWeight: normal
fontSize: 42
fontColor: value
alignment: start
pageFooterText: ```
value
```
}
download {
authorization: mustNotBePublicUser
sendAsEmail: false
csvSeparator: value
csvEnclosedBy: value
csvExportEnabled: false
filename: value
supplementalText: ```
value
```
linkText: value
formats: [
csv
html
]
}
settings {
timeAxisType: auto
zoomAndScroll: false
zoomDirection: bothAxes
initialZooming: first
showHorizontalGrid: auto
showVerticalGrid: auto
showRowAxis: false
axisPosition: top
pieSelectionEffect: explode
renderAs: area
}
iconAndBadge {
iconSource: initials
iconColumn: value
imageColumn: value
imageUrl: value
iconCssClasses: value
iconPosition: top
iconDescription: value
badgeColumn: value
badgeLabel: value
badgeCssClasses: [
value
value
]
}
componentAdvanced {
stripHtml: false
sortNulls: first
customSvgStyles: ```
value
```
oracleTextIndexColumn: value
emailFromAddress: value
initJavaScriptFunction: ```javascript-browser
value
```
regionAlias: value
reportIdItem: value
maxRowsPerPageInSelector: value
}
singleRowView {
excludeNullValues: false
onlyDisplayedColumns: false
}
heading {
type: columnNames
plsqlFunctionBody: ```plsql
value
```
fixedTo: none
fixedReportHeight: 42
maxReportHeight: 42
}
iconView {
show: false
custom: false
customIcon: ```html
value
```
iconType: imageInUrl
iconUrl: value
icon: value
iconAttributes: value
linkTarget: {
type: in_app
url: value
app: value
page: value
items: [
value
value
]
clearCache: value
action: value
request: value
anchor: value
session: "&SESSION."
debug: "&DEBUG."
printerFriendly: N
otherArgs: value
}
linkAttributes: value
labelColumn: value
columnsPerRow: "1"
linkColumn: value
imageSourceColumn: value
imageAttributes: value
htmlAltText: value
htmlTitleText: value
customLink: ```
value
```
}
media {
advancedFormatting: false
htmlExpression: ```html
value
```
source: imageUrl
url: value
urlColumn: value
blobColumn: value
position: first
appearance: square
sizing: fit
cssClasses: [
value
value
]
imageDescription: value
}
legend {
show: false
title: value
position: start
selector: value
cssClasses: [
value
value
]
hideAndShowBehavior: none
fontFamily: arial
fontStyle: normal
fontSize: "8"
fontColor: value
}
overview {
show: false
height: value
}
printing {
enabled: false
}
externalProcessing {
enabled: false
url: value
linkText: value
}
genAI {
naturalLanguageSupport: false
defaultSearchMode: searchModeRow
reportContext: ```
value
```
enabled: false
agent: @component
service: @component
systemPrompt: ```
value
```
welcomeMessage: ```html
value
```
}
value {
pieChartOtherThreshold: 42
min: 42
show: false
valueType: number
position: auto
format: dateShort
decimalPlaces: 42
currency: value
pattern: value
formatScaling: none
}
attributes {
messagesPosition: above
messageSelector: value
unitSystem: metric
unitSystemItem: value
copyrightNotice: ```html
value
```
}
searchBar {
includeSearchBar: false
searchField: false
finderDropDown: false
reportsSelectList: false
rowsPerPageSelector: false
searchButtonLabel: value
}
orderBy {
type: staticValue
orderByClause: ```sql
value
```
item: {
itemName: value
orderBys: [
value
value
]
}
}
blobAttributes {
mimeTypeColumn: value
lastUpdatedColumn: value
}
detailView {
show: false
beforeRows: ```html
value
```
forEachRow: ```html
value
```
afterRows: ```html
value
```
}
actionsMenu {
includeActionsMenu: false
filter: false
selectColumns: false
rowsPerPage: false
sort: false
controlBreak: false
highlight: false
compute: false
aggregate: false
chart: false
groupBy: false
pivot: false
flashback: false
saveReport: false
savePublicReport: false
savePublicReportAuthorization: mustNotBePublicUser
reset: false
help: false
download: false
subscription: false
}
dataProfile {
nestedRows: @component
}
animation {
onDisplay: auto
onDataChange: auto
}
restSynchronization {
useLocalTable: false
}
tooltip {
show: false
showSeriesName: false
showGroupName: false
showValue: false
showRow: false
showLabel: false
showStartDate: false
showEndDate: false
showProgress: false
showBaseline: false
}
externalFilterAndOrderBy {
enabled: false
filter: ```
value
```
orderByType: staticValue
orderBy: ```
value
```
item: {
itemName: value
orderBys: [
value
value
]
}
}
advanced {
savedReportMappingIdentifier: value
htmlDomId: value
customAttributes: value
regionImage: value
imageTagAttributes: value
staticId: value
regionDisplaySelector: false
excludeTitleFromTranslation: false
schemaOverrideItem: value
}
help {
helpText: ```html
value
```
}
localPostProcessing {
type: whereOrderByClause
whereClause: ```sql
value
```
sqlQuery: ```sql
value
```
language: plsql
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
orderByType: staticValue
orderByClause: ```sql
value
```
item: {
itemName: value
orderBys: [
value
value
]
}
orderByItem: {
itemName: value
orderBys: [
value
value
]
}
}
autoRefresh {
interval: 42
}
remoteCache {
caching: allUsers
timeout: ```
value
```
}
layout {
sequence: 42
parentRegion: @component
slot: value
startNewLayout: false
startNewRow: false
rowCssClasses: [
value
value
]
column: value
newColumn: false
columnSpan: value
columnCssClasses: [
value
value
]
columnAttributes: [
value
value
]
}
description {
description: ```
value
```
}
appearance {
template: @component
templateOptions: [
value
value
]
cssClasses: [
value
value
]
icon: value
renderComponents: aboveContent
}
accessibility {
useLandmark: false
landmarkType: banner
landmarkLabel: value
}
image {
fileUrl: value
accessibleDescription: value
customAttributes: value
}
masterDetail {
masterRegion: @component
}
headerAndFooter {
headerText: ```html
value
```
footerText: ```html
value
```
}
serverSideCondition {
type: always
sqlQuery: ```sql
value
```
language: sql
sqlExpression: ```sql
value
```
plsqlExpression: ```plsql
value
```
javaScriptExpression: ```javascript-mle
value
```
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
value: value
item: value
preference: value
page: 42
pages: [
42
42
]
text: value
list: [
value
value
]
}
readOnly {
type: always
sqlQuery: ```sql
value
```
language: sql
sqlExpression: ```sql
value
```
plsqlExpression: ```plsql
value
```
javaScriptExpression: ```javascript-mle
value
```
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
value: value
item: value
preference: value
page: 42
pages: [
42
42
]
text: value
list: [
value
value
]
}
security {
authorizationScheme: mustNotBePublicUser
escapeSpecialChars: false
}
serverCache {
caching: false
cacheTimeout: "10Seconds"
dependsOnItems: [
value
value
]
type: always
sqlQuery: ```sql
value
```
language: sql
sqlExpression: ```sql
value
```
plsqlExpression: ```plsql
value
```
javaScriptExpression: ```javascript-mle
value
```
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
value: value
item: value
preference: value
page: 42
pages: [
42
42
]
text: value
list: [
value
value
]
}
customization {
customizable: false
name: value
}
config {
buildOption: @component
}
comments {
comments: ```
value
```
}
rowSelection {
type: focusOnly
currentSelectionPageItem: value
selectAllPageItem: value
}
entityTitle {
singular: value
plural: value
}
)