azdo_query_work_items
Query Azure DevOps work items using filters like assignee, state, tags, dates, and board columns to find specific tasks and track project progress.
Instructions
Query work items by filters
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| area_path | No | Area path to filter by (e.g., "MyProject\\Team1"). Uses UNDER operator to include child paths. | |
| changed_date_from | No | Filter by changed date (from). Format: YYYY-MM-DD or YYYY-MM-DDTHH:MM:SSZ | |
| changed_date_to | No | Filter by changed date (to). Format: YYYY-MM-DD or YYYY-MM-DDTHH:MM:SSZ | |
| created_date_from | No | Filter by creation date (from). Format: YYYY-MM-DD or YYYY-MM-DDTHH:MM:SSZ | |
| created_date_to | No | Filter by creation date (to). Format: YYYY-MM-DD or YYYY-MM-DDTHH:MM:SSZ | |
| exclude_assigned_to | No | Assignees to exclude | |
| exclude_board_column | No | Board columns to exclude | |
| exclude_board_row | No | Board rows/swimlanes to exclude | |
| exclude_changed_by | No | Changed by users to exclude | |
| exclude_state | No | States to exclude (e.g., ["Closed", "Removed"]) | |
| exclude_tags | No | Tags to exclude (e.g., ["wontfix"]) | |
| exclude_work_item_type | No | Work item types to exclude | |
| include_assigned_to | No | Assignees to include (e.g., ["John Doe", "jane@example.com"]) | |
| include_board_column | No | Board columns to include (e.g., ["Active", "Resolved"]) | |
| include_board_row | No | Board rows/swimlanes to include (e.g., ["General", "Scraping Platform"]) | |
| include_changed_by | No | Changed by users to include (e.g., ["John Doe", "jane@example.com"]) | |
| include_latest_n_comments | No | Include the latest N comments (optional). Set to -1 for all comments. | |
| include_state | No | States to include (e.g., ["Active", "Resolved"]) | |
| include_tags | No | Tags to include (e.g., ["bug", "critical"]) | |
| include_work_item_type | No | Work item types to include (e.g., ["Bug", "User Story"]) | |
| iteration_path | No | Iteration path to filter by (e.g., "MyProject\\Sprint 1"). Uses UNDER operator to include child paths. | |
| organization | Yes | AzDO org name | |
| project | Yes | AzDO project name | |
| state_change_date_from | No | Filter by state change date (from). Format: YYYY-MM-DD or YYYY-MM-DDTHH:MM:SSZ | |
| state_change_date_to | No | Filter by state change date (to). Format: YYYY-MM-DD or YYYY-MM-DDTHH:MM:SSZ |