ReportDataSourceConnectionΒΆ
Field | NULL | Description | Note |
---|---|---|---|
id string (GUID) |
Y | The id of the object | |
name string |
The name of the connection | ||
querySource array of objects |
An array of ReportQuerySource objects | ||
serverTypeId string |
The id of the server type | ||
serverTypeName string |
The type of the server |
Sample:
{
"id": "83554d8c-3383-42b6-be73-0bb31cdb40db",
"name": "Northwind-MSSQL",
"querySource": [{
"connectionId": "83554d8c-3383-42b6-be73-0bb31cdb40db",
"connectionName": "Northwind-MSSQL",
"dataSourceCategoryId": "518033c3-9db5-4ac1-9cb0-c4581d052b76",
"dataSourceCategoryName": "MSSQL",
"fields": [{
"alias": "",
"allowDistinct": true,
"allowToSave": false,
"approval": 0,
"calculatedTree": null,
"categoryName": null,
"checked": false,
"created": null,
"createdBy": "System Admin",
"dataBaseType": 0,
"dataType": "int",
"deleted": false,
"existed": false,
"expression": null,
"expressionFields": [],
"extendedProperties": null,
"filterLookupStatus": 0,
"filterLookupType": 0,
"filterable": true,
"filteredValue": "{}",
"fullName": null,
"fullPath": null,
"functionName": null,
"groupPosition": 0,
"hasAggregatedFunction": false,
"hasSupportDefaultTotal": true,
"id": "7de99693-eb74-4209-80b4-12b530837211",
"inaccessible": false,
"inputFeatures": null,
"inserted": true,
"isAlias": false,
"isCalculated": false,
"isCheck": false,
"isCompositeField": false,
"isParameter": false,
"isPredicated": false,
"isRunningField": false,
"izendaDataType": "Numeric",
"matchedTenant": false,
"modelName": null,
"modified": "0001-01-01T00:00:00",
"modifiedBy": null,
"name": "OrderID",
"originalAlias": null,
"originalId": "00000000-0000-0000-0000-000000000000",
"originalName": "OrderID",
"parentId": null,
"physicalChange": 0,
"position": 0,
"querySource": null,
"querySourceId": "ec16146f-5873-4146-9a89-3c7b36f2d1bf",
"querySourceName": null,
"relationColumn": null,
"reportId": null,
"state": 0,
"supportDefaultTotal": null,
"targetValue": null,
"type": 0,
"version": null,
"visible": true
}, {
"alias": "",
"allowDistinct": true,
"allowToSave": false,
"approval": 0,
"calculatedTree": null,
"categoryName": null,
"checked": false,
"created": null,
"createdBy": "System Admin",
"dataBaseType": 0,
"dataType": "nchar",
"deleted": false,
"existed": false,
"expression": null,
"expressionFields": [],
"extendedProperties": null,
"filterLookupStatus": 0,
"filterLookupType": 0,
"filterable": true,
"filteredValue": "{}",
"fullName": null,
"fullPath": null,
"functionName": null,
"groupPosition": 0,
"hasAggregatedFunction": false,
"hasSupportDefaultTotal": true,
"id": "bb2f13f3-eba8-45bc-90ea-cac543691c04",
"inaccessible": false,
"inputFeatures": null,
"inserted": true,
"isAlias": false,
"isCalculated": false,
"isCheck": false,
"isCompositeField": false,
"isParameter": false,
"isPredicated": false,
"isRunningField": false,
"izendaDataType": "Text",
"matchedTenant": false,
"modelName": null,
"modified": "0001-01-01T00:00:00",
"modifiedBy": null,
"name": "CustomerID",
"originalAlias": null,
"originalId": "00000000-0000-0000-0000-000000000000",
"originalName": "CustomerID",
"parentId": null,
"physicalChange": 0,
"position": 0,
"querySource": null,
"querySourceId": "ec16146f-5873-4146-9a89-3c7b36f2d1bf",
"querySourceName": null,
"relationColumn": null,
"reportId": null,
"state": 0,
"supportDefaultTotal": null,
"targetValue": null,
"type": 0,
"version": null,
"visible": true
}],
"id": "ec16146f-5873-4146-9a89-3c7b36f2d1bf",
"isAlias": false,
"isCheck": false,
"isDynamic": false,
"name": "Orders",
"numOfCheckedChilds": 0,
"numOfChilds": 2,
"originalName": "Orders",
"querySourceCategoryName": "dbo",
"selected": false,
"visible": true,
"type": "Table"
}],
"serverTypeId": "572bd576-8c92-4901-ab2a-b16e38144813",
"serverTypeName": "MSSQL",
}