Retrieves a list of policy configurations by a given set of scope or filtering criteria.

Table Specific Information

Select

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

• ProjectId supports the '=' operator.
• RepositoryId supports the '=' operator.
• TypeId supports the '=' operator.
• RefName supports the '=' operator.

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

For example:

    SELECT * FROM PolicyConfigurations WHERE RefName='refs/heads/main' 

Columns

Name	Type	References	Description
Id [KEY]	Integer		The policy configuration ID.
Links	String		The links to other objects related to this object.
CreatedByDescriptor	String		The descriptor of the identity that created the policy.
CreatedByDisplayName	String		The display name of the identity that created the policy.
CreatedById	String		The Id of the identity that created the policy.
CreatedByUrl	String		The URL of the identity that created the policy.
CreatedDate	Datetime		The date and time when the policy was created.
IsBlocking	Boolean		Indicates whether the policy is blocking.
IsDeleted	Boolean		Indicates whether the policy has been soft deleted.
IsEnabled	Boolean		Indicates whether the policy is enabled.
IsEnterpriseManaged	Boolean		If set, this policy requires Manage Enterprise Policies permission to create, edit, or delete.
ProjectId	String		Project ID or project name.
Revision	Integer		The policy configuration revision ID.
Settings	String		The policy configuration settings.
TypeDisplayName	String		The display name of the policy type.
TypeId	String		The policy type ID (UUID).
TypeUrl	String		The URL where the policy type can be retrieved.
Url	String		The URL where the policy configuration can be retrieved.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements, and offer a more granular control over the tuples that are returned from the data source. Unless otherwise specified, only the = operator is permitted when filtering on pseudocolumns.

Name	Type	Description
RepositoryId	String		The repository Id. When set, returns all policy configurations that apply to the repository.
RefName	String		The fully-qualified Git ref name (e.g. refs/heads/master). When set, returns all policy configurations that apply to the specific branch.