SSIS Components for Azure DevOps

Build 24.0.9060

WorkItemUpdatesHistory

Retrieves a work item's updates history as a list. The WorkItemId can be filtered server-side.

Columns

Name Type References Description
Id [KEY] Integer Id
WorkItemId [KEY] Integer

WorkItemIds.Id

Id of Workitem
PriorityNewValue Integer Field Value for the work item updates.
StateChangeDateNewValue Datetime Field Value for the work item updates.
ValueAreaNewValue String Field Value for the work item updates.
AreaIdNewValue Integer Field Value for the work item updates.
AreaLevel1NewValue String Field Value for the work item updates.
AreaPathNewValue String Field Value for the work item updates.
AuthorizedAsDescriptor String Field Value for the work item updates.
AuthorizedAsDisplayName String Field Value for the work item updates.
AuthorizedAsId String Field Value for the work item updates.
AuthorizedAsurl String Field Value for the work item updates.
AuthorizedDateNewValue Datetime Field Value for the work item updates.
ChangedByDescriptor String Field Value for the work item updates.
ChangedByDisplayName String Field Value for the work item updates.
ChangedById String Field Value for the work item updates.
ChangedByUrl String Field Value for the work item updates.
ChangedDateNewValue Datetime Field Value for the work item updates.
CommentCountNewValue Integer Field Value for the work item updates.
CreatedByDescriptor String Field Value for the work item updates.
CreatedByDisplayName String Field Value for the work item updates.
CreatedById String Field Value for the work item updates.
CreatedByUrl String Field Value for the work item updates.
CreatedDateNewValue Datetime Field Value for the work item updates.
NodeNameNewValue String Field Value for the work item updates.
PersonIdNewValue Integer Field Value for the work item updates.
ReasonNewValue String Field Value for the work item updates.
RevNewValue Integer Field Value for the work item updates.
RevisedDate.newValue Datetime Field Value for the work item updates.
StateNewValue String Field Value for the work item updates.
TeamProjectNewValue String Field Value for the work item updates.
TitleNewValue String Field Value for the work item updates.
WatermarkNewValue Integer Field Value for the work item updates.
WorkItemTypeNewValue String Field Value for the work item updates.
Revision Integer Revision
RevisedByDescriptor String Field Value for the work item updates.
RevisedByDisplayName String Field Value for the work item updates.
RevisedById String Field Value for the work item updates.
RevisedByName String Field Value for the work item updates.
RevisedByUrl String Field Value for the work item updates.
RevisedDate Datetime Field Value for the work item updates.
Url String Field Value for the work item updates.
Relations String Relations in work items updates history

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