Remove specific completed tasks from PWA timesheet view

[Joe]

Is there an update query or SP I can run to remove specific completed tasks
from a resources timesheet without having to use the “Clean up Project Server
database†feature from the Admin screen. The reason I don’t want to use this
feature is because it removes all completed items across all projects on the
server, which I don’t want to do.

 

[Gaurav Wason]

Joe,

I usually use this query to hide deleted task

UPDATE MSP_WEB_ASSIGNMENTS
SET WASSN_REMOVED_BY_RESOURCE = 1 -- Will hide assignment from timesheet
WHERE WASSN_Deleted_In_Proj = 1
and task_is_Summary = 0
and WASSN_REMOVED_BY_RESOURCE = 0

Let me know if this helps.

 

[Joe]

Thanks Gaurav,

I know how to do this for "deleted" task. I am looking to remove specific
"Completed" task.

Any ideas?

 

[Steph]

This link can help you!

http://msdn.microsoft.com/library/d...3_ta/html/ODC_PJHostingPDSWebApplications.asp

Steph