TfvcChangesets
Retrieves Tfvc Changesets.
Table Specific Information
Select
The connector 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.
- FromId supports the '=' operator.
- ToId supports the '=' operator.
The rest of the filter is executed client-side in the connector.
For example:
SELECT * FROM TfvcChangesets WHERE ProjectId = '837ccd31'
SELECT * FROM TfvcChangesets WHERE ChangesetId = '837ccd31'
SELECT * FROM TfvcChangesets WHERE ToDate = '07/03/2021 12:00:00'
Columns
| Name | Type | References | Description |
| ChangesetId | Integer | Changeset Id. | |
| Url | String | URL to retrieve the item. | |
| Links | String | A collection of REST reference links. | |
| AuthorId | String | The Id of the author. | |
| AuthorDisplayName | String | The non-unique display name of the author. | |
| AuthorUrl | String | The Full HTTP URL of the author. | |
| CheckedInById | String | The id of the user who has checked in. | |
| CheckedInByDisplayName | String | The non-unique display name of the user who has checked in. | |
| CheckedInByUrl | String | The Full HTTP URL of the user who has checked in. | |
| CreatedDate | Datetime | Creation date of the changeset. | |
| Comment | String | Comment for the changeset. | |
| CommentTruncated | Boolean | Indicates if the Comment result is truncated or not. | |
| ProjectId | String | Id of the project this changeset belongs to. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。 特に指定がない限り、擬似カラムでフィルタリングを行う場合は = 演算子のみ使用できます。
| Name | Type | Description | |
| MaxCommentLength | Integer | Include details about associated work items in the response. | |
| Author | String | Alias or display name of user who made the changes. | |
| FollowRenames | Boolean | Whether or not to follow renames for the given item being queried. | |
| FromId | Integer | If provided, only include changesets after this changesetID. | |
| IncludeLinks | Boolean | Whether to include the _links field on the shallow references. | |
| ItemPath | String | Path of item to search under. | |
| ToId | Integer | If provided, a version descriptor for the latest change list to include. |