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