It's all about the answers!

Ask a question

How to filter work items using Plan End Date from Traditional Scheduler

Abe Batthish (8646) | asked May 02 '14, 10:10 p.m.
I'm using the Traditional Scheduler to set my plan. I then create a Planned snapshot to set the plan start/end dates for all work items. How can I now create queries that can filter based on plan end date so that I can for example see all items pertaining to me that are planned to end in the next 2 weeks?
If this is not possible, is there a way to auto set all the due dates of items in the plan to the plan end date?


One answer

permanent link
Lily Wang (4.9k714) | answered May 05 '14, 8:09 a.m.
As the "planned end date" is a computed value, it's no way to create a query using "planned end date" as a condition. Similar enhancement has been submitted in

Alternatively you can have the plan view to filtered on the "planned end date". Please see the first update by Millard in

Abe Batthish commented May 05 '14, 8:18 a.m.

Thanks. This would be helpful if there was only one active plan. However we have several team members that have tasks across several plans and wish to understand their upcoming tasks across all their plans. 

Only workaround I can think of is to set due date according to plan end date. But this would be a painfully manual task. Any chance there is a macro available to accomplish this across all items in a plan?

Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.