JDBC Driver for Azure DevOps

Build 22.0.8462

QueryColumns

Retrieves all columns for the specific query.

Table Specific Information

Select

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

  • QueryId supports the '=' operator.
  • ProjectId supports the '=' operator.

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

NOTE: QueryId is required in order to query QueryColumns.

For example:

	SELECT * FROM QueryColumns WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073' AND QueryId = '40314330-b454-41fd-9514-e6be6096bd0b'

Columns

Name Type References Description
ProjectId String

Projects.Id

Id of the project.
QueryId String

Queries.Id

Id of the query.
Name String Friendly name of the column.
ReferenceName String Reference name of the column.
Url String The Url of the query column.

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