Hiding multiple tasks

S

Suzanne

Hi All

Some resources have been removed off a lot of current activities
within a project plan, however they are still active working on other
activities within the plan/

Within the timesheet there are around 70 activities with a cross
beside them and understandably the resource doesn't want to highlight
one at a time to remove these from the timesheet view.

Is there a way to hide more than one from the timesheet view, or
possibly and SQL query?
 
S

Suzanne

Hi Dale,

Thank you for the quick responce, would the SQL provided just remove
the tasks from the timesheets only for the resources no longer needed
on those tasks or completely remove the task. The tasks are still
active with different resources working on them.
 
G

Gaurav Wason

Suzanne,

Do you have access to Project Server Database? I can give you a query that
you can use to hide all deleted task from PWA.
 
S

Suzanne

Suzanne,

Do you have access to Project Server Database? I can give you a query that
you can use to hide all deleted task from PWA.

--
Gaurav Wason
[email protected], MCP - Project Server
Project Made Easy (Project Archive Tool) and (Project Owner Tool)http://projectmadeeasy.com








- Show quoted text -

Thank you, I do however they are still live tasks with other people
booking to them.

I was wondering if there is a way to remove the tasks only from the
specified resources timesheet without them having to go through one by
one...

Cheers
Suzanne
 
D

Dale Howard [MVP]

Suzanne --

The SQL code removes only cancelled tasks (with the big black X) from each
user's timesheet in PWA. It does not touch completed tasks, in-progress
tasks, or unstarted tasks from anyone's timesheet in PWA, nor does it remove
the tasks in the actual Microsoft Project plan. Hope this helps.
 
Top