Relationship
| Field | NULL | Description | Note |
|---|---|---|---|
| joinConnectionId string (GUID) |
Y | The id of the connection containing the relationship | |
| foreignConnectionId string (GUID) |
Y | The id of the connection of the query source referenced by the relationship | |
| joinQuerySourceAlias string |
The alias of the query source containing the relationship | ||
| foreignQuerySourceAlias string |
The alias of the query source referenced by the relationship | ||
| joinFieldAlias string |
The alias of the join field | ||
| specifictJoinFieldAlias string |
The alias to be used in query without generating a new one | ||
| foreignFieldAlias string |
The alias of the foreign field | ||
| specifictForeignFieldAlias string |
The alias to be used in query without generating a new one | ||
| alias string |
The alias of the join query soure in relationship | ||
| systemRelationship boolean |
Is this relationship from physical database (cannot be deleted) | ||
|
disabled New in version 3.10.0. |
Indicate if the relationship is disabled or not | ||
| joinType string |
Either ‘Inner’, ‘Left’, ‘Right’, ‘Full’ or ‘Cross’ | ||
| parentRelationshipId string (GUID) |
Y | The id of the parent relationship - in case this is cloned from a physical relationship | |
| position string |
Place-holder | ||
| relationshipPosition integer |
The ordinal position of this relationship inside a list of relationships | ||
| relationshipKeyJoins array of objects |
An array of RelationshipKeyJoin objects | ||
| reportId string (GUID) |
Y | The id of the parent report, in case this is a relationship in a report | |
| foreignAlias string |
The foreign alias | ||
| joinQuerySourceUniqueName string |
Unique name for join query source | ||
| joinFieldUniqueName string |
Unique name for join field | ||
| foreignQuerySourceUniqueName string |
Unique name for foreign query source | ||
| foreignFieldUniqueName string |
Unique name for foreign field | ||
| tempId string |
The temporary id | ||
| aliasTempId string |
Place-holder | ||
| originalId string (GUID) |
The original id of the relationship - in case this is cloned from a physical relationship | ||
| isForeignDataObjectAlias boolean |
Whether this instance is foreign data object alias | ||
| selectedForeignAlias string |
<foreignQuerySourceId>_[<foreignAlias>|<foreignQuerySourceName>] |
||
|
hasBeenModified New in version 2.11.0. |
Whether the relationship has been modified or not | ||
|
positionId New in version 2.16.0. |
The order of relationships when executing the query | ||
|
invalid New in version 2.16.0. |
Y | Whether the relationship is valid or not | Use when validating invalid relationship(s) in Data Model > Relationships |
|
errors New in version 2.16.0. |
Y | The list of all the relationship errors | Use when validating invalid relationship(s) in Data Model > Relationships |
Inherited fields:
RelationshipBase
| Field | NULL | Description | Note |
|---|---|---|---|
| joinQuerySourceName string |
The alias/name of the query source containing the relationship | ||
| joinQuerySourceId string (GUID) |
The id of the query source containing the relationship | ||
| joinFieldId string (GUID) |
Y | The id of the referencing field | |
| joinFieldType string |
Place-holder | ||
| foreignQuerySourceName string |
The alias/name of the query source referenced by the relationship | ||
| foreignQuerySourceId string (GUID) |
The id of the query source referenced by the relationship | ||
| foreignFieldId string (GUID) |
Y | The id of the field referenced by the relationship | |
| foreignFieldType string |
Place-holder | ||
| joinFieldName string |
The alias/name of the referencing field | ||
| foreignFieldName string |
The alias/name of the field referenced by the relationship | ||
| joinDataSourceCategoryId string (GUID) |
The id of the category of the query source containing the relationship | ||
| joinDataSourceCategoryName string |
The name of the category of the query source containing the relationship | ||
| foreignDataSourceCategoryId string (GUID) |
The id of the category of the query source referenced by the relationship | ||
| foreignDataSourceCategoryName string |
The name of the category of the query source referenced by the relationship | ||
| comparisonOperator string |
The comparison operator |
Inherited fields:
Entity
| Field | NULL | Description | Note |
|---|---|---|---|
| id string (GUID) |
The id of this object Example: 572bd576-8c92-4901-ab2a-b16e38144813 |
Allow null incase insert a new entity | |
| state integer |
The entity state of this object
|
||
| deleted boolean |
Is this object deleted | ||
| inserted boolean |
Is this object inserted | ||
| version string |
Y | The version | |
| created datetime in ISO 8601 format |
Y | The created datetime | |
| createdBy string |
The creator | ||
| modified datetime in ISO 8601 format |
Y | The modification datetime | |
| modifiedBy string |
The user who last modified this object |
Sample:
{"joinConnectionId":"ca24a47e-ffdd-4391-a82a-254f48b451e5","foreignConnectionId":"ca24a47e-ffdd-4391-a82a-254f48b451e5","joinQuerySourceId":"e03b8805-60ae-41df-b69a-f3bece9721c5","joinQuerySourceName":"EmployeeDepartmentHistory","joinDataSourceCategoryName":null,"joinDataSourceCategoryId":"00000000-0000-0000-0000-000000000000","foreignDataSourceCategoryName":null,"foreignDataSourceCategoryId":"00000000-0000-0000-0000-000000000000","foreignQuerySourceId":"9fb719f8-8a70-4f4e-91d5-4e8372413d92","foreignQuerySourceName":"Employee","joinFieldId":"322d9f3d-1f65-4d60-9cac-933a2c40db9d","joinFieldName":"BusinessEntityID","foreignFieldId":"484817ea-f130-417b-a096-32c13249b7d0","foreignFieldName":"BusinessEntityID","alias":"abc","systemRelationship":true,"joinType":"Inner","parentRelationshipId":"00000000-0000-0000-0000-000000000000","deleted":false,"position":null,"relationshipKeyJoins":null,"reportId":"00000000-0000-0000-0000-000000000000","foreignAlias":null,"selectedForeignAlias":"9fb719f8-8a70-4f4e-91d5-4e8372413d92_Employee","id":"48ab1f19-db84-4d8b-9c18-02312d16c282","state":0,"modified":"2016-04-15T06:27:16.023"}