TestConfigurations
Retrieves a list test configurations.
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 TestConfigurations WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' SELECT * FROM TestConfigurations WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND Id = 7
Insert
The following is an example of inserting into a TestConfigurations table:
INSERT INTO TestConfigurations (ProjectId, Name) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 'cdata')
Update
The following is an example of updating a TestConfigurations table:
UPDATE TestConfigurations SET Name = 'cdata2' WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id = '1'
Delete
The following is an example of deleting data in a TestConfigurations table:
DELETE FROM TestConfigurations WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id = '1'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Integer | True |
Id of the Test Configuration. | |
ProjectId | String | True |
Id of the Project. | |
ProjectName | String | True |
Name of the Project. | |
Description | String | False |
Description of the test configuration. | |
IsDefault | Boolean | False |
Is the configuration a default for the test plans. | |
Name | String | False |
Name of the configuration. | |
State | String | False |
State of the configuration. | |
Values | String | False |
Dictionary of Test Variable, Selected Value. |