PullRequestAttachments
Retrieves a list of attachments for the specific pull request.
Table Specific Information
Select
The driver 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 driver.
NOTE: RepositoryId and PullRequestId is required in order to query PullRequestAttachments.
- PullRequestId supports the '=' operator.
- ProjectId supports the '=' operator.
- RepositoryId supports the '=' operator.
SELECT * FROM PullRequestAttachments WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND RepositoryId = '666e04e0-6c4c-4675-8636-af6b0bc29d43' AND PullRequestId = 4
Columns
| Name | Type | References | Description |
| Id | Integer | Id of the attachment. | |
| ProjectId | String |
Projects.Id | Id of the project. |
| RepositoryId | String |
Repositories.Id | 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. | |
| AuthorImageUrl | String | The image URL of the author. | |
| AuthorUniqueName | String | The unique name 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. |