Rabbit --
You have two choices. Your team members can select each cancelled task
individually on the View my tasks page and then click the Hide button. Or
your Project Server administrator can run a SQL Server script to remove the
cancelled tasks. Several users have been kind enough to post a SQL Server
query and script for dealing with cancelled task assignments in PWA. The
SQL Server query to see a list of cancelled tasks is as follows :
select ma.WASSN_ID, mp.PROJ_NAME, ma.TASK_NAME,mr.RES_NAME, from
MSP_WEB_ASSIGNMENTS ma
join MSP_WEB_PROJECTS mp
ON ma.WPROJ_ID = mp.WPROJ_ID
join MSP_WEB_RESOURCES mr
ON ma.WRES_ID = mr.WRES_ID
where
ma.WASSN_DELETED_IN_PROJ <>0
order by 1
The SQL Server script to delete cancelled assignments is as follows:
delete from MSP_WEB_ASSIGNMENTS
where WASSN_ID IN (
select ma.WASSN_ID from MSP_WEB_ASSIGNMENTS ma
join MSP_WEB_PROJECTS mp
ON ma.WPROJ_ID = mp.WPROJ_ID
join MSP_WEB_RESOURCES mr
ON ma.WRES_ID = mr.WRES_ID
where
ma.WASSN_DELETED_IN_PROJ <>0
--AND mp.PROJ_NAME like '25713%' --uncomment it for specific project
)
When you run the script to delete cancelled assignments, it will remove
those assignments from both the Timesheet view and the View resource
assignments view. Hope this helps.
