SQL examples for ODBC
The following SQL examples demonstrate common use cases for this connector. Select a scenario below to view the query syntax and parameters required to interact with Azure DevOps.
- Add link to existing work item (attachment as reference)
- Add tags to an existing work item
- Create project
- Create team (default project)
- Create team in a project
- Create work item (default project)
- Create work item comment
- Create work item in a project
- Create work item with many fields
- Delete project by ID
- Delete team by ID
- Delete work item by ID
- Delete work item comment by ID
- Delete work items by WIQL query
- Get comment by ID for a work item
- Get project by ID
- Get team by ID
- Get work item by ID
- Get work item by ID (fail on 404)
- Get work items by IDs (comma-separated)
- Get work items by predefined query ID
- List all work item comments
- List audit records
- List audit records (specific columns)
- List comments for a work item
- List predefined queries
- List projects
- List projects (specific columns)
- List teams (default project)
- List teams (specific columns)
- List teams for a project
- List work items (default project)
- List work items for a project
- List work items with ParentId
- Query sprint hours by team member (estimated vs completed)
- Query work item comments using WIQL
- Query work items by type (e.g. Task)
- Query work items by WIQL (filters and date range)
- Query work items by WIQL in a project
- Query work items modified after a date (dynamic)
- Query work items using WIQL
- Query work items using WIQL (#DirectSQL)
- Read more than 20000 work items (UNION ALL)
- Search work items by text
- Update project by ID
- Update readonly fields (e.g. ClosedBy, ResolvedBy)
- Update team by ID
- Update work item by ID (basic fields)
- Update work item by ID (many columns)
- Update work item comment
- Update work items by WIQL query
- Upload file (attachment)