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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。 特に指定がない限り、擬似カラムでフィルタリングを行う場合は = 演算子のみ使用できます。
| Name | Type | Description | |
| IncludeActionResults | Boolean | Indicates whether to include result details for each action performed in the test iteration. |