FireDAC Components for Azure DevOps

Build 21.0.7930

Queries

Retrieves the root queries and their children.

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.

  • Id supports the '=' operator.
  • ProjectId supports the '=' operator.
  • Depth supports the '=' operator.
  • Expand supports the '=' operator.
  • IncludeDeleted supports the '=' operator.
For example:
	
	SELECT * FROM Queries WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073'
	SELECT * FROM QueryClauses WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073' AND Id = '40314330-b454-41fd-9514-e6be6096bd0b'
	SELECT * FROM QueryClauses WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073' AND Id = '40314330-b454-41fd-9514-e6be6096bd0b' AND Expand = 'wiql'
	SELECT * FROM QueryClauses WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073' AND Id = '40314330-b454-41fd-9514-e6be6096bd0b' AND Depth = 2

Columns

Name Type References Description
Id [KEY] String Id of the query.
ProjectId String

Projects.Id

Id of the project.
CreatedById String The Id of the user.
CreatedByName String The name of the user.
CreatedByUrl String The URL of the user.
CreatedDate Datetime When the query item was created.
FilterOptions String The link query mode.
HasChildren Boolean If this is a query folder, indicates if it contains any children.
IsDeleted Boolean Indicates if this query item is deleted.
IsFolder Boolean Indicates if this is a query folder or a query.
IsInvalidSyntax Boolean Indicates if the WIQL of this query is invalid.
IsPublic Boolean Indicates if this query item is public or private.
LastExecutedById String The Id of the user.
LastExecutedByName String The unique name of the user.
LastExecutedByUrl String The URL of the user.
LastExecutedDate Datetime When the query was last run.
LastModifiedById String The Id of the user.
LastModifiedByName String The unique name of the user.
LastModifiedByUrl String The URL of the user.
LastModifiedDate Datetime When the query item was last modified.
LinksHtmlHref String Reference links.
LinksSelfHref String Reference links.
Name String The name of the query item.
Path String The path of the query item.
QueryRecursionOption String The recursion option for use in a tree query.
QueryType String The type of query.
Url String The URL of the query Item.
Wiql String The WIQL text of the query.

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
Depth Integer In the folder of queries, return the children queries or folders at this depth.

The allowed values are 1, 2.

Expand Boolean Include the query string (WIQL).

The allowed values are minimal, none, wiql.

IncludeDeleted Boolean Include deleted queries and folders.

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