TestResultIterationDetails
Retrieves iteration details 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.
- IncludeActionResults 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 TestResultIterationDetails WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND TestRunId = 6 AND TestResultId = 100001
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | ID of test iteration 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. |
| ActionResults | String | Test step results in an iteration. | |
| Comment | String | Comment in test iteration result. | |
| CompletedDate | Datetime | Time when execution completed. | |
| DurationInMs | Integer | Duration of execution. | |
| ErrorMessage | String | Error message in test iteration result execution. | |
| Outcome | String | Test outcome if test iteration result. | |
| Parameters | String | Test parameters in an iteration. | |
| StartedDate | Datetime | Time when execution started. | |
| Url | String | Url to test iteration result. |
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 | |
| IncludeActionResults | Boolean | Indicates whether to include result details for each action performed in the test iteration. |