WorkItems
List WorkItems
Table Specific Information
Select
The provider uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
- WorkItemId supports the '=' operator.
The rest of the filter is executed client-side in the provider.
For example:
SELECT * FROM WorkItems WHERE WorkItemId = 1 SELECT * FROM WorkItems WHERE WorkItemId IN (1, 2, 3)
Columns
| Name | Type | References | Description |
| ParentReference | String | Parent reference. Only available if IncludeReferenceColumn=true. | |
| WorkItemId [KEY] | Integer | Unique identifier assigned to a work item. A work item ID is unique across all projects within an organization or project collection. | |
| ActivatedByUserSK | String | Name of the team member who activated or reactivated the work item. | |
| ActivatedDate | Datetime | Date and time when a team member activated or reactivated a bug or work item. | |
| ActivatedDateSK | Integer | Activated date surrogate key. | |
| Activity | String | Type of activity or discipline assigned to perform a task. Allowed values are: Deployment, Design, Development, Documentation, Requirements, and Testing. (Agile, Scrum, and Basic processes). | |
| AnalyticsUpdatedDate | Datetime | Watermark indicating the last time the Analytics data was updated. | |
| AreaSK | String | Area surrogate key. | |
| AssignedToUserSK | String | Assigned to user surrogate key. | |
| AutomatedTestId | String | ID of the test that automates the test case. | |
| AutomatedTestName | String | Name of the team member who activated or reactivated the work item. | |
| AutomatedTestStorage | String | Assembly that contains the test that automates the test case. | |
| AutomatedTestType | String | Type of test that automates the test case. | |
| AutomationStatus | String | Status of a test case with the accepted values Automated, Not Automated, or Planned. | |
| BusinessValue | Integer | Subjective unit of measure that captures the relative business value of a product backlog item or feature compared to other items of the same type. Item assigned higher numbers are considered to have more business value than items assigned lower numbers. | |
| ChangedByUserSK | String | Name of the person who modified the work item most recently. | |
| ChangedDate | Datetime | Date and time when the work item was modified. | |
| ChangedDateSK | Integer | Date the work item was modified, expressed as YYYYMMDD in the time zone defined for the organization. Used by external tools to join related entities. | |
| ClosedByUserSK | String | Name of the person who closed a work item. | |
| ClosedDate | Datetime | Date and time when a work item was closed. | |
| ClosedDateSK | Integer | Date and time when a work item was closed. | |
| CommentCount | Integer | Number of comments added to the Discussion section of the work item. | |
| CompletedDate | Datetime | Completed date. | |
| CompletedDateSK | Integer | Navigational property date captured by Analytics that stores when the work item entered a workflow state associated with the Completed state category. | |
| CompletedWork | Double | Measure of the amount of work spent on a task. | |
| Count | Double | Count. | |
| CreatedByUserSK | String | Name of the person who created the work item. | |
| CreatedDate | Datetime | Date the work item was created, expressed in the time zone defined for the organization. Commonly used for filtering and display. | |
| CreatedDateSK | Integer | Date the work item was created, expressed in the time zone defined for the organization. Commonly used for filtering and display. | |
| CycleTimeDays | Double | Cycle time calculated from first entering an In Progress or Resolved state category to entering a Completed state category. | |
| DueDate | Datetime | Forecasted due date for an issue or work item to be resolved. (Agile process). | |
| Effort | Double | Estimated amount of work that a product backlog item (Scrum process) or issue (Basic process) requires to implement. | |
| FinishDate | Datetime | Date and time the schedule indicates a work item is to be completed. | |
| FoundIn | String | Product build number, also known as revision, in which a bug was found. | |
| InProgressDate | Datetime | Analytics stored date that captures the date-time when a work item was moved into a state that belongs to the In Progress state category. | |
| InProgressDateSK | Integer | Date the work item was moved into a State that belongs to the In Progress state category, expressed as YYYYMMDD in the time zone defined for the organization. Used by external tools to join related entities. | |
| IntegrationBuild | String | Product build number that incorporates the code or fixes a bug. | |
| Issue | String | Indication that the shared step is associated with an expected result. Allowed values are Yes and No. | |
| IterationSK | String | Iteration surrogate key. | |
| LeadTimeDays | Double | Lead time calculated from work item creation or entering a Proposed state category to entering a Completed state category. | |
| Microsoft_VSTS_CodeReview_AcceptedBySK | String | Name of the person who responded to a code review. (CMMI process) | |
| Microsoft_VSTS_CodeReview_AcceptedDate | Datetime | Date and time when the person responded to the code review. (CMMI process) | |
| Microsoft_VSTS_CodeReview_ClosedStatus | String | Microsoft_VSTS_CodeReview_ClosedStatus | |
| Microsoft_VSTS_CodeReview_ClosedStatusCode | Double | Microsoft_VSTS_CodeReview_ClosedStatusCode | |
| Microsoft_VSTS_CodeReview_ClosingComment | String | Microsoft_VSTS_CodeReview_ClosingComment | |
| Microsoft_VSTS_CodeReview_Context | String | Microsoft_VSTS_CodeReview_Context | |
| Microsoft_VSTS_CodeReview_ContextCode | Double | Microsoft_VSTS_CodeReview_ContextCode | |
| Microsoft_VSTS_CodeReview_ContextOwner | String | Microsoft_VSTS_CodeReview_ContextOwner | |
| Microsoft_VSTS_CodeReview_ContextType | String | Microsoft_VSTS_CodeReview_ContextType | |
| Microsoft_VSTS_Common_ReviewedBySK | String | Microsoft_VSTS_Common_ReviewedBySK | |
| Microsoft_VSTS_Common_StateCode | Double | Microsoft_VSTS_Common_StateCode | |
| Microsoft_VSTS_Feedback_ApplicationType | String | Microsoft_VSTS_TCM_TestSuiteType | |
| Microsoft_VSTS_TCM_TestSuiteType | String | Microsoft_VSTS_TCM_TestSuiteType | |
| Microsoft_VSTS_TCM_TestSuiteTypeId | Double | Microsoft_VSTS_TCM_TestSuiteTypeId | |
| OriginalEstimate | Double | Measure of the amount of work required to complete a task. | |
| ParentWorkItemId | Integer | Unique ID that identifies the work item linked to as a parent. Useful for generating rollup reports. The Parent field is valid for the entity types WorkItemRevision and WorkItem. | |
| Priority | Integer | Subjective rating of the bug, issue, task, or test case as it relates to the business. Values include 1, 2, or 3. | |
| ProjectSK | String | Project surrogate key. | |
| Rating | String | Number of stars an item receives from a reviewer in a star-based ranking system (Feedback Response). The number is stored in the system and written as 0 - Not Rated, 1 - Poor, 2 - Fair, 3 - Good, 4 - Very Good, or 5 - Excellent. Valid for the WorkItemRevision and WorkItem entity types. | |
| Reason | String | Reason why the work item is in the current state. Each transition from one workflow state to another is associated with a corresponding reason. | |
| RemainingWork | Double | Measure of the amount of work that remains to finish a task. | |
| ResolvedByUserSK | String | Name of the team member who resolved the bug or user story. | |
| ResolvedDate | Datetime | Date and time when the bug or user story was resolved. | |
| ResolvedDateSK | Integer | Date the work item was resolved, expressed as YYYYMMDD in the time zone defined for the organization. Used by external tools to join related entities. | |
| ResolvedReason | String | Reason the bug was resolved, such as Fixed. | |
| Revision | Integer | Number assigned to the historical revision of a work item. | |
| Risk | String | Subjective rating of relative uncertainty about the successful completion of the work item. Valid values include 1 - High, 2 - Medium, and 3 - Low. | |
| Severity | String | Subjective rating of the effect of a bug, issue, or risk on the project. Valid values include 1 - Critical, 2 - High, 3 - Medium, and 4 - Low. | |
| StackRank | Double | Number assigned by a system background process used to stack rank or track the sequence of items on a backlog or board. (Agile, Scrum, and Basic processes). | |
| StartDate | Datetime | Date and time assigned to a work item for work to start. | |
| State | String | Current state of the work item. The valid values for state are specific to each type of work item and customizations made to it. | |
| StateCategory | String | How Azure Boards and select dashboard widgets treat each workflow state. The state categories include Proposed, In Progress, Resolved, Removed, and Completed. | |
| StateChangeDate | Datetime | Date and time the value of the State field changed. | |
| StateChangeDateSK | Integer | Date the work item state changed, expressed as YYYYMMDD in the time zone defined for the organization. Used by external tools to join related entities. | |
| StoryPoints | Double | Estimate of the amount of work a user story requires to implement, commonly aggregated as a sum. (Agile process). | |
| TagNames | String | Semicolon-delimited list of tags assigned to one or more work items for filtering or querying purposes. | |
| TargetDate | Datetime | Forecasted due date for an issue or other work item to be resolved or completed. | |
| TimeCriticality | Double | Subjective unit of measure that captures how the business value lessens over time. Higher values indicate an epic or feature is inherently more time critical than items with lower values. | |
| Title | String | Short description summarizing the work item that helps team members distinguish it from other work items in a list. | |
| ValueArea | String | Area of customer value addressed by the epic, feature, or backlog item. Values include Architectural or Business. | |
| Watermark | Integer | System-managed field that increments with changes made to a work item. Valid for the WorkItemRevision and WorkItem entity types. | |
| WorkItemRevisionSK | Integer | Work item revision surrogate key. | |
| WorkItemType | String | Name of the work item type. Available work item types are based on the process the project uses. |