WorkItemRelations
Retrieves relationships between work items.
Columns
| Name | Type | References | Description |
| Id | Integer | Id of the work item. | |
| LinkedItemUrl | String | URL of the linked object. | |
| RelationType | String | Relation type. | |
| ProjectId | String | Id of the project. | |
| RelationName | String | Name of the relation. | |
| Comment | String | Comment on the relation. | |
| IsLocked | Boolean | Whether the relation is locked or not. | |
| ActionID | Integer | ID of action which created link. | |
| AuthorizedDate | Datetime | Authorization date of action which created link. | |
| ResourceCreatedDate | Datetime | Creation date of linked resource. | |
| ResourceModifiedDate | Datetime | Modification date of linked resource. | |
| RevisedDate | Datetime | Last revision date of link. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。 特に指定がない限り、擬似カラムでフィルタリングを行う場合は = 演算子のみ使用できます。
| Name | Type | Description | |
| AsOf | Datetime | AsOf UTC date time string. |