JDBC Driver for Azure DevOps

Build 22.0.8462

Queries

Retrieves the root queries and their children.

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.
  • ProjectId supports the '=' operator.
  • Depth supports the '=' operator.
  • Expand supports the '=' operator.
  • IncludeDeleted supports the '=' operator.

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

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

Insert

The following are examples of inserting into a Queries table:

INSERT INTO Queries (ProjectId,Id,Name,IsFolder) VALUES ('619e870e-5242-4218-bedd-c52d8c003591','2c2ad877-b460-4a6a-a323-a1c000035e2f',cdata11211, false)

Using aggregate columns:

INSERT INTO QueryColumns#TEMP (Name, referenceName) VALUES (test1, Cdata1)
INSERT INTO QueryColumns#TEMP (Name, referenceName) VALUES (test2, cdata11)
INSERT INTO Queries (ProjectId,ParentQueryId,Name,IsFolder,QueryColumns) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937','fa454167-0ba2-4fdf-8a27-7946ed80636d','Creating a new query object',true,QueryColumns#TEMP)

Update

The following is an example of updating a Queries table:

UPDATE Queries SET Name = 'cdata1' WHERE ProjectId = '1db52c22-a4e9-4ddc-ba82-5c0ae281dfd2' AND Id = 'fa454167-0ba2-4fdf-8a27-7946ed80636d'

Delete

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

DELETE FROM Queries WHERE ProjectId = '1db52c22-a4e9-4ddc-ba82-5c0ae281dfd2' AND Id = 'fa454167-0ba2-4fdf-8a27-7946ed80636d'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Id of the query.

ProjectId String True

Projects.Id

Id of the project.

CreatedById String False

The Id of the user.

CreatedByName String False

The name of the user.

CreatedByUrl String False

The URL of the user.

CreatedDate Datetime False

When the query item was created.

FilterOptions String False

The link query mode.

HasChildren Boolean False

If this is a query folder, indicates if it contains any children.

IsDeleted Boolean False

Indicates if this query item is deleted.

IsFolder Boolean False

Indicates if this is a query folder or a query.

IsInvalidSyntax Boolean False

Indicates if the WIQL of this query is invalid.

IsPublic Boolean False

Indicates if this query item is public or private.

LastExecutedById String False

The Id of the user.

LastExecutedByName String False

The unique name of the user.

LastExecutedByUrl String False

The URL of the user.

LastExecutedDate Datetime False

When the query was last run.

LastModifiedById String False

The Id of the user.

LastModifiedByName String False

The unique name of the user.

LastModifiedByUrl String False

The URL of the user.

LastModifiedDate Datetime False

When the query item was last modified.

LinksHtmlHref String True

Reference links.

LinksSelfHref String True

Reference links.

Name String False

The name of the query item.

Path String False

The path of the query item.

QueryRecursionOption String False

The recursion option for use in a tree query.

QueryType String False

The type of query.

Url String False

The URL of the query Item.

Wiql String False

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.

ParentQueryId String

The id of Parent Query item

QueryColumns String

The id of Parent Query item

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462