How to hide deleted tasks automatically

[Skuli]

When viewing my tasks in the web access, the view shows deleted tasks,
how do we remove these tasks automatically, I know of the Hide this
task button, but I do not understand why the tasks are shown when they
do not exist anymore.

 

[Dale Howard [MVP]]

Skuli --

The delete tasks show the X indicator to alert the resource that he/she has
been removed from the task. Team members can use the hide button to remove
the delete tasks from their timesheets. In the past, several others have
posted a SQL Server script to "clean up" deleted tasks automatically. I
will invite one of them to share the script with you. Hope this helps.

 

[D Web]

Here's the SQL query Dale mentioned.

Update MSP_WEB_ASSIGNMENTS Set WASSN_REMOVED_BY_RESOURCE = 1 Where
WASSN_DELETED_IN_PROJ = 1

 

[Skuli]

THX:

Seems to work fine.

Here's the SQL query Dale mentioned.

Update MSP_WEB_ASSIGNMENTS Set WASSN_REMOVED_BY_RESOURCE = 1 Where
WASSN_DELETED_IN_PROJ = 1