TestSubResults
Retrieves sub results for the test result.
Table Specific Information
Select
The add-in uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
- ProjectId supports the '=' operator.
- TestRunId supports the '=' operator.
- TestResultId supports the '=' operator.
The rest of the filter is executed client-side in the add-in.
NOTE: TestRunId and TestResultId are required in order to query TestResultIterationDetails.
For example:
SELECT * FROM TestSubResults WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND TestRunId = 6 AND TestResultId = 100001
Columns
| Name | Type | References | Description |
| Id | Integer | ID of test sub result. | |
| ProjectId | String | Id of the Project. | |
| TestRunId | Integer |
TestRuns.Id | Id of the Test Run. |
| TestResultId | Integer |
TestResults.Id | Id of the Test Result. |
| Comment | String | Comment in test sub result. | |
| CompletedDate | Datetime | Time when execution completed. | |
| ComputerName | String | Machine where test executed. | |
| ConfigurationId | String | Id of the Test Configuration. | |
| ConfigurationName | String | Name of the Test Configuration. | |
| ConfigurationUrl | String | Url of the Test Configuration. | |
| DisplayName | String | Name of sub result. | |
| DurationInMs | Integer | Duration of execution. | |
| ErrorMessage | String | Error message in test iteration result execution. | |
| LastUpdatedDate | Datetime | Last updated datetime of test result. | |
| Outcome | String | Test outcome if test iteration result. | |
| ParentId | Integer | Immediate parent ID of sub result. | |
| ResultGroupType | String | Hierarchy type of the result, default value of None means its leaf node. | |
| SequenceId | Integer | Index number of sub result. | |
| StackTrace | String | Stacktrace with maxSize= 1000 chars. | |
| StartedDate | Datetime | Time when test execution started. | |
| Url | String | Url to sub result. |