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

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.