Project Server 2007 Task Query RRS feed

  • Question

  • Hello guys,


    Please, I need to query the reporting database to get all completed previous week task and displayed in a custom webpart. Is this possible? if it is possible what tables should I query in the database?


    Thank you

    Sunday, September 19, 2010 4:13 AM


  • Hi,

    Download the Project SDK from MSDN. In it is a full database schema for the reporting db. One of the tables is a timephased table with daily values so you can query any date range you want.

    In addition, the built in Queries whose names end in _Userview are very useful as they automatically include  relevant enterprise custom fields.

    Rod Gill

    The one and only Project VBA Book Rod Gill Project Management
    • Marked as answer by ghostme Tuesday, September 21, 2010 3:48 AM
    Sunday, September 19, 2010 8:46 PM