ADO.NET Provider for Azure DevOps

Build 24.0.9060

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060