FeedUpstreamSources
Retrieves a list of upstream sources for the specific feed.
Table Specific Information
Select
The 本製品 uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
- FeedId supports the '=' operator.
- ProjectId supports the '=' operator.
- IncludeDeletedUpstreams supports the '=' operator.
NOTE: FeedId is required in order to query FeedUpstreamSources.
For example:
SELECT * FROM FeedUpstreamSources WHERE FeedId = 'e14f9853-4830-4f04-9561-c551254a32c9' SELECT * FROM FeedUpstreamSources WHERE FeedId = 'e14f9853-4830-4f04-9561-c551254a32c9' AND IncludeDeletedUpstreams = true
Columns
Name | Type | References | Description |
Id [KEY] | String | Id of the feed upstream source. | |
FeedId | String |
Feeds.Id | Id of the feed. |
ProjectId | String | Id of the project. | |
DeletedDate | Datetime | UTC date that this upstream was deleted. | |
DisplayLocation | String | Locator for connecting to the upstream source in a user friendly format, that may potentially change over time. | |
Location | String | Consistent locator for connecting to the upstream source. | |
Name | String | Display name. | |
Protocol | String | Package type associated with the upstream source. | |
Status | String | Status of the Upstream source. | |
UpstreamSourceType | String | Source type, such as Public or Internal. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。 特に指定がない限り、擬似カラムでフィルタリングを行う場合は = 演算子のみ使用できます。
Name | Type | Description | |
IncludeDeletedUpstreams | Boolean | Include upstreams that have been deleted in the response. |