TfvcChangesets
Retrieves Tfvc Changesets.
Table Specific Information
Select
The provider 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 provider.
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
Pseudo column fields are used in the WHERE clause of SELECT statements, and offer a more granular control over the tuples that are returned from the data source. Unless otherwise specified, only the = operator is permitted when filtering on pseudocolumns.
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. |