JDBC Driver for Azure DevOps

Build 24.0.9111

Environments

Retrieves environments.

Table Specific Information

Select

The 本製品 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 本製品.

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 build was last changed.

LastModifiedOn Datetime True

The date the build 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9111