QueryClauses
Retrieves clauses for the specific query.
Table Specific Information
Select
The connector 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.
- ClauseType supports the '=' operator.
The rest of the filter is executed client-side in the connector.
NOTE: QueryId is required in order to query QueryClauses.
For example:
SELECT * FROM QueryClauses WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073' AND QueryId = '40314330-b454-41fd-9514-e6be6096bd0b' SELECT * FROM QueryClauses WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073' AND QueryId = '40314330-b454-41fd-9514-e6be6096bd0b' AND ClauseType = 'sourceClauses'
Columns
| Name | Type | References | Description |
| ProjectId | String | Id of the project. | |
| QueryId | String |
Queries.Id | Id of the query. |
| FieldName | String | Friendly name of the field. | |
| FieldReferenceName | String | Reference name of the field. | |
| LogicalOperator | String | Logical operator separating the condition clause. | |
| OperatorName | String | Friendly name of the operation. | |
| OperatorReferenceName | String | Reference name of the operation. | |
| Value | String | Right side of the condition when a field to value comparison. | |
| ClauseType | String | Type of the clause to retrieve.
使用できる値は次のとおりです。clauses, sourceClauses, targetClauses, linkClauses |