TestConfigurations

Retrieves a list test configurations.

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.

The rest of the filter is executed client-side in the connector.

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.