TestSubResults
Retrieves sub results for the test result.
Table Specific Information
Select
The connector 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 connector.
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. |