WorkItems
Retrieves a list of work items. This table includes custom fields which are automatically discovered when 'IncludeCustomFields' is enabled.
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | Id of the work item. | |
| ProjectId | String |
Projects.Id | Id of the project. |
| Type | String | Type of the work item. | |
| State | String | Current state of the work item. | |
| CreatedDate | Datetime | Creation date of the work item. | |
| CreatedById | String | User ID of work item creator. | |
| CreatedByDisplayName | String | Display name of work item creator. | |
| CreatedByName | String | User name of work item creator. | |
| CreatedByUrl | String | Profile link of work item creator. | |
| ChangedDate | Datetime | Date of last change to the work item. | |
| ChangedById | String | User ID of most recent work item editor. | |
| ChangedByDisplayName | String | Display name of most recent work item editor. | |
| ChangedByName | String | User name of most recent work item editor. | |
| ChangedByUrl | String | Profile link of most recent work item editor. | |
| AssignedToId | String | User ID of current work item assignee. | |
| AssignedToDisplayName | String | Display name of current work item assignee. | |
| AssignedToName | String | User name of current work item assignee. | |
| AssignedToUrl | String | Profile link of current work item assignee. | |
| LinksFieldsHref | String | Work item fields reference link. | |
| LinksHtmlHref | String | Html reference link. | |
| LinksSelfHref | String | Self reference link. | |
| LinksWorkItemHistoryHref | String | Work item history reference link. | |
| LinksWorkItemRevisionsHref | String | Work item revisions reference link. | |
| LinksWorkItemTypeHref | String | Work item type reference link. | |
| LinksWorkItemUpdatesHref | String | Work item updates reference link. | |
| Rev | Integer | Revision number of the work item. | |
| Url | String | Full HTTP link URL . |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| AsOf | Datetime | AsOf UTC date time string. | |
| ErrorPolicy | String | The flag to control error policy in a bulk get work items request.
使用できる値は次のとおりです。fail, omit | |
| Expand | String | The expand parameters for work item attributes.
使用できる値は次のとおりです。all, fields, links, none, relations |