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. |