TaskGroups
Retrieves a list of task groups.
Table Specific Information
Select
The connector 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 connector.
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. |