TestRuns
Retrieves a list of test runs.
Table Specific Information
Select
The connector 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 connector.
- 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 the TestRuns table:
INSERT INTO TestRuns (ProjectId, Name) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 'Shubham')
Update
The following is an example of updating the TestRuns table:
UPDATE TestRuns SET Name = 'cdata2' WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id = 1
Delete
The following is an example of deleting from the TestRuns table:
DELETE FROM TestRuns WHERE Id = 360866
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. |