PullRequestAttachments
Retrieves a list of attachments for the specific pull request, sliced across all repositories.
Table Specific Information
Select
The add-in 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 add-in.
- PullRequestId supports the '=' operator.
- RepositoryId supports the '=' operator.
SELECT * FROM PullRequestAttachments WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND RepositoryId = '123e04e0-6c4c-4675-8636-af6b0bc29d43' AND PullRequestId = 4
Columns
| Name | Type | References | Description |
| Id | Integer | Id of the attachment. | |
| ProjectId | String | Id of the project. | |
| RepositoryId | String | Id of the repository. | |
| PullRequestId | Integer |
PullRequests.Id | Id of the pull request. |
| AuthorDisplayName | String | The non-unique display name of the author. | |
| AuthorId | String | Id of the author. | |
| AuthorUrl | String | The URL of the author. | |
| ContentHash | String | Content hash of on-disk representation of file content. Its calculated by the server by using SHA1 hash function. | |
| CreatedDate | Datetime | The time the attachment was uploaded. | |
| Description | String | The description of the attachment. | |
| DisplayName | String | The display name of the attachment. | |
| Properties | String | Properties of the attachments. | |
| Url | String | The URL to download the content of the attachment. |