如何在Azure DevOps门户查询今日修改Completed effort的工作项列表

Got it, let's get this sorted—you need to narrow down your Azure DevOps work items to only those where the Completed Effort field was updated today, right? No more sifting through items that had other fields changed! Here's step-by-step how to build that query:

Step 1: Open the Query Editor #

• Head to your Azure DevOps project, go to Boards > Queries, and create a new Flat query (this is ideal for a clean list you can export for your report).

Step 2: Add Your Core Filter Criteria #

First, we'll lock down the time frame, then filter for only the field you care about:

1. Set the date range:
   • Click "Add criteria", select the Changed Date field, set the operator to =, and use the value @Today (this dynamic variable automatically uses the current date, perfect for daily reports).
2. Filter for Completed Effort changes:
   • Add another criteria line, select the Changed Fields field (this tracks all fields that were actually modified in the latest update).
   • Set the operator to Contains, and enter the exact name of your field: Completed Effort (double-check your project's field name—some might use "Completed Work" instead).

Step 3: Refine for Reporting (Optional) #

To make your report more useful for your manager, add these columns to the query:

• Completed Effort: Shows the current value of the field
• Previous Value of Completed Effort: If your project tracks field history, this will show what the value was before today's update (great for context on how much work was marked as completed)
• Assigned To: To see which team member updated each item
• Title: Quick context on the work item itself

Step 4: Save and Export for Your Report #

• Save the query with a clear name like "Daily Completed Effort Updates" so you can reuse it every day.
• When you're ready to send the report, click Export and choose Excel (for easy formatting) or copy the table directly into your email.

内容的提问来源于stack exchange，提问作者Kishan