Retrieves a list of test variables.

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 TestVariables WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073'

Insert

When performing an Insert, the following fields are required: Name

The following is an example of inserting into the TestVariables table:

INSERT INTO TestVariables (ProjectId, Name, Description) VALUES ('c831d3b4-a289-462f', 'SampleTestVariable', 'A sample test variable')

Update

The following is an example of updating the TestVariables table:

UPDATE TestVariables SET Description='myDesc' WHERE Id='34'

Delete

DELETEs are not supported for this table.

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.