RelatedDataSourcesWithRelationshipsResultΒΆ
Field | NULL | Description | Note |
---|---|---|---|
relatedDataSources array of objects |
An array of QuerySource objects | ||
selectedRealtionships array of objects |
An array of Relationship objects |
Sample:
{
"relatedDataSources": [{
"serverTypeId": "572bd576-8c92-4901-ab2a-b16e38144813",
"serverTypeName": "MSSQL",
"id": "83554d8c-3383-42b6-be73-0bb31cdb40db",
"name": "Northwind-MSSQL",
"querySource": [{
"id": "8b26c324-6b9e-484e-8202-123e2180bd0b",
"name": "Employees",
"originalName": "Employees",
"type": "Table",
"selected": true,
"visible": true,
"querySourceCategoryName": "dbo",
"dataSourceCategoryName": "MSSQL",
"dataSourceCategoryId": "518033c3-9db5-4ac1-9cb0-c4581d052b76",
"connectionName": "Northwind-MSSQL",
"connectionId": "83554d8c-3383-42b6-be73-0bb31cdb40db",
"isAlias": false,
"isNativeAlias": false,
"isDynamic": false,
"fields": [{
"name": "EmployeeID",
"alias": "",
"dataType": "int",
"izendaDataType": "Numeric",
"allowDistinct": true,
"visible": true,
"filterable": true,
"querySourceId": "8b26c324-6b9e-484e-8202-123e2180bd0b",
"parentId": null,
"expressionFields": [],
"filteredValue": "{}",
"type": 0,
"groupPosition": 0,
"position": 0,
"extendedProperties": null,
"physicalChange": 0,
"approval": 0,
"existed": false,
"checked": false,
"matchedTenant": false,
"functionName": null,
"expression": null,
"isRunningField": false,
"supportDefaultTotal": null,
"fullName": null,
"calculatedTree": null,
"reportId": null,
"originalName": "EmployeeID",
"isAlias": false,
"originalId": "00000000-0000-0000-0000-000000000000",
"isParameter": false,
"isCalculated": false,
"isPredicated": false,
"modelName": null,
"targetValue": null,
"relationColumn": null,
"inputFeatures": null,
"hasAggregatedFunction": false,
"isCompositeField": false,
"hasSupportDefaultTotal": true,
"querySource": null,
"querySourceName": null,
"categoryName": null,
"inaccessible": false,
"originalAlias": null,
"allowToSave": false,
"filterLookupType": 0,
"filterLookupStatus": 0,
"dataBaseType": 0,
"fullPath": null,
"isCheck": false,
"id": "4fdcb7e5-0d09-4fdf-a0f2-e1b69589941f",
"state": 0,
"deleted": false,
"inserted": true,
"version": null,
"created": null,
"createdBy": "System Admin",
"modified": "0001-01-01T00:00:00",
"modifiedBy": null
}],
"numOfChilds": 1,
"numOfCheckedChilds": 0,
"indeterminate": false,
"fullPath": null,
"computeNameSettings": null,
"isCheck": false
}],
"numOfChilds": 0,
"numOfCheckedChilds": 0,
"indeterminate": false,
"fullPath": null,
"computeNameSettings": null,
"isCheck": false
}],
"selectedRealtionships": [{
"joinConnectionId": "83554d8c-3383-42b6-be73-0bb31cdb40db",
"foreignConnectionId": "83554d8c-3383-42b6-be73-0bb31cdb40db",
"joinQuerySourceAlias": null,
"foreignQuerySourceAlias": null,
"joinFieldAlias": "",
"specifictJoinFieldAlias": null,
"foreignFieldAlias": "",
"specifictForeignFieldAlias": null,
"alias": "Employees (Self-Joined)",
"systemRelationship": false,
"disabled": false,
"joinType": "Inner",
"parentRelationshipId": "b5109c00-7c43-4e88-9216-3b22cd3768b5",
"position": null,
"relationshipPosition": 0,
"hasBeenModified": false,
"isPredictionRelation": false,
"predictionRelationId": null,
"predictionId": null,
"relationshipKeyJoins": [],
"reportId": null,
"foreignAlias": null,
"joinQuerySourceUniqueName": null,
"joinFieldUniqueName": null,
"forgeinQuerySourceUniqueName": null,
"forgeinFieldUniqueName": null,
"tempId": null,
"aliasTempId": null,
"originalId": "00000000-0000-0000-0000-000000000000",
"isForeignDataObjectAlias": false,
"positionId": null,
"selectedForeignAlias": "8b26c324-6b9e-484e-8202-123e2180bd0b_Employees",
"joinQuerySourceName": "Employees",
"joinQuerySourceId": "8b26c324-6b9e-484e-8202-123e2180bd0b",
"joinFieldId": "68f8968b-d5d7-4e5f-b822-abba656bea34",
"joinFieldType": null,
"foreignQuerySourceName": "Employees",
"foreignQuerySourceId": "8b26c324-6b9e-484e-8202-123e2180bd0b",
"foreignFieldId": "4fdcb7e5-0d09-4fdf-a0f2-e1b69589941f",
"foreignFieldType": null,
"joinFieldName": "ReportsTo",
"foreignFieldName": "EmployeeID",
"joinDataSourceCategoryId": "518033c3-9db5-4ac1-9cb0-c4581d052b76",
"joinDataSourceCategoryName": "MSSQL",
"foreignDataSourceCategoryId": "518033c3-9db5-4ac1-9cb0-c4581d052b76",
"foreignDataSourceCategoryName": "MSSQL",
"comparisonOperator": null,
"id": "5c41f75b-7cc0-4459-91ab-4187da590ea8",
"state": 1,
"deleted": false,
"inserted": false,
"version": null,
"created": null,
"createdBy": "System Admin",
"modified": "2021-06-17T14:42:13",
"modifiedBy": null
}]
}