Retrieves environments.

Table Specific Information

Select

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

• Id supports the '=' operator.

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

For example:

SELECT * FROM Environments WHERE Id = 11

Insert

The Name, Description, and ProjectId can be inserted.

The following is an example of inserting into the Environments table:

INSERT INTO Environments (Name, Description, ProjectId) VALUES ('env2', 'inserted environment', '62d9f6e9-17ef-4cbf-833a-eb713c874df1')

Update

The Name and Description can be updated.

The following is an example of updating the Environments table:

UPDATE Environments SET Name='updatedEnv', Description='updated environment' WHERE Id = 11

Delete

The following is an example of deleting from the Environments table:

DELETE FROM Environments where Id = 11

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		Id of the environment.
ProjectId	String	False		Id of the project.
Name	String	False		Name of the environment.
Description	String	False		Environment description.
CreatedOn	Datetime	True		The date the environment was created.
LastModifiedOn	Datetime	True		The date the environment was last changed.
CreatedById	String	True		Id of the user who created the environment.
CreatedByName	String	True		Name of the user who created the environment.
LastModifiedById	String	True		Id of the user who last modified the environment.
LastModifiedByName	String	True		Name of the user who last modified the environment.