Projects

List Projects

Table Specific Information

Select

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

Id supports the '=' operator.
State supports the '=' operator.
GetDefaultTeamImageUrl supports the '=' operator.
IncludeCapabilities supports the '=' operator.

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

For example:

	SELECT * FROM Projects WHERE State = 'wellFormed'
	SELECT * FROM Projects WHERE GetDefaultTeamImageUrl = false
	SELECT * FROM Projects WHERE Id = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf'
	SELECT * FROM Projects WHERE Id = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND IncludeCapabilities = true

Insert

The following is an example of inserting into a Projects table:

INSERT INTO Projects (Name, Description, Visibility, CapabilitiesVersionControlType, CapabilitiesProcessTemplateTypeId) VALUES ('TestProject', 'This is a test', 'private', 'Git', '6b724908-ef14-45cf')

Update

The following is an example of updating a Projects table:

UPDATE Projects SET Name = 'System.MSPROJ' WHERE Id = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937'

Delete

The following is an example of deleting data in a Projects table:

DELETE FROM Projects WHERE Id = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937'

Columns


Name	Type	References	Description
ParentReference	String
ProjectSK [KEY]	String
ProjectId	String
ProjectName	String
ProjectVisibility	String