FireDAC Components for Azure DevOps

Build 21.0.7930

VariableGroups

Retrieves a list of variable groups.

Table Specific Information

Select

The component will use the Azure DevOps API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the component.

  • ProjectId supports the '=' operator.
  • Id supports the '=,in' operators.
  • Name supports the '=' operator.
  • Action supports the '=' operator.
For example:
	SELECT * FROM VariableGroups WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4'	
	SELECT * FROM VariableGroups WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND Id IN (1, 2, 3)

Columns

Name Type References Description
Id [KEY] Integer Id of the variable group.
ProjectId String

Projects.Id

Id of the project.
CreatedByDisplayName String The display name of the user who created this variable group.
CreatedById String The Id of the user who created this variable group.
CreatedByImageUrl String The Image URL of the user who created this variable group.
CreatedByUniqueName String The Unique name of the user who created this variable group.
CreatedByUrl String The URL od the user who created this variable group.
CreatedOn Datetime The time when variable group was created.
Description String Description of the variable group.
IsShared Boolean Indicates whether variable group is shared with other projects or not.
ModifiedByDisplayName String The display name of the user who modified this variable group.
ModifiedById String The Id of the user who modified this variable group.
ModifiedByImageUrl String The Image URL of the user who modified this variable group.
ModifiedByUniqueName String The Unique Name of the user who modified this variable group.
ModifiedByUrl String The URL of the user who modified this variable group.
ModifiedOn Datetime The time when variable group was modified.
Name String Name of the variable group.
ProviderData String Provider data.
Type String Type of the variable group.
Variables String Variables contained in the variable group.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Action String Specifies the action which can be performed on the variable groups.

The allowed values are manage, none, use.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930