none
Query to show Predecessors and Successors RRS feed

  • Question

  • Hii..

    Im using Sharepoint 2010 and project server 2010.  I need to show information about external dependency from project server database. Example the scenario is Project2 task 1 have predecessors from Project1 task 1.

    The Query result :

    ProjectName  |  PredecessorTask  |  SuccessorTask |

    Project1           |                               |  Project2\1          |

    Project2           |    Project1\1            |                           |

    Anyone can help me?

    Friday, March 1, 2013 8:30 AM

All replies

  • Hi

    you will need to join with the dbo.msp_links table from the published database for that.

    Hope that helps

    Regards

    Christoph


    Christoph Muelder | Senior Consultant, MCSE, MCT | SOLVIN information management GmbH, Germany

    Friday, March 1, 2013 2:00 PM
  • FYI, this is the use case for Deliverables as they are user controlled cross project dependencies. They are also available in the RDB for reporting.

    Treb Gatte | Twitter |http://AboutMSProject.com

    Friday, March 1, 2013 8:16 PM
    Moderator
  • Hi Bangkit, 

    I am looking for a similar report.. Were you able to figure it out?

    thanks 

    Kay

    Tuesday, September 24, 2013 4:50 PM