Delete and Hide Tasks in PWA Timesheet

G

graffer54

I would like to run two scripts to delete and hide tasks in PWA. Before I do
so, I have a few questions.

Will running either a script to delete cancelled tasks or a script to hide
completed tasks affect actual work? For instance, will it remove or
time-phase actuals?

Will anything happen to time that has been submitted but not yet accepted?

Are there any other risks I should be aware of before running a script?

Thank you.
 
G

graffer54

First, let me preface this by saying I'm not familiar with the technical side
of computers - I would have someone in the IT department run the scripts for
me on a weekly basis. We are using Project Server 2003.

To delete cancelled tasks, we would run:

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
)

To hide completed tasks, we would run:

Update MSP_WEB_ASSIGNMENTS
Set WASSN_REMOVED_BY_RESOURCE = 1
where WASSN_PCT_COMP = 100
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top