FireDAC Components for Azure DevOps

Build 21.0.7930


Retrieves a list of task groups.

Table Specific Information


The component will use the Azure DevOps API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the component.

  • Id supports the '=' operator.
  • ProjectId supports the '=' operator.
  • Deleted supports the '=' operator.
  • Mine supports the '=' operator.
  • Expanded supports the '=' operator.
  • TaskId supports the '=' operator.
For example:
	SELECT * FROM TaskGroups WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073'


Name Type References Description
Id [KEY] String Id of the task group.
ProjectId String


Id of the project.
Author String Author of the group.
Category String Category of the task group.
Comment String Comment.
ContentsUploaded Boolean Indicates whether content is uploaded or not.
ContributionIdentifier String Identifier of the the contribution.
ContributionVersion String Version of the contribution.
CreatedByDisplayName String The display name of the user .
CreatedById String The Id of the user who created this task group.
CreatedByUniqueName String The Unique name of the user.
CreatedOn Datetime The timestamp at which the group was created.
DefinitionType String Type of the definition.
Deleted Boolean Indicates whether this is a deleted task group.
Demands String Task group demands.
Deprecated Boolean Indicates whether this is deprecated group.
Description String Description of the task group.
Disabled Boolean Indicates whether this task group is disabled or not.
Execution String Execution details of the tasks.
FriendlyName String Friendly name of the task group.
Groups String Groups definition.
HelpMarkDown String Help mark down.
HelpUrl String The help URL.
HostType String The host type.
IconUrl String The URL of the icon.
InstanceNameFormat String Format of the instance name.
MinimumAgentVersion String Minimum version of the task agent.
ModifiedByDisplayName String The non-unique display name of the user who modified this task group.
ModifiedById String The Id of the user.
ModifiedByUniqueName String The unique name of the user.
ModifiedOn Datetime The timestamp at which this task group was modified.
Name String Name of the task group.
OutputVariables String Details of the task output variables.
Owner String Owner of the task group.
PackageLocation String Package location of the task group.
PackageType String Type of the package.
ParentDefinitionId String Parent task group id.
PostJobExecution String Post job execution details.
PreJobExecution String Pre job execution details.
Preview Boolean Indicates whether its a preview or not.
ReleaseNotes String Release notes.
Revision Integer Revision of the task group.
RunsOn String Runs On.
Satisfies String Satisfies.
ServerOwned Boolean Server owned.
ShowEnvironmentVariables Boolean Indicates whether to show the environment variables or not.
SourceLocation String Location of the source.
VersionIsTest Boolean Indicates whether its a test version.
VersionMajor Integer Major version .
VersionMinor Integer Minor version.
VersionPatch Integer Patch version.
Visibility String Task group visibility.


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.

Name Type Description
Expanded Boolean Returns task groups recursively, if set to true.
TaskId String GUID of the taskId to filter.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930