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