ODBC Driver for Azure DevOps

Build 22.0.8479


Retrieves a list of task groups.

Table Specific Information


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

  • Id supports the '=' operator.
  • ProjectId supports the '=' operator.
  • Deleted supports the '=' operator.
  • Mine supports the '=' operator.
  • Expanded supports the '=' operator.
  • TaskId supports the '=' operator.

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

For example:

	SELECT * FROM TaskGroups WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073'


The following are examples of inserting into a TaskGroups table:

INSERT INTO TaskGroups (ProjectId, Name) VALUES ('c831d3b4-a289-462f', 'TestTaskGroup')

Using aggregate columns:

INSERT INTO TaskGroupinputs#TEMP (Name,Aliases) VALUES (test1,Cdata1)
INSERT INTO TaskGroupinputs#TEMP (Name,Aliases) VALUES (test,Cdata)
INSERT INTO TaskGroups (ProjectId,Name,TaskGroupinputs) VALUES ('1db52c22-a4e9-4ddc-ba82-5c0ae281dfd2','demoTaskGroup',TaskGroupinputs#TEMP)


The following is an example of updating a TaskGroups table:

UPDATE TaskGroups SET Name = 'cdata2' WHERE Id = '7afcae8b-7c47-47c3-b801-2443129a205f' AND ProjectId = '1db52c22-a4e9-4ddc-ba82-5c0ae281dfd2'


The following is an example of deleting data in a TaskGroups table:

DELETE FROM TaskGroups WHERE Id = '7afcae8b-7c47-47c3-b801-2443129a205f' AND ProjectId = '1db52c22-a4e9-4ddc-ba82-5c0ae281dfd2'


Name Type ReadOnly References Description
Id [KEY] String True

Id of the task group.

ProjectId String True


Id of the project.

Author String False

Author of the group.

Category String False

Category of the task group.

Comment String True


ContentsUploaded Boolean True

Indicates whether content is uploaded or not.

ContributionIdentifier String True

Identifier of the the contribution.

ContributionVersion String True

Version of the contribution.

CreatedByDisplayName String True

The display name of the user .

CreatedById String True

The Id of the user who created this task group.

CreatedByUniqueName String True

The Unique name of the user.

CreatedOn Datetime True

The timestamp at which the group was created.

DefinitionType String True

Type of the definition.

Deleted Boolean True

Indicates whether this is a deleted task group.

Demands String True

Task group demands.

Deprecated Boolean True

Indicates whether this is deprecated group.

Description String False

Description of the task group.

Disabled Boolean True

Indicates whether this task group is disabled or not.

Execution String True

Execution details of the tasks.

FriendlyName String False

Friendly name of the task group.

Groups String True

Groups definition.

HelpMarkDown String True

Help mark down.

HelpUrl String True

The help URL.

HostType String True

The host type.

IconUrl String False

The URL of the icon.

InstanceNameFormat String False

Format of the instance name.

MinimumAgentVersion String True

Minimum version of the task agent.

ModifiedByDisplayName String True

The non-unique display name of the user who modified this task group.

ModifiedById String True

The Id of the user.

ModifiedByUniqueName String True

The unique name of the user.

ModifiedOn Datetime True

The timestamp at which this task group was modified.

Name String False

Name of the task group.

OutputVariables String True

Details of the task output variables.

Owner String True

Owner of the task group.

PackageLocation String True

Package location of the task group.

PackageType String True

Type of the package.

ParentDefinitionId String False

Parent task group id.

PostJobExecution String True

Post job execution details.

PreJobExecution String True

Pre job execution details.

Preview Boolean True

Indicates whether its a preview or not.

ReleaseNotes String True

Release notes.

Revision Integer True

Revision of the task group.

RunsOn String False

Runs On.

Satisfies String True


ServerOwned Boolean True

Server owned.

ShowEnvironmentVariables Boolean True

Indicates whether to show the environment variables or not.

SourceLocation String True

Location of the source.

VersionIsTest Boolean False

Indicates whether its a test version.

VersionMajor Integer False

Major version .

VersionMinor Integer False

Minor version.

VersionPatch Integer False

Patch version.

Visibility String True

Task group visibility.


SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
Expanded Boolean

Returns task groups recursively, if set to true.

TaskId String

GUID of the taskId to filter.

TaskGroupInputs String

List of inputs for the specific task group.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479