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