Task Updates Approval in PWA - PS2007

[PedroJose]

Hello,

I recently moved the task update approval process from the PMO to each of
the line managers. So prior to the change, a resource would import timesheet
to tasks, then submit tasks, and the update would be routed to the PMO
manager to review and approve. After the change, updates go to the person's
manager, and the PMO only sees these updates after they have been approved by
the line manager... The question is:
Is there a way to see the updates submitted by team members, prior to the
manager reviewing/approving??? Obviously after the change, and by design, I
only see my guys updates, is there a way to see all of them via a direct
query to the DB or some other method??

Please advise.

thx.

 

[Nach]

Hi,
This is how I do it. Query against the Published DB --
SELECT MSP_ASSIGNMENTS.TASK_NAME, MSP_PROJECTS.PROJ_NAME
FROM MSP_ASSIGNMENT_TRANSACTIONS INNER JOIN
MSP_ASSIGNMENTS ON
MSP_ASSIGNMENT_TRANSACTIONS.ASSN_UID = MSP_ASSIGNMENTS.ASSN_UID INNER JOIN
MSP_PROJECTS ON MSP_ASSIGNMENT_TRANSACTIONS.PROJ_UID =
MSP_PROJECTS.PROJ_UID
WHERE (MSP_ASSIGNMENT_TRANSACTIONS.ASSN_TRANS_STATE_ENUM = 1)

Thanks
Nach