ProjectProperties
Retrieves a collection of project properties, sliced across all projects.
Table Specific Information
Select
The add-in 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.
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. |