WorkItems

Retrieves a list of work items. This table includes custom fields which are automatically discovered when 'IncludeCustomFields' is enabled.

GetDeleted

The ProjectId and ChangedDate columns are filterable while retrieving deleted WorkItems:

GETDELETED FROM WorkItems WHERE Projectid = 'bl54d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND ChangedDate >= '2022-01-01'


Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		Id of the work item.
ProjectId	String	True		Id of the project.
Type	String	True		Type of the work item.
State	String	True		Current state of the work item.
CreatedDate	Datetime	True		Creation date of the work item.
CreatedById	String	True		User ID of work item creator.
CreatedByDisplayName	String	True		Display name of work item creator.
CreatedByUrl	String	True		Profile link of work item creator.
ChangedDate	Datetime	True		Date of last change to the work item.
ChangedById	String	True		User ID of most recent work item editor.
ChangedByDisplayName	String	True		Display name of most recent work item editor.
ChangedByUrl	String	True		Profile link of most recent work item editor.
AssignedToId	String	True		User ID of current work item assignee.
AssignedToDisplayName	String	True		Display name of current work item assignee.
AssignedToUrl	String	True		Profile link of current work item assignee.
Links	String	True		Aggregate of the reference links.
Rev	Integer	True		Revision number of the work item.
Url	String	True		Full HTTP link URL .

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