SSIS Components for Azure DevOps

Build 24.0.9063

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9063