|
|
| |
|
The following SQL query deletes the pending messages (task updates) not approved by PM for specific project.
How to Run: Run the following query on SQL Query Analyzer, by selecting Project Server database.
***********************************************************************************
Step 1: Find the WPROJ_ID for project
Specify your project name in WHERE clause. EPM Central Office Move is the project name in my example.
SELECT WPROJ_ID FROM MSP_WEB_PROJECTS
WHERE WPROJ_NAME LIKE '%EPM Central Office Move%'
Step 2: Delete pending task updates
Specify the WPROJ_ID in below query; Let's say WPROJ_ID is 128
DELETE FROM MSP_WEB_ASSIGNMENTS
WHERE WASSN_ID IN
(SELECT MSP_WEB_ASSIGNMENTS.WASSN_ID
FROM MSP_WEB_ASSIGNMENTS INNER JOIN
MSP_WEB_PROJECTS ON MSP_WEB_ASSIGNMENTS.WPROJ_ID = MSP_WEB_PROJECTS.WPROJ_ID INNER JOIN
MSP_WEB_RESOURCES ON MSP_WEB_ASSIGNMENTS.WRES_ID = MSP_WEB_RESOURCES.WRES_ID INNER JOIN
MSP_WEB_RESOURCES MSP_WEB_RESOURCES_1 ON MSP_WEB_PROJECTS.WRES_ID =
MSP_WEB_RESOURCES_1.WRES_ID INNER JOIN
MSP_WEB_RESOURCES MSP_WEB_RESOURCES_2 ON
MSP_WEB_ASSIGNMENTS.WRES_ID_MGR = MSP_WEB_RESOURCES_2.WRES_ID
WHERE (MSP_WEB_ASSIGNMENTS.WASSN_SEND_UPDATE_NEEDED = 1) AND
(MSP_WEB_ASSIGNMENTS.WASSN_ACTUALS_PENDING = 1) AND
(MSP_WEB_ASSIGNMENTS.WASSN_UPDATE_STATUS = 1) AND
(MSP_WEB_ASSIGNMENTS.WASSN_SEND_UPDATE_DATE IS NOT NULL)
AND MSP_WEB_PROJECTS.WPROJ_ID = 128)
***********************************************************************************
|
| |
|
