Get PROJ_ID for MSP_WEB_ASSIGNMENTS record for master projects

[pavel.gz]

For single projects field TASK_UID (as well as ASSN_UID) is
MSP_WEB_ASSIGNMENTS table corresponds with the existing record in
MSP_TASKS.

However, when I publish master project (which has other projects
inserted), value of TASK_UID for these records becomes very big and
there is no record in MSP_TASKS that has such TASK_UID.

Is there any way I can get from this TASK_UID which project does
record in MSP_WEB_ASSIGNMENTS belongs to?

 

[Gary L. Chefetz [MVP]]

The tasks that are part of sub projects do not belong to the Master project,
despite the fact that you can see them there. You need to retrieve these
from the projects containing the assignments.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

 

[pavel.gz]

Yes, but in the PWA they appear as assignments of Master project.
However, when manager accepts work on this assignments (through web),
project professional somehow manages to get the real sub project this
assignments belong to and put there actual work. Is there any way I
could so the same using ASSN_UID or TASK_UID from msp_web_assignments.

 

[Gary L. Chefetz [MVP]]

It manages to do this because the assignments do not belong to the master
project. I'm really not sure what you're asking.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com