Removing tasks from a timesheet view...

[Kevin McC]

Guru's...

In Timesheet view queries...
Deleted Tasks
Tasks that have been deleted (even well after the project has been
published) are still displayed - however an 'X' is displayed in column 1 -
most likely to show that the task has been deleted - So why not just delete
thetask [Note: the tasks in question didnt have any actuals]. What is the
method for NOT displaying these deleted tasks in timesheet view.

Completed tasks
When tasks are complete (ie, reported hours have been approved by
team-leaders, and/or 100% complete), they still display in the timesheet
view. I figure that they should be removed from timesheet view once thet have
been. Are there any rules about how long completed tasks remain to be
displayed?? Is there a setting somewhere for this??

Many thanks

Kevin
Perth, Western Australia

 

[Dale Howard [MVP]]

Kevin --

Refer to the following links for the solution to your issues with removing
deleted tasks and completed tasks:

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

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

Hope this helps.

 

[Marc Soester]

Hi Kevin,

Deleted Tasks:
- are still shown, you have 2 options. The user can manually "hide" the
deleted tasks in there timesheet.
- second option is run this script on your Project Server SQL Database, this
will delete all "delted" tasks - Below is the script:
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

This may not be the most ideal solution, but it works. Project Server has no
other means to delte the "deleted" tasks:

completed Tasks:
In regards of displaying the completed tasks, you still will see the
completed task when you have "all tasks" choosen in your Timesheet view
within PWA. Your user can hide them "manually" within the "task" screen.
when you use "current tasks" you not not see the completed tasks. ( But only
after the Project Manager has approved this tasks )
I hope this helps

 

[Kevin McC]

Dale & Marc...

Thank you both for your quick responses..
Both very helpful.

Kevin,
Perth, Western Australia