Hide Deleted Task from Web Access View

[Minhchau]

We've been using Project 2003 for 4 months. In some projects, our project
manager deletes a task or a resource from a task in Project 2003 (client
application), and those tasks still show in the "View Resource Assignments"
screen.
How do we hide these tasks in this view.
Thanks,

 

[Dale Howard [MVP]]

Minhchau --

Run the SQL Server script listed at the following URL:

http://www.projectserverexperts.com/Shared Documents/deletecancelledtasks.htm

Hope this helps.

 

[Minhchau]

Thanks,
Minhchau

Minhchau --

Run the SQL Server script listed at the following URL:

http://www.projectserverexperts.com/Shared Documents/deletecancelledtasks.htm

Hope this helps.

 

[Gaurav Wason]

Do you want to keep the historical time that the resources have entered.

Then you can run this query

UPDATE MSP_WEB_ASSIGNMENTS
SET WASSN_REMOVED_BY_RESOURCE = 1
WHERE WASSN_Deleted_In_Proj = 1
and task_is_Summary = 0


This query will hide all the deleted assignments in project.

Thanks
--
Gaurav Wason
(e-mail address removed)
MCP - Project Server

Thanks,
Minhchau