team_workload
Assess team workload: report open tasks per assignee, flag overloaded members and unassigned work, and receive a rule-based verdict on project health.
Instructions
Report who is over- or under-loaded, in one call.
Composes the open project.task records in scope into a per-assignee load (open count plus overdue / due-soon / high-priority / no-deadline tallies), flags overloaded members and unassigned work, and returns a rule-based verdict. Done tasks carry no current load and are excluded.
Args: project: Optional project-name filter (ilike). sprint_id: Optional sprint filter (project.task sprint_id). exclude_stages: Stage names dropped from scope. Default ["Cancelled"]. done_stages: Stage names treated as completed. Default ["Done", "Delivered"]. lookahead_days: Days ahead that count as "due soon" (default 7). overload_threshold: Open-task count above which a member is flagged "overloaded" (default 8). Sign-off point with the workflow owner. timezone_offset: UTC offset for "today" (default 7 = Asia/Ho_Chi_Minh). subtasks_only: Count only subtasks (parent_id != False), the team's unit of work. Default True.
Note: sprint_id is a custom field, not standard Odoo; the tool degrades with a clear error when absent.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| project | No | ||
| sprint_id | No | ||
| done_stages | No | ||
| subtasks_only | No | ||
| exclude_stages | No | ||
| lookahead_days | No | ||
| timezone_offset | No | ||
| overload_threshold | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |