Get Report Details
Select
SaaS
Customer Managed
This operation returns report details for a specific report.
Responses
- 200
OK
- application/json
- Schema
- Example (from schema)
- Example 1
Schema
report object
customReportId integercustomReportName stringpages object[]
pageName stringisDefault booleanpageTitle object
text stringdataSets object
dataSet object[]
dataSet object
dataSetId integerdataSetName stringdataSetGuid stringendpoint stringshared booleandataSources object[]
connectionType stringendpoint stringcommCell object
commCellName stringallColumns booleanfields object[]
name stringdataField stringtype stringGetOperation object
parameters object[]
sqlText stringtimeout integerpostQueryFilter booleandescription stringdatabaseName stringqueryPlan object
offline booleancollectionType stringretentionDays integerversions string[]dynamicCollection booleanfrequency integerversion integerguid stringrevision stringcomputedColumns object
scriptName stringscript stringcolumnList object[]
inputs object[]
body stringuserFilters object[]
view object[]
- reportVersion integer
- deployedVersion integer
- reportDescription string
- guid string
- revision string
- icon string
customIcon object
- hidden boolean
- visibleAll boolean
- readOnly boolean
- shareable boolean
- engineVersion integer
- builderVersion integer
translations object[]
locale stringlocaleKey stringlocaleValue stringcvTranslations object[]
minCommCellVersion object
releaseID integerservicePack integermaxCommCellVersion object
releaseID integerservicePack integer- userReportId string
- type string
- canEdit boolean
- visibleToTenantAdmins boolean
{
"report": {
"customReportId": 0,
"customReportName": "string"
},
"pages": [
{
"pageName": "string",
"isDefault": true,
"pageTitle": {
"text": "string"
},
"dataSets": {
"dataSet": [
{
"dataSet": {
"dataSetId": 0,
"dataSetName": "string",
"dataSetGuid": "string"
},
"endpoint": "string",
"shared": true,
"dataSources": [
{
"connectionType": "string",
"endpoint": "string",
"commCell": {
"commCellName": "string"
}
}
],
"allColumns": true,
"fields": [
{
"name": "string",
"dataField": "string",
"type": "string"
}
],
"GetOperation": {
"parameters": [
{}
],
"sqlText": "string",
"timeout": 0,
"postQueryFilter": true
},
"description": "string",
"databaseName": "string",
"queryPlan": {
"offline": true,
"collectionType": "string",
"retentionDays": 0,
"versions": [
"string"
],
"dynamicCollection": true,
"frequency": 0
},
"version": 0,
"guid": "string",
"revision": "string",
"computedColumns": {
"scriptName": "string",
"script": "string",
"columnList": [
{}
]
}
}
]
},
"inputs": [
{}
],
"body": "string",
"userFilters": [
{}
],
"view": [
{}
]
}
],
"reportVersion": 0,
"deployedVersion": 0,
"reportDescription": "string",
"guid": "string",
"revision": "string",
"icon": "string",
"customIcon": {},
"hidden": true,
"visibleAll": true,
"readOnly": true,
"shareable": true,
"engineVersion": 0,
"builderVersion": 0,
"translations": [
{
"locale": "string",
"localeKey": "string",
"localeValue": "string"
}
],
"cvTranslations": [
{}
],
"minCommCellVersion": {
"releaseID": 0,
"servicePack": 0
},
"maxCommCellVersion": {
"releaseID": 0,
"servicePack": 0
},
"userReportId": "string",
"type": "string",
"canEdit": true,
"visibleToTenantAdmins": true
}
{
"report": {
"customReportId": 363,
"customReportName": "Indexing Version Status"
},
"pages": [
{
"pageName": "Page0",
"isDefault": true,
"pageTitle": {
"text": "Page0"
},
"dataSets": {
"dataSet": [
{
"dataSet": {
"dataSetId": 1064,
"dataSetName": "Indexing Version Status",
"dataSetGuid": "e9e507ee-e0c7-4179-8ab2-a6de90ab3992"
},
"endpoint": "DATABASE",
"shared": false,
"dataSources": [
{
"connectionType": "COMMCELL",
"endpoint": "DATABASE",
"commCell": {
"commCellName": "$ALL$"
}
}
],
"allColumns": false,
"fields": [
{
"name": "sys_rowid",
"dataField": "$row_number$",
"type": "String"
},
{
"name": "Data Source",
"dataField": "Data Source",
"type": "String"
},
{
"name": "Client Name",
"dataField": "Client Name",
"type": "String"
},
{
"name": "Agent",
"dataField": "Agent",
"type": "String"
},
{
"name": "Indexing Version",
"dataField": "Indexing Version",
"type": "String"
}
],
"GetOperation": {
"sqlText": "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED\nDECLARE @csReleaseId INT = ISNULL((SELECT releaseId FROM APP_Client WITH(NOLOCK) WHERE id = 2), 0)\n\nDECLARE @executeStr NVARCHAR(1024) = '\nselect client.name as ''Client Name'', idaType.name as ''Agent'', \n(\nCASE \n\tWHEN clientprop.attrVal = ''0'' THEN ''Indexing Version 1''\n\tWHEN clientprop.attrVal = ''1'' THEN ''Indexing Version 2''\n\tWHEN clientprop.attrVal IS NULL THEN ''Indexing Version 1''\nEND\n) as ''Indexing Version'' from app_client client (NOLOCK) JOIN app_idaname idaName (NOLOCK) JOIN app_idatype idaType (NOLOCK)\n ON idaName.appTypeId = idaType.type\n ON client.id = idaName.clientId LEFT JOIN app_clientprop clientprop (NOLOCK)\non client.id = clientprop.componentNameId and clientprop.modified = 0 and attrType = ''2'' \nand attrName like ''IndexingV2%'' and attrName = dbo.GetIndexingV2PropNameByAppType(idaName.appTypeId) and attrVal = 1\nwhere client.id > 1\norder by client.name'\n\n-- ONLY USE DISPLAYNAME FOR REL 11.0 AND HIGHER!\nIF @csReleaseId >= 16\n\tSET @executeStr = REPLACE (@executeStr, 'client.name', 'client.displayName')\n\nEXEC sp_executeSQL @executeStr",
"timeout": 5,
"postQueryFilter": true
},
"description": "This report lists the every client along with the iDA installed in the client and their indexing version (V1 or V2).",
"databaseName": "CommServ",
"queryPlan": {
"offline": false,
"collectionType": "HTTP",
"retentionDays": 1,
"versions": [
"ALL"
],
"dynamicCollection": false,
"frequency": 60
},
"version": 1,
"guid": "41d0535d-69d6-4ef4-beac-cbe4391946df",
"revision": "",
"computedColumns": {
"scriptName": "R",
"script": "",
"columnList": []
}
}
]
},
"inputs": [],
"body": "{\n \"reportComponents\": [\n {\n \"type\": \"TABLE\",\n \"dataSet\": {\n \"dataSetName\": \"Indexing Version Status\",\n \"dataSetGuid\": \"e9e507ee-e0c7-4179-8ab2-a6de90ab3992\",\n \"originalDataSetName\": \"\"\n },\n \"title\": {\n \"text\": \"\"\n },\n \"id\": \"Table1513621600054\",\n \"pageSize\": 20,\n \"columns\": [\n {\n \"dataField\": \"Client Name\",\n \"displayName\": \"Client Name\",\n \"id\": \"ClientName\",\n \"type\": \"String\",\n \"origType\": \"String\",\n \"visible\": true,\n \"hidden\": false,\n \"aggrType\": \"None\",\n \"mobileOptions\": {\n \"visible\": true,\n \"viewOnList\": true,\n \"viewOnDetail\": true\n }\n },\n {\n \"dataField\": \"Agent\",\n \"displayName\": \"Agent\",\n \"id\": \"Agent\",\n \"type\": \"String\",\n \"origType\": \"String\",\n \"visible\": true,\n \"hidden\": false,\n \"aggrType\": \"None\",\n \"mobileOptions\": {\n \"visible\": true,\n \"viewOnList\": true,\n \"viewOnDetail\": true\n }\n },\n {\n \"dataField\": \"Indexing Version\",\n \"displayName\": \"Indexing Version\",\n \"id\": \"IndexingVersion\",\n \"type\": \"String\",\n \"origType\": \"String\",\n \"visible\": true,\n \"hidden\": false,\n \"aggrType\": \"None\",\n \"isSelected\": false,\n \"mobileOptions\": {\n \"visible\": true,\n \"viewOnList\": true,\n \"viewOnDetail\": true\n }\n }\n ],\n \"allColumns\": false,\n \"dataSetName\": \"\",\n \"styles\": {\n \"chartPlotOptions\": {\n \"isShowGridlines\": true,\n \"isSmoothLines\": false,\n \"isShowLineMarkers\": true,\n \"autoConvertYValues\": true,\n \"isShowLabels\": false,\n \"legendPosition\": \"right\"\n }\n },\n \"filters\": {\n \"builder\": {},\n \"viewer\": {}\n },\n \"orientation\": \"vertical\",\n \"showSearchBar\": true,\n \"mobile\": {\n \"visible\": \"On\",\n \"listItemClick\": {},\n \"customListLayout\": null\n },\n \"quickChart\": {\n \"height\": 649\n },\n \"autoHeight\": \"On\"\n }\n ],\n \"filters\": {\n \"builder\": {},\n \"viewer\": {}\n },\n \"autoRefreshTime\": 10,\n \"reportLayout\": {\n \"gridsterOpts\": {\n \"columns\": 12\n },\n \"Table1513621600054\": {\n \"mobile\": {\n \"size\": {\n \"x\": 4,\n \"y\": 8\n },\n \"position\": [\n 0,\n 0\n ]\n },\n \"tablet\": {\n \"size\": {\n \"x\": 4,\n \"y\": 8\n },\n \"position\": [\n 0,\n 0\n ]\n },\n \"desktop\": {\n \"size\": {\n \"x\": 12,\n \"y\": 15\n },\n \"position\": [\n 0,\n 0\n ]\n }\n }\n }\n}",
"userFilters": [],
"view": []
}
],
"reportVersion": 1,
"deployedVersion": 1,
"reportDescription": "This report lists the every client along with the iDA installed in the client and their indexing version (V1 or V2).",
"guid": "62932be7-a4e7-40bb-cab3-ca9c0ce5fb9a",
"revision": "$Revision: 1.1.2.3 $",
"icon": "data-table.png",
"customIcon": {},
"hidden": false,
"visibleAll": false,
"readOnly": false,
"shareable": false,
"engineVersion": 1,
"builderVersion": 2,
"translations": [
{
"locale": "default",
"localeKey": "RPT_DESCRIPTION",
"localeValue": "This report lists the every client along with the iDA installed in the client and their indexing version (V1 or V2)."
},
{
"locale": "default",
"localeKey": "RPT_TITLE",
"localeValue": "Indexing Version Status"
}
],
"cvTranslations": [],
"minCommCellVersion": {
"releaseID": 16,
"servicePack": 13
},
"maxCommCellVersion": {
"releaseID": 100,
"servicePack": 99
},
"userReportId": "Indexing Version Status",
"type": "STANDARD",
"canEdit": true,
"visibleToTenantAdmins": false
}
Loading...