List 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:

• ProjectSK supports the '=,in' operator.

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

For example:

	SELECT * FROM Projects WHERE ProjectSK = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf'
	SELECT * FROM Projects WHERE ProjectSK IN ('837ccd31-8159-4db3-b8ce-de0c36d2a0bf', '837ccd31-8159-4db3-b8ce-de0c36d2a0hg')

Columns

Name	Type	References	Description
ParentReference	String		Parent reference. Only available if IncludeReferenceColumn=true.
ProjectSK [KEY]	String		Project surrogate key.
AnalyticsUpdatedDate	Datetime		Watermark that indicates the last time the Analytics data was updated.
ProjectId	String		Unique identifier assigned to a project when it's created.
ProjectName	String		Name assigned to a project when it's created.
ProjectVisibility	String		Indicates if the project is public or private.