TestResultIterationDetails
Retrieves iteration details 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.
- IncludeActionResults 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 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. |