QueryColumns
Retrieves all columns for the specific query.
Table Specific Information
Select
The adapter 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 adapter.
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 | 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. |