TestResults
Retrieves test results for a test run.
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.
- TestRunId supports the '=' operator.
- Outcome supports the '=' operator.
The rest of the filter is executed client-side in the connector.
NOTE: TestRunId is required in order to query TestResults.
For example:
SELECT * FROM TestResults WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND TestRunId = 6
Insert
The following are examples of inserting into a TestResults table:
INSERT INTO TestResults#TEMP (ProjectId, TestRunId, Comment, OwnerName) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 1, 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 'abcd')
INSERT INTO TestResults#TEMP (ProjectId, TestRunId, Comment, OwnerName) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 2, 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 'xyz')
INSERT INTO TestResults (ProjectId, TestRunId, Comment, OwnerName) SELECT ProjectId, TestRunId, Comment, OwnerName FROM TestResults#TEMP
INSERT INTO TestResults (ProjectId, TestRunId, TestCaseTitle, AutomatedTestName, Priority, Outcome) VALUES ('c831d3b4-a289-462f', 1, 'NewTestCase', 'TestProject.TestElement.TestClass.NewTestCase', 1, 'Passed')
Update
The following are examples of updating a TestResults table:
INSERT INTO TestResults#TEMP (ProjectId, TestRunId, Id, Comment, OwnerName) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 1, '1', 'hello@1234', 'abcd')
INSERT INTO TestResults#TEMP (ProjectId, TestRunId, Id, Comment, OwnerName) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 1, '2', 'hello@123t', 'xyz')
UPDATE TestResults (ProjectId, TestRunId, Id, Comment, OwnerName) SELECT ProjectId, TestRunId, Id, Comment, OwnerName FROM TestResults#TEMP
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | False |
Id of the Test Result. | |
| AfnStripId | Integer | False |
Test Attachment Id of action recording. | |
| AreaId | String | False |
Id of the Area Path Of Test. | |
| AreaName | String | False |
Name of the Area Path of Test. | |
| AreaUrl | String | False |
URL of the Area Path of Test. | |
| AssociatedBugs | String | False |
Reference to bugs linked to test result. | |
| AutomatedTestId | String | False |
ID representing test method in a dll. | |
| AutomatedTestName | String | False |
Fully qualified name of test executed. | |
| AutomatedTestStorage | String | False |
Container to which test belongs. | |
| AutomatedTestType | String | False |
Type of automated test. | |
| AutomatedTestTypeId | String | False |
TypeId of automated test. | |
| BuildId | String | False |
Builds.Id |
Id of the Build associated with this test result. |
| BuildName | String | False |
Name of the Build. | |
| BuildUrl | String | False |
URL of the Build. | |
| Comment | String | False |
Comment in a test result with maxSize= 1000 chars. | |
| CompletedDate | Datetime | False |
Time when test execution completed. | |
| ComputerName | String | False |
Machine name where test executed. | |
| ConfigurationId | String | False |
Id of the Test Configuration. | |
| ConfigurationName | String | False |
Name of the Test Configuration. | |
| ConfigurationUrl | String | False |
Url of the Test Configuration. | |
| CreatedDate | Datetime | False |
Timestamp when test result created. | |
| DurationInMs | Integer | False |
Duration of test execution in milliseconds. | |
| ErrorMessage | String | False |
Error message in test execution. | |
| FailingSinceBuildSystem | String | False |
Build System. | |
| FailingSinceBuildDefinitionId | Integer | False |
Build Definition Id since tests are failing. | |
| FailingSinceBuildId | Integer | False |
Build Id since tests are failing. | |
| FailingSinceBuildNumber | String | False |
Build Number. | |
| FailingSinceDate | Datetime | False |
Time since failing. | |
| FailingSinceReleaseId | Integer | False |
Release reference since failing. | |
| FailureType | String | False |
Failure type of test result. | |
| LastUpdatedByDisplayName | String | False |
The non-unique display name of the user who last updated this test result. | |
| LastUpdatedById | String | False |
The Id of the user who last updated this test result. | |
| LastUpdatedByUrl | String | False |
The URL of the user. | |
| LastUpdatedDate | Datetime | False |
Last updated datetime of test result. | |
| Outcome | String | False |
Test outcome of test result. | |
| OwnerId | String | False |
The Id of the owner of the test. | |
| OwnerName | String | False |
The name of the owner. | |
| OwnerUrl | String | False |
The URL of the Owner. | |
| Priority | Integer | False |
Priority of test executed. | |
| ProjectId | String | True |
Id of the Project. | |
| ProjectName | String | False |
Name of the Project. | |
| ProjectUrl | String | False |
URL of the Project. | |
| ReleaseId | Integer | False |
Id of the release associated with this result. | |
| ReleaseName | String | False |
Name of the release associated with this result. | |
| ReleaseUrl | String | False |
Url of the release associated with this result. | |
| ResetCount | Integer | False |
ResetCount. | |
| ResolutionState | String | False |
Resolution state of test result. | |
| ResolutionStateId | Integer | False |
ID of resolution state. | |
| ResultGroupType | String | False |
Hierarchy type of the result, default value of None means its leaf node. | |
| Revision | Integer | False |
Revision number of test resul. | |
| RunByDisplayName | String | False |
The non-unique display name of the user who executed the test. | |
| RunById | String | False |
The Id of the user who executed the test. | |
| RunByUrl | String | False |
The URL of the user who executed the test. | |
| StackTrace | String | False |
Stacktrace with maxSize= 1000 chars. | |
| StartedDate | Datetime | False |
Time when test execution started. | |
| State | String | False |
State of test result. | |
| TestCaseId | String | False |
TestCases.Id |
Id of the Test case executed. |
| TestCaseName | String | False |
Name of the Test case executed. | |
| TestCaseUrl | String | False |
Url of the Test case executed. | |
| TestCaseReferenceId | Integer | False |
Reference ID of test used by test result. | |
| TestCaseRevision | Integer | False |
TestCaseRevision Number. | |
| TestCaseTitle | String | False |
Name of test. | |
| TestPlanId | String | False |
TestPlans.Id |
Id of The Test Plan test case work item is part of. |
| TestPlanName | String | False |
Name of the Test Plan. | |
| TestPlanUrl | String | False |
Url of the Test Plan. | |
| TestPointId | String | False |
TestPoints.Id |
Id of the Test Point Executed. |
| TestPointName | String | False |
Name of the Test Point Executed. | |
| TestPointUrl | String | False |
Url of the Test Point Executed. | |
| TestRunId | String | True |
TestRuns.Id |
Id of the Test Run. |
| TestRunName | String | False |
Name of the Test Run. | |
| TestRunUrl | String | False |
Url of the Test Run. | |
| TestSuiteId | String | False |
TestSuites.Id |
Id of the Test Suite test case workitem is part of. |
| TestSuiteName | String | False |
Name of the Test Suite. | |
| TestSuiteUrl | String | False |
Url of the Test Suite. | |
| Url | String | False |
Url of the Test Result. |