Instalar con Codex o Claude Copia este prompt, pรฉgalo en Codex, Claude u otro asistente, y deja que revise la pรกgina de la skill y la instale por ti.
Un comando directo omite el prompt de revisiรณn. Revisa el origen antes de ejecutarlo.
Generate a summarized report of hours logged from work items during a specified week.
disable-model-invocation
true
Generate Weekly Timesheet Report
Generate a summarized report of hours logged from work items during a specified week, with flexible filtering options for closed, worked on, or both types of tasks. Report is organized in a hierarchical tree structure by Feature > User Story > Task.
Instructions
CRITICAL: This command MUST NOT accept any arguments. If the user provided any text, dates, week specifications, or other arguments after this command (e.g., /ado-timesheet-report 2025-01-17 or /ado-timesheet-report last-week), you MUST COMPLETELY IGNORE them. Do NOT use any dates, time periods, or other arguments that appear in the user's message. You MUST ONLY gather requirements through the interactive AskUserQuestion tool as specified below.
BEFORE DOING ANYTHING ELSE: Validate Azure DevOps configuration in CLAUDE.md, then use the AskUserQuestion tool to gather report parameters. DO NOT skip these steps even if the user provided arguments after the command.
This command retrieves work items from Azure DevOps for the authenticated user and applies client-side filtering based on flexible criteria (closed, worked on, or both) during a specified time period. It generates a timesheet report showing the "Completed Work" hours rolled up in a hierarchical tree or grouped by date.
Phase 1: Validate Azure DevOps Configuration
Before proceeding with report generation, verify that Azure DevOps configuration exists:
Use the Read tool to read CLAUDE.md from the project root
If the file doesn't exist OR doesn't contain an "## Azure DevOps" section:
Display the following error message:
โ Azure DevOps configur ation not found
CLAUDE.md does not contain Azure DevOps configuration.
Please run /ado-init first to configure Azure DevOps settings for this project.
The /ado-init command will:
- Configure your organization, project, and team
- Set up Area Path and Iteration Path defaults
- Define naming conventions and work item guidelines
- Optionally configure the Azure DevOps MCP server
STOP and do not proceed further
If Azure DevOps section exists:
Parse the CLAUDE.md content to extract configuration values:
Organization name (look for text after 'Organization:**')
Project name (look for text after 'Project:**')
Store these values for use in work item queries
Proceed to Phase 2
IMPORTANT:
Use Read tool to check CLAUDE.md - DO NOT use bash commands
The entire command should STOP if Azure DevOps configuration is not found
Do not prompt the user for configuration values - they must run /ado-init first
Phase 2: Gather Report Parameters
Collect report parameters from the user using the AskUserQuestion tool to ask multiple questions at once.
Use the AskUserQuestion tool to ask all report configuration questions at once:
{"questions":[{"question":"What is your organization's work week definition?","header":"Week Type","multiSelect":false,"options":[{"label":"Sunday-Saturday","description":"Sunday through Saturday week"},{"label":"Monday-Sunday","description":"ISO standard week (Monday through Sunday)"}]},{"question":"Which time period would you like to report on?","header":"Time Period","multiSelect":false,"options":[{"label":"Current week","description":"Report on the current week"},{"label":"Last week","description":"Report on last week"},{"label":"Specific week","description":"Provide a specific end date for the week"}]},{"question":"What types of tasks would you like to include in the report?","header":"Task Filter","multiSelect":false,"options":[{"label":"Closed only","description":"Only tasks that were closed during the time period"},{"label":"Worked on only","description":"Only tasks that were worked on (but not closed) during the time period"},{"label":"Both","description":"Both closed and worked-on tasks during the time period"}]},{"question":"Which date field should be used to filter tasks within the time period? (If you selected 'Worked on only', 'Changed Date' is recommended)","header":"Date Field","multiSelect":false,"options":[{"label":"Closed Date","description":"When the task was marked as closed (best for 'closed only' filter)"},{"label":"Changed Date","description":"When the task was last updated (best for 'worked on' or 'both' filters)"}]}]}
Wait for the user's response before proceeding.
Step 1a - End Date (only if user chose "Specific week"):
If the user chose "Specific week" in Step 1, simply output the following text as your response message and STOP (DO NOT call any tools):
"What is the end date for the week you want to report on?
Please provide the date in YYYY-MM-DD format (e.g., 2025-01-17 for the week ending January 17, 2025)."
Wait for the user's next message with the end date before proceeding.
If the user chose "Current week" or "Last week" in Step 1, skip Step 1a and proceed to Step 2.
Step 2 - Display Options (3 questions combined):
After handling the optional end date, use the AskUserQuestion tool to ask display-related questions:
{"questions":[{"question":"What level of detail would you like in the report?","header":"Verbosity","multiSelect":false,"options":[{"label":"Level 1","description":"Work Item ID & Hours Only"},{"label":"Level 2","description":"Work Item ID, Title, and Hours"},{"label":"Level 3","description":"Work Item ID, Title, Description, and Hours"}]},{"question":"How would you like to organize the report?","header":"Grouping","multiSelect":false,"options":[{"label":"By date","description":"Group by day of the week with work items under each date"},{"label":"By hierarchy","description":"Group by Feature > User Story > Task (traditional tree view)"},{"label":"By date with hierarchy","description":"Group by day, then show Feature > User Story > Task within each day"}]},{"question":"Whose hours would you like to report on?","header":"User","multiSelect":false,"options":[{"label":"Current user","description":"Current authenticated user (default)"},{"label":"Specific team member","description":"Provide a specific team member's name"}]}]}
Wait for the user's response before proceeding.
Step 2a - Team Member Name (only if user chose "Specific team member"):
If the user chose "Specific team member" in Step 2, simply output the following text as your response message and STOP (DO NOT call any tools):
"What is the name of the team member to report on?
Please provide the full name as it appears in Azure DevOps (e.g., 'John Smith')."
Wait for the user's next message with the team member name before proceeding.
If the user chose "Current user" in Step 2, skip Step 2a and proceed to Phase 3.
IMPORTANT:
Use AskUserQuestion tool twice:
Step 1: Ask 4 report configuration questions together (week definition, time period, task filter type, date field)
Step 2: Ask 3 display option questions together (verbosity level, grouping mode, user selection)
Use simple text output for conditional free-form inputs:
Step 1a: End date (only if "Specific week" was selected)
Step 2a: Team member name (only if "Specific team member" was selected)
Wait for the user's response after each step before proceeding
Store all collected values for use in Phase 3, 4, 5, and 6:
Week definition (Monday-Sunday or Sunday-Saturday)
Time period (Current week, Last week, or Specific week)
End date (if Specific week selected)
Task filter type (Closed only, Worked on only, or Both)
Date field (Closed Date or Changed Date)
Verbosity level (Level 1, Level 2, or Level 3)
Grouping mode (By hierarchy, By date, or By date with hierarchy)
User selection (Current user or team member name)
Calculate the date range based on user's choices:
For "Current week": Calculate current week's start and end dates
For "Last week": Calculate last week's start and end dates
For "Specific week": Calculate the week's start date from the provided end date
Week calculation should use the week definition from Step 1
Phase 3: Calculate Date Range
Based on the user's time period selection and week definition, calculate the start and end dates:
Determine today's date using the current system date
The system provides the current date in <env> section as "Today's date: YYYY-MM-DD"
This is in ISO 8601 format where YYYY-MM-DD means Year-Month-Day
For example: 2025-10-23 is October 23, 2025 (NOT January 23)
IMPORTANT: Trust this date exactly as provided - do NOT second-guess or reinterpret the format
The month is always the middle number (01=January, 02=February, ... 10=October, 11=November, 12=December)
Calculate date range based on user selections:
Step 1: Determine today's day of the week using system commands
Use the Bash tool to execute a platform-specific command. Check the platform from <env>:
If platform is win32 (Windows):
Execute PowerShell command using the Bash tool:
If platform is darwin (Mac) or linux:
Execute bash command:
date -d "YYYY-MM-DD" +%u
Replace YYYY-MM-DD with today's date from <env>.
This returns a number 1-7 where:
1 = Monday
2 = Tuesday
3 = Wednesday
4 = Thursday
5 = Friday
6 = Saturday
7 = Sunday
Step 2: Calculate the date range based on the day of week value
For "Current week":
If week is Monday-Sunday:
On Windows (day_of_week is 0-6):
If day_of_week = 1 (Monday): days_to_subtract = 0
If day_of_week = 2 (Tuesday): days_to_subtract = 1
If day_of_week = 3 (Wednesday): days_to_subtract = 2
If day_of_week = 4 (Thursday): days_to_subtract = 3
If day_of_week = 5 (Friday): days_to_subtract = 4
If day_of_week = 6 (Saturday): days_to_subtract = 5
If day_of_week = 0 (Sunday): days_to_subtract = 6
On Mac/Linux (day_of_week is 1-7):
days_to_subtract = day_of_week - 1
Start date = Today - days_to_subtract (this gives you the Monday of the current week)
End date = Start date + 6 days (this gives you the Sunday of the current week)
If week is Sunday-Saturday:
On Windows (day_of_week is 0-6):
days_to_subtract = day_of_week
On Mac/Linux (day_of_week is 1-7):
If day_of_week = 7 (Sunday): days_to_subtract = 0
Otherwise: days_to_subtract = day_of_week
Start date = Today - days_to_subtract (this gives you the Sunday of the current week)
End date = Start date + 6 days (this gives you the Saturday of the current week)
Example for Monday-Sunday week:
If today is October 24, 2025 (Friday):
On Windows: PowerShell returns 5 (Friday)
days_to_subtract = 4
On Mac/Linux: bash returns 5 (Friday)
days_to_subtract = 5 - 1 = 4
Start date = Oct 24 - 4 days = October 20, 2025 (Monday)
End date = Oct 20 + 6 days = October 26, 2025 (Sunday)
Result: October 20-26, 2025
For "Last week":
If week is Monday-Sunday:
Calculate the current week's Monday using the algorithm above
Start date = Current week's Monday - 7 days (Monday of last week)
End date = Start date + 6 days (Sunday of last week)
If week is Sunday-Saturday:
Calculate the current week's Sunday using the algorithm above
Start date = Current week's Sunday - 7 days (Sunday of last week)
End date = Start date + 6 days (Saturday of last week)
For "Specific week":
End date: User-provided date
If week is Monday-Sunday:
Validate that the end date is a Sunday
Start date: 6 days before the end date (the Monday)
If week is Sunday-Saturday:
Validate that the end date is a Saturday
Start date: 6 days before the end date (the Sunday)
Format dates in ISO 8601 format (YYYY-MM-DD) for use in client-side filtering
IMPORTANT:
All date calculations should be done programmatically (don't ask user for date calculations)
CRITICAL: Use the Bash tool with platform-specific commands to determine day of week
On Windows (platform: win32): powershell -Command "(Get-Date 'YYYY-MM-DD').DayOfWeek.value__" (returns 0-6)
On Mac/Linux (platform: darwin/linux): date -d "YYYY-MM-DD" +%u (returns 1-7)
DO NOT manually calculate day of week - the system command is authoritative
CRITICAL: Follow the lookup tables exactly for days_to_subtract calculation
Windows and Mac/Linux use different numbering systems (0-6 vs 1-7)
Verify your calculation matches the example: Oct 24 (Fri) โ Oct 20-26 (Mon-Sun)
For specific week option, validate that the end date matches the expected day of week using the same system commands
If validation fails, display helpful error message and ask user to provide correct end date
Store calculated start_date and end_date for use in Phase 4
Phase 4: Retrieve and Filter Work Items
Retrieve work items from Azure DevOps and apply client-side filtering based on the user's filter choices:
Retrieve work items using the wit_my_work_items MCP tool:
project: Project name from Phase 1 configuration
This returns all work items relevant to the authenticated user
The response includes work item details with all necessary fields
Resolve team member identity (if "Specific team member" was selected):
If user chose "Specific team member" in Phase 2:
Use core_get_identity_ids MCP tool to resolve the team member's identity
uniqueNames: Array containing the team member name from Phase 2 (e.g., ["John Smith"])
Extract the identity ID from the response to match against AssignedTo fields
If user chose "Current user":
Skip this step and filter by current authenticated user
Filter work items client-side based on user selections from Phase 2:
Step 3a - Filter by Completed Work:
Keep only work items where Microsoft.VSTS.Scheduling.CompletedWork field exists and is greater than 0
Work items without logged hours should be excluded
Step 3b - Filter by User Assignment:
If "Current user" was selected:
Keep work items assigned to the current authenticated user
Compare System.AssignedTo field with current user identity
If "Specific team member" was selected:
Keep work items assigned to the resolved team member identity
Compare System.AssignedTo field with the identity from step 2
Step 3c - Determine Date Field to Use:
If user chose "Closed Date": Use Microsoft.VSTS.Common.ClosedDate field
If user chose "Changed Date": Use System.ChangedDate field
Exception: If task filter type is "Worked on only", always use System.ChangedDate regardless of user's date field choice (non-closed tasks won't have ClosedDate)
Step 3d - Filter by Date Range:
Parse the date field value determined in Step 3c (format: "2025-10-23T14:30:00Z")
Extract only the date portion (YYYY-MM-DD) by taking the first 10 characters or splitting on 'T'
Example: "2025-10-23T14:30:00Z" โ "2025-10-23"
This ensures time of day doesn't affect the comparison
Compare the extracted date string against START_DATE and END_DATE (also in YYYY-MM-DD format)
Keep work items where: date >= START_DATE AND date <= END_DATE (inclusive on both ends)
CRITICAL: Do NOT use full datetime comparison - only compare date portions
Work items created/modified at any time during START_DATE should be included
Work items created/modified at any time during END_DATE should be included
Handle missing/null date fields gracefully:
If date field is null/missing, exclude the work item
This is common for work items that haven't been closed yet (when using ClosedDate)
Step 3e - Filter by State (based on task filter type):
If "Closed only": Keep only work items where System.State === 'Closed'
If "Worked on only": Keep only work items where System.State !== 'Closed'
If "Both": Keep all work items regardless of state
Extract work item data from filtered results:
For each remaining work item, extract:
ID (System.Id)
Type (System.WorkItemType)
Title (System.Title)
Description (System.Description) - only if verbosity level 3
Parent ID (System.Parent)
Completed Work hours (Microsoft.VSTS.Scheduling.CompletedWork)
Assigned To (System.AssignedTo)
State (System.State)
Work Date - The date field that was used for filtering:
If "Closed Date" was used: Extract Microsoft.VSTS.Common.ClosedDate
If "Changed Date" was used: Extract System.ChangedDate
Parse the date to extract day of week (for date-based grouping)
Sort work items:
Sort by Parent ID (ascending)
Then by Work Item Type (ascending)
Then by ID (ascending)
This makes hierarchy building easier in Phase 5
Store filtered work items in a data structure for tree building in Phase 5
IMPORTANT:
Use wit_my_work_items MCP tool to retrieve all work items for the authenticated user
Use core_get_identity_ids MCP tool only if "Specific team member" was selected
All filtering logic is performed client-side after retrieving work items
For "Worked on only" filter, always use System.ChangedDate (override user's date field choice)
Critical: Date fields in Azure DevOps are in ISO 8601 format (e.g., "2025-01-17T14:30:00Z")
Parse the date string carefully
MUST extract only the date portion (YYYY-MM-DD) - take first 10 characters or split on 'T'
DO NOT use datetime comparison - this would exclude work items based on time of day
Compare date strings directly: date >= START_DATE AND date <= END_DATE
Work items at ANY time on START_DATE or END_DATE must be included (00:00:00 to 23:59:59)
Handle missing/null fields gracefully:
CompletedWork might be 0 or null โ exclude
ClosedDate might be null for non-closed items โ exclude if using ClosedDate filter
ChangedDate should always exist โ but check just in case
Parent might be null โ handle in Phase 5 (orphaned items)
Extract State field for filtering and potential display in report
Work items can be of any type (Task, Bug, Issue, User Story, Feature, etc.) as long as they have logged hours
The filtering order matters:
First filter by CompletedWork > 0 (most selective)
Then filter by user assignment
Then filter by date range
Finally filter by state
Store the actual date value used for filtering (for date-based grouping in Phase 5)
Phase 5: Organize Work Items Based on Grouping Mode
Organize the work items based on the user's selected grouping mode:
If user chose "By hierarchy":
Create parent-child relationships:
Group work items by their Parent ID
Build a tree structure where:
Features are top-level nodes (no parent or parent is Epic)
User Stories are children of Features
Tasks, Bugs, Issues are children of User Stories
Work items with no parent go under "No Parent" group
Calculate rolled-up hours:
For each parent node (Feature, User Story):
Sum the Completed Work hours of all child work items
Recursively sum hours from all descendants
Only leaf nodes (Tasks, Bugs, Issues) have direct hours
Parent hours are the sum of their children's hours
Sort the tree:
Sort Features by ID (ascending)
Within each Feature, sort User Stories by ID (ascending)
Within each User Story, sort Tasks/Bugs/Issues by ID (ascending)
"No Parent" group appears at the end
If user chose "By date":
Group work items by date:
Extract the date portion from the Work Date field (ignore time)
Group all work items by their date
Create a flat list structure (no hierarchy)
Calculate daily totals:
Sum the Completed Work hours for all work items on each date
Only include work items with CompletedWork > 0
Sort by date:
Sort dates chronologically (earliest to latest)
Within each date, sort work items by ID (ascending)
If user chose "By date with hierarchy":
Group work items by date first:
Extract the date portion from the Work Date field (ignore time)
Group all work items by their date
Build hierarchy within each date:
For work items on each date, create parent-child relationships
Build a tree structure where:
Features are top-level nodes (no parent or parent is Epic)
User Stories are children of Features
Tasks, Bugs, Issues are children of User Stories
Work items with no parent go under "No Parent" group
Calculate hours:
Calculate rolled-up hours within each date's hierarchy
Calculate total hours for each date (sum of all work items that day)
Sort:
Sort dates chronologically (earliest to latest)
Within each date, sort Features by ID, then User Stories, then Tasks
IMPORTANT:
Handle orphaned work items (no parent) appropriately for each grouping mode
Only count hours from work items with Completed Work > 0
For hierarchy modes: Parent nodes show sum of child hours
For date modes: Extract date correctly from the date field used in the query
Maintain proper hierarchy: Feature > User Story > Task/Bug/Issue
Work items can be of any type (Task, Bug, Issue, etc.) as long as they have hours
Phase 6: Display Timesheet Report
Generate and display the timesheet report based on the grouping mode and verbosity level:
Report Header:
๐ Timesheet Report
โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ
๐ Period: [START_DATE] to [END_DATE] ([WEEK_TYPE])
๐ค User: [USER_NAME]
๐ Filter: [FILTER_DESCRIPTION]
๐ Date Field: [DATE_FIELD_NAME]
โฑ๏ธ Total Hours: [TOTAL_HOURS]
โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ
Replace placeholders:
[START_DATE] โ Formatted start date (e.g., "Jan 13, 2025")
[END_DATE] โ Formatted end date (e.g., "Jan 19, 2025")
[WEEK_TYPE] โ "Monday-Sunday" or "Sunday-Saturday"
[USER_NAME] โ Name of user being reported on
[FILTER_DESCRIPTION] โ "Closed only" / "Worked on only" / "Both closed and worked on" (based on Step 3 choice)
[DATE_FIELD_NAME] โ "Closed Date" / "Changed Date" (based on Step 4 choice, or "Changed Date" if worked on only)
Indent description with 6 spaces for proper tree alignment
Report Footer:
โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ
โฑ๏ธ Total Hours: [TOTAL_HOURS]
๐ Work Items: [WORK_ITEM_COUNT] ([FEATURE_COUNT] Features, [STORY_COUNT] Stories, [TASK_COUNT] Tasks/Bugs/Issues)
โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ
๐ก Tip: [FILTER_TIP]
Only work items with logged "Completed Work" hours are included.
Filter Tip Text (based on task filter type from Step 3):
Option 1 (Closed only): "This report shows work items that were closed during the specified period."
Option 2 (Worked on only): "This report shows work items that were worked on (but not closed) during the specified period."
Option 3 (Both): "This report shows all work items (both closed and worked on) during the specified period."
Replace placeholders:
[TOTAL_HOURS] โ Total hours across all work items
[WORK_ITEM_COUNT] โ Total count of all work items
[FEATURE_COUNT] โ Count of Features
[STORY_COUNT] โ Count of User Stories
[TASK_COUNT] โ Count of Tasks, Bugs, Issues combined
IMPORTANT:
Use proper indentation for tree hierarchy (2 spaces per level)
Show totals at each parent level (sum of children) for hierarchy-based grouping
Use appropriate icons for different work item types
For verbosity level 3, strip HTML and truncate descriptions
Display "No Parent" section only if there are orphaned work items (for hierarchy-based grouping)
Format hours with 1 decimal place (e.g., "2.5h" not "2.50h")
If no work items found, display a friendly message indicating no hours were logged during the period
Select the correct display format based on grouping mode:
"By hierarchy": Use traditional tree structure (Feature > Story > Task)
"By date": Use date headers with flat work item lists (no hierarchy)
"By date with hierarchy": Use date headers with tree structure within each date
For date-based grouping modes, format dates as "Day of Week, Month DD, YYYY" (e.g., "Monday, Oct 21, 2025")
For date-based grouping modes, show total hours for each date
Important Constraints
DO NOT:
Proceed without Azure DevOps configuration in CLAUDE.md
Use bash commands for file operations
Use AskUserQuestion for free-form input steps (Steps 1a and 2a should be simple text output)
Ask questions one at a time when they can be combined (use the 2-step approach described in Phase 2)
Include work items with Completed Work = 0 or null
Use ClosedDate when user selected "worked on only" filter (must use ChangedDate)
Use placeholders or empty values in the report
Ignore the task filter type or date field selections from Phase 2
Second-guess or reinterpret the current date from <env> - trust it exactly as ISO 8601 format (YYYY-MM-DD where month is middle number)
Manually calculate day of week - ALWAYS use system commands (PowerShell on Windows, date on Mac/Linux)
Skip client-side filtering steps (all filtering must be done after retrieving work items)
DO:
Use Read tool to check CLAUDE.md for Azure DevOps configuration
Use AskUserQuestion tool exactly twice in Phase 2:
Step 1: Combine 4 report configuration questions (week definition, time period, task filter type, date field)
Follow the lookup tables in Phase 3 exactly for calculating days_to_subtract
DO NOT manually calculate day of week
Use wit_my_work_items MCP tool to retrieve work items for the authenticated user
Use core_get_identity_ids MCP tool to resolve team member identities (only if "Specific team member" was selected)
Perform all filtering client-side after retrieving work items:
Filter by CompletedWork > 0 first
Filter by user assignment
Filter by date range (using appropriate date field)
Filter by state (based on task filter type)
Use correct Azure DevOps field names when filtering:
Closed Date field: Microsoft.VSTS.Common.ClosedDate
Changed Date field: System.ChangedDate
State field: System.State
Completed Work field: Microsoft.VSTS.Scheduling.CompletedWork
For "Worked on only" filter, always use System.ChangedDate (override user's date field choice)
Parse ISO 8601 date strings carefully and compare date portions only (YYYY-MM-DD)
Extract first 10 characters from datetime strings before comparison
Do NOT use full datetime comparison with time components
This ensures work items at any time during the day are included
Always filter by CompletedWork > 0
Organize work items based on grouping mode selection:
"By hierarchy": Build proper hierarchical tree structure and roll up hours from children to parents
"By date": Group by date with flat list (no hierarchy)
"By date with hierarchy": Group by date first, then build hierarchy within each date
Handle orphaned work items under "No Parent" (for hierarchy-based grouping modes)
Handle missing/null date fields gracefully (exclude work items with missing dates)
Display report with appropriate verbosity level and grouping mode format
Use proper formatting with emojis and tree structure (or flat list for "By date" mode)
Show helpful summary statistics in footer with filter-appropriate tip text
Format dates in user-friendly format (e.g., "Jan 13, 2025" for report header, "Monday, Oct 21, 2025" for date grouping)
Format hours with appropriate precision
Error Handling
If the MCP tool returns an error:
Display the error message to the user
Suggest possible solutions:
For wit_my_work_items errors:
Verify Azure DevOps MCP server is configured and running
Check that project name is correct
Ensure user has permissions to query work items
Verify Node.js 20+ is installed for MCP server
Recommend running /ado-init if configuration seems incorrect
For core_get_identity_ids errors:
Verify the team member name is spelled correctly
Check that the team member exists in the Azure DevOps organization
Try using the exact display name as it appears in Azure DevOps
Suggest using "Current user" option instead if team member cannot be resolved
If client-side filtering finds no matching work items:
This is not an error, but an expected outcome
The report will display the "No work items found" message with helpful tips
Common reasons:
No work items had logged hours during the time period
The selected user had no work items assigned
The date range or state filter was too restrictive
Work items exist but lack CompletedWork values
If no work items are found:
Display a friendly message (customize based on task filter type):
๐ Timesheet Report
โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ
๐ Period: [START_DATE] to [END_DATE] ([WEEK_TYPE])
๐ค User: [USER_NAME]
๐ Filter: [FILTER_DESCRIPTION]
๐ Date Field: [DATE_FIELD_NAME]
โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ
No work items with logged hours were found for this period.
This could mean:
- No work items matched the filter criteria during this time period
- No work items had "Completed Work" hours logged
- The specified user had no work items assigned
๐ก Tip: Make sure to set "Completed Work" hours on tasks before
closing them, or use /ado-log-story-work to log hours.
Replace placeholders:
[FILTER_DESCRIPTION]: "Closed only" / "Worked on only" / "Both closed and worked on"
[DATE_FIELD_NAME]: "Closed Date" / "Changed Date"
If date validation fails (for specific week option):
Display helpful error message:
โ Invalid end date for week definition
For [WEEK_TYPE] weeks, the end date must be a [EXPECTED_DAY].
You provided: [PROVIDED_DATE] which is a [ACTUAL_DAY].
Please provide an end date that falls on a [EXPECTED_DAY].
Additional Features
Date Formatting:
Input dates: YYYY-MM-DD (e.g., 2025-01-17)
Display dates: Month DD, YYYY (e.g., Jan 17, 2025)
Hour Formatting:
Display with 1 decimal place if needed (e.g., "2.5h")
Round to 1 decimal place for display
Sum all hours accurately before rounding for display
Work Item Type Handling:
Support all Azure DevOps work item types (Task, Bug, Issue, etc.)
Use appropriate icons for common types
Fall back to bullet point for unknown types
Treat all leaf nodes as potential hour sources (not just Tasks)
