WorkItemBoardSnapshot
List WorkItemBoardSnapshot
Columns
Name | Type | References | Description |
ParentReference | String | ||
BoardLocationSK [KEY] | Integer | ||
DateSK | Integer | ||
WorkItemId | Integer | ||
ActivatedByUserSK | String | ||
ActivatedDate | Datetime | ||
ActivatedDateSK | Integer | ||
Activity | String | ||
AreaSK | String | ||
AssignedToUserSK | String | ||
AutomatedTestId | String | ||
AutomatedTestName | String | ||
AutomatedTestStorage | String | ||
AutomatedTestType | String | ||
AutomationStatus | String | ||
BacklogType | String | ||
BoardCategoryReferenceName | String | ||
BoardId | String | ||
BoardLevel | Integer | ||
BoardName | String | ||
BusinessValue | Integer | ||
ChangedByUserSK | String | ||
ChangedDate | Datetime | ||
ChangedDateSK | Integer | ||
ClosedByUserSK | String | ||
ClosedDate | Datetime | ||
ClosedDateSK | Integer | ||
ColumnId | String | ||
ColumnItemLimit | Integer | ||
ColumnName | String | ||
ColumnOrder | Integer | ||
CommentCount | Integer | ||
CompletedDate | Datetime | ||
CompletedDateSK | Integer | ||
CompletedWork | Double | ||
Count | Double | ||
CreatedByUserSK | String | ||
CreatedDate | Datetime | ||
CreatedDateSK | Integer | ||
CycleTimeDays | Datetime | ||
Done | String | ||
DueDate | Datetime | ||
Effort | Double | ||
FinishDate | Datetime | ||
InProgressDateSK | Integer | ||
IntegrationBuild | String | ||
IsBoardVisible | Boolean | ||
IsColumnSplit | Boolean | ||
IsCurrent | Boolean | ||
IsDefaultLane | Boolean | ||
IsDone | Boolean | ||
IsLastDayOfPeriod | String | ||
Issue | String | ||
IterationSK | String | ||
LaneId | String | ||
LaneName | String | ||
LaneOrder | Integer | ||
LeadTimeDays | Double | ||
Microsoft_VSTS_CodeReview_AcceptedBySK | String | ||
Microsoft_VSTS_CodeReview_AcceptedDate | Datetime | ||
Microsoft_VSTS_CodeReview_ClosedStatus | String | ||
Microsoft_VSTS_CodeReview_ClosedStatusCode | Double | ||
Microsoft_VSTS_CodeReview_ClosingComment | String | ||
Microsoft_VSTS_CodeReview_Context | String | ||
Microsoft_VSTS_CodeReview_ContextCode | Double | ||
Microsoft_VSTS_CodeReview_ContextOwner | String | ||
Microsoft_VSTS_CodeReview_ContextType | String | ||
Microsoft_VSTS_Common_ReviewedBySK | String | ||
Microsoft_VSTS_Common_StateCode | Double | ||
Microsoft_VSTS_Feedback_ApplicationType | String | ||
Microsoft_VSTS_TCM_TestSuiteType | String | ||
Microsoft_VSTS_TCM_TestSuiteTypeId | Double | ||
OriginalEstimate | Double | ||
ParentWorkItemId | Integer | ||
Priority | Integer | ||
ProjectSK | String | ||
Rating | String | ||
Reason | String | ||
RemainingWork | Double | ||
ResolvedByUserSK | String | ||
ResolvedDate | Datetime | ||
ResolvedDateSK | Integer | ||
ResolvedReason | String | ||
Revision | Integer | ||
Risk | String | ||
Severity | String | ||
StackRank | Double | ||
StartDate | Datetime | ||
State | String | ||
StateCategory | String | ||
StateChangeDate | Datetime | ||
StateChangeDateSK | Integer | ||
StoryPoints | Double | ||
TagNames | String | ||
TargetDate | Datetime | ||
TeamSK | String | ||
TimeCriticality | Double | ||
Title | String | ||
ValueArea | String | ||
Watermark | Integer | ||
WorkItemRevisionSK | Integer | ||
WorkItemType | String |