TestAttachments
Retrieves a list of test result or run Attachments.
Table Specific Information
Select
The provider 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 provider.
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. |