ADO.NET Provider for Azure DevOps

Build 24.0.9060

TaskGroups

Retrieves a list of task groups.

Table Specific Information

Select

The provider 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 provider.

For example:

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

Insert

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)

Update

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'

Delete

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'

Columns

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

Comment.

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.

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.

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

Satisfies.

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.

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
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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060