Predeccors and Successors - Where are that located in the SQL DB?

B

Brad Harris

I am running MSP2K7.
Where can I find the Predeccors and Successors field data that are located
in the SQL DB?
 
P

Paul Conroy

TaskParentUID Column is the predeccors UID in the Reporting.MSP_EPMTask
table. I'm not aware of a similar column for the successors, but you will be
able to enumerate the successor using the column above using TSQL.
 
J

James Fraser

TaskParentUID Column is the predeccors UID in the Reporting.MSP_EPMTask
table. I'm not aware of a similar column for the successors, but you will be
able to enumerate the successor using the column above using TSQL.
Click to expand...

I'm pretty sure that the Parent UID refers to the task above this task
in the outline structure of the project. For the "root" summary task
0, this usually refers back to the task itself.

Predecessor and successor are not in the reporting database. With the
usual cautions that the schema is subject to change, head to the draft
or published databases.


James Fraser
 
B

Brad Harris

Thanks James.
Dod you know the table and column or the predecessor successor in the
published DB?
 
J

James Fraser

Thanks James.
Dod you know the table and column or the predecessor successor in the
published DB?
Click to expand...

The MSP_LINKS, if I recall correctly, LINK_PRED_UID and LINK_SUCC_UID

Keep in mind that a task may have multiple predecessors or successors.


James Fraser
 
B

Brad Harris

Thanks, You da Man!

James Fraser said:
The MSP_LINKS, if I recall correctly, LINK_PRED_UID and LINK_SUCC_UID

Keep in mind that a task may have multiple predecessors or successors.


James Fraser
Click to expand...
 
Top