Retrieves a collection of project properties, sliced across all projects.

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.
• Name supports the '=,in' operators.

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

For example:

	
	SELECT * FROM ProjectProperties WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf'
	SELECT * FROM ProjectProperties WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND Name IN ('System.Process Template', 'System.CurrentProcessTemplateId')

Columns

Name	Type	References	Description
ProjectId	String	Projects.Id	Unique Id of the project.
Name	String		The name of the property.
Value	String		The value of the property.