TestRuns
Retrieves a list of test runs.
Table Specific Information
Select
The provider uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
The rest of the filter is executed client-side in the provider.
- ProjectId supports the '=' operator.
- IsAutomated supports the '=' operator.
- OwnerId supports the '=' operator.
- PlanId supports the '=' operator.
- RunId supports the '=' operator.
- BuildUri supports the '=' operator.
- IncludeRunDetails supports the '=' operator.
- TmiRunId supports the '=' operator.
SELECT * FROM TestRuns WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' SELECT * FROM TestRuns WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND Id = 6 SELECT * FROM TestRuns WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND IncludeRunDetails = true
Insert
The following is an example of inserting into an Earnings table:
INSERT INTO TestRuns (ProjectId, Name) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 'Shubham')
Update
The following is an example of updating a TestRuns table:
UPDATE TestRuns SET Name = 'cdata2' WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id = '1'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Integer | True |
Id of the Test Run. | |
BuildId | String | False |
Builds.Id |
Id of the build associated with this test run. |
BuildName | String | False |
Name of the build associated with this test run. | |
BuildUrl | String | False |
Url of the build associated with this test run. | |
Comment | String | False |
Comments entered by those analyzing the run. | |
CompletedDate | Datetime | False |
Completed date time of the run. | |
Controller | String | False |
Test Run Controller. | |
CreatedDate | Datetime | True |
Test Run CreatedDate. | |
DropLocation | String | False |
Drop Location for the test run. | |
DueDate | Datetime | False |
Due date and time for test run. | |
ErrorMessage | String | False |
Error message associated with the run. | |
IncompleteTests | Integer | True |
Number of Incomplete Tests. | |
IsAutomated | Boolean | False |
True if test run is automated, false otherwise. | |
Iteration | String | False |
The iteration to which the run belongs. | |
LastUpdatedByDisplayName | String | True |
The non-unique display name of the user who last updated this test run. | |
LastUpdatedById | String | True |
The Id of the user who last updated this test run. | |
LastUpdatedByUrl | String | True |
The Url of the user who last updated this test run. | |
LastUpdatedDate | Datetime | True |
Last updated date and time. | |
Name | String | False |
Name of the Test run. | |
NotApplicableTests | Integer | True |
Number of Not Applicable Tests. | |
OwnerDisplayName | String | False |
The non-unique display name of the owner. | |
OwnerId | String | False |
The Id of the owner. | |
OwnerUrl | String | False |
The URL of the owner. | |
PassedTests | Integer | True |
Number of passed tests in the run. | |
Phase | String | True |
Phase/State for the test run | |
PlanId | String | False |
TestPlans.Id |
Id of the test plan associated with this test run. |
PlanName | String | False |
Name of the test plan. | |
PlanUrl | String | False |
URL of the test plan. | |
PostProcessState | String | True |
Post Process State. | |
ProjectId | String | True |
Id of the Project associated with this test run. | |
ProjectName | String | True |
Name of the Project. | |
ProjectUrl | String | True |
URL of the Project. | |
ReleaseId | String | True |
Releases.Id |
Id of the Release. |
ReleaseEnvironmentUri | String | True |
Release Environment URI for test run. | |
ReleaseUri | String | False |
Release Uri for test run. | |
Revision | Integer | True |
Test run Revision. | |
StartedDate | Datetime | False |
Start date time of the run. | |
State | String | False |
The state of the run. | |
SubState | String | True |
Test run Substate. | |
Tags | String | False |
Tags attached with this test run. | |
TestEnvironmentId | String | False |
Id of the Test Environment associated with this test run. | |
TestEnvironmentName | String | True |
Name of the Test Environment associated with this test run. | |
TestMessageLogId | Integer | True |
Test Message Log Id. | |
TestSettingsId | String | False |
Id of the Test Settings. | |
TestSettingsName | String | False |
Name of the Test Settings. | |
TestSettingsUrl | String | False |
Url of the Test Settings. | |
TotalTests | Integer | True |
Total tests in the run. | |
UnanalyzedTests | Integer | True |
Number of failed tests in the run. | |
Url | String | True |
Url of the test run. | |
WebAccessUrl | String | True |
Web Access Url for test run. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements, and offer a more granular control over the tuples that are returned from the data source. Unless otherwise specified, only the = operator is permitted when filtering on pseudocolumns.
Name | Type | Description |
BuildUri | String |
URI of the build that the runs used. |
IncludeRunDetails | Boolean |
If true, include all the properties of the runs. |
TmiRunId | String |
Tmi Run Id. |