TestAttachments
Retrieves a list of test result or run Attachments.
Table Specific Information
Select
The adapter uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
The rest of the filter is executed client-side in the adapter.
NOTE: TestRunId is required in order to query TestAttachments.
- Id supports the '=,in' operators.
- TestRunId supports the '=' operator.
- TestResultId supports the '=' operator.
SELECT * FROM TestAttachments WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND TestRunId = 6 AND Id IN (1, 2, 3) SELECT * FROM TestAttachments WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND TestRunId = 6 AND TestResultId = 100000
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | Id of the test attachment. | |
| ProjectId | String | Id of the project. | |
| TestRunId [KEY] | Integer |
TestRuns.Id | Id of the test run. |
| TestResultId | Integer |
TestResults.Id | Id of the test result. |
| AttachmentType | String | Attachment type. | |
| Comment | String | Comment associated with attachment. | |
| CreatedDate | Datetime | Attachment created date. | |
| FileName | String | The File name of the attachment. | |
| Size | Integer | Attachment size. | |
| Url | String | Attachment URL. |