TestVariables
Retrieves a list of test variables.
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.
The rest of the filter is executed client-side in the provider.
For example:
SELECT * FROM TestVariables WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073'
Insert
The following is an example of inserting into a TestVariables table:INSERT INTO TestVariables (ProjectId, Name, Description) VALUES ('c831d3b4-a289-462f', 'SampleTestVariable', 'A sample test variable')
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Integer | True |
Id of the test variable. | |
Description | String | False |
Description of the variable. | |
ProjectId | String | True |
Id of the project. | |
ProjectName | String | True |
Name of the project. this field will be populated with a value only when the Id is specified. | |
Name | String | False |
Name of the test variable. | |
Values | String | False |
List of allowed variables. |