Don't want to see "deleted task" in timesheet view

[Joe]

I was playing around with the project plan and assigned a “test†task to a
resource to see how it displayed for the user in PWA (I logged on as that
user). Now I deleted this test task, but when I log back in and view the
timesheet view from the “Task†menu, it shows the deleted task items (flagged
as items that was deleted). Can I not have this displayed on this screen?

 

[Dale Howard [MVP]]

Joe --

Select the deleted task in the PWA timesheet and click the Hide button.
Hope this helps.

 

[Gary M]

Is there anyway to do this at an admin level? We are using 2003 and after
an overhaul of our staffing a number of our staff has this same issue. Is
there an easy way in SQL Server to identify these items and delete them?

Thanks,

Gary

 

[Mark Riekki]

I've created the following SQL statement that does the trick. It will hide
'deleted' or 're-assigned' tasks either at an indivdual level or project
level depending on the parameters in the where statement.


UPDATE MSP_WEB_ASSIGNMENTS
SET WASSN_REMOVED_BY_RESOURCE = 1
WHERE WPROJ_ID = <some value> AND
WRES_ID = <some value> AND
TASK_IS_SUMMARY = 0 AND
WASSN_DELETED_IN_PROJ = 1

Hope this helps
Mark Riekki