CData Python Connector for Azure DevOps

Build 24.0.9060

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

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.

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