none
query to retrieve project tasks dependencies in PS2010 RRS feed

  • Question

  • We're in the process of building several webparts to complement PS2010's. One of them is related to show Projects (task) dependencies on a sharepoint site. We need aquery that for each project shows the tasks dependencies. Any have an idea on how to build this one?

    Oscarin

    Tuesday, December 4, 2012 4:33 PM

Answers

  • Hi Oscarin--

    You may find the PROJ_UID while looing throught the Dependency table in project dataset for a project.

    Hope that helps.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    • Marked as answer by Oscarin0557 Monday, December 10, 2012 5:44 PM
    Friday, December 7, 2012 6:11 AM

All replies

  • Hi there--

    Project Task dependencies are not stored in reporting database. You will need to use the PSI to get the data from Project web service & use the project dataset to get the LINKS b/w Tasks.project Datatset contains the details of predeccesor & successor in the form of LINK_PRED_UID & LINK_SUCC_UID.

    Please see below thread :
    http://social.technet.microsoft.com/Forums/sk/project2010custprog/thread/250cecc7-4458-4bb9-a0d4-4cada0653954

    Hope that helps.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Wednesday, December 5, 2012 7:11 AM
  • Thank You Amit,

    I'll try this.  One additional comment/question:  will this bring the dependencies between two projects at at task level?


    Oscarin

    Thursday, December 6, 2012 6:03 PM
  • Hi Oscarin--

    You may find the PROJ_UID while looing throught the Dependency table in project dataset for a project.

    Hope that helps.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    • Marked as answer by Oscarin0557 Monday, December 10, 2012 5:44 PM
    Friday, December 7, 2012 6:11 AM
  • Thank You again Amit.

    This is what we needed.


    Oscarin

    Monday, December 10, 2012 5:44 PM