Tasks
Retrieves tasks in a task group.
Table Specific Information
Select
The connector uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
- TaskGroupId supports the '=' operator.
- ProjectId supports the '=' operator.
NOTE: TaskGroupId is required in order to query TaskGroupSourceDefinitions.
For example:
SELECT * FROM Tasks WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073' AND TaskGroupId = 7
Columns
Name | Type | References | Description |
ProjectId | String | Id of the project. | |
TaskGroupId [KEY] | String |
TaskGroups.Id | Id of the task group. |
AlwaysRun | Boolean | Indicates whether to run the task always. | |
Condition | String | Condition for the task. | |
ContinueOnError | Boolean | Indicates whether to continue on error or not. | |
DisplayName | String | The display name of the task. | |
Enabled | Boolean | Indicates whether task is enabled or not. | |
Environment | String | Dictionary of environment variables. | |
Inputs | String | Dictionary of inputs. | |
TaskDefinitionType | String | The definition type. | |
TaskId | String | The unique identifier of task. | |
TaskVersionSpec | String | The version specification of the task. | |
TimeoutInMinutes | Integer | The maximum time in minutes, that a task is allowed to execute on agent before being cancelled by server. |