Retrieves the permissions for the specific feed.

Table Specific Information

Select

The connector uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

• ProjectId supports the '=' operator.
• FeedId supports the '=' operator.
• ExcludeInheritedPermissions supports the '=' operator.
• IncludeIds supports the '=' operator.

The rest of the filter is executed client-side in the connector.

NOTE: FeedId is required in order to query FeedPermissions.

For example:

    SELECT * FROM FeedPermissions WHERE FeedId = 'e14f9853-4830-4f04-9561-c551254a32c9'

Columns

Name	Type	References	Description
FeedId	String	Feeds.Id	Id of the feed.
ProjectId	String		Id of the project.
DisplayName	String		Display name for the identity.
IdentityDescriptorIdentifier	String		The unique identifier for this identity.
IdentityDescriptorType	String		Type of descriptor.
IdentityId	String		Id of the identity associated with this role.
IsInheritedRole	Boolean		Indicates whether the role is inherited.
Role	String		The role for this identity on a feed.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。 特に指定がない限り、擬似カラムでフィルタリングを行う場合は = 演算子のみ使用できます。

Name	Type	Description
ExcludeInheritedPermissions	Boolean		True to only return explicitly set permissions on the feed. Default is false.
IncludeIds	Boolean		True to include user Ids in the response. Default is false.