SSIS Components for Azure DevOps

Build 24.0.9063

WorkItemRevisionFields

Retrieves a list of work item revision fields

Table Specific Information

Select

The 本製品 uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

  • ProjectId supports the '=' operator.
  • ChangesetId supports the '=' operator.
  • Author supports the '=' operator.
  • FromDate supports the '=' operator.
  • ToDate supports the '=' operator.
  • AsOf supports the '=' operator.
  • Id supports the '=' operator.

The rest of the filter is executed client-side in the 本製品.

For example:

	SELECT * FROM WorkItemRevisionFields WHERE ProjectId = '837ccd31'

    SELECT * FROM WorkItemRevisionFields WHERE Id = '837ccd31'

Columns

Name Type References Description
Id [KEY] Integer Id of the work item.
Revision [KEY] Integer Revision of the work item.
FieldName String Field Key for the work item revision.
FieldValue String Field Value for the work item revision.
ProjectId String Id of the project this changeset belongs to.

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

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