none
Project Server 2010: How to access task text fields like "text1" via SQL? RRS feed

  • Question

  • Hallo,

    for a report in the reporting service I am retrieving task information via SQL.

    So fare I have failed to find the values for the build-in task text fields/attributes like "text1" .
    Can anyone tell me in which table I can find these values?

    Thanks
       pmurk

    Thursday, May 24, 2012 11:11 AM

All replies

  • Hi pmruk--

    If you have the Task level enterprise custom text field created & you assign the text, save/publish the project . The reporting database view will be updated for MSP_EpmTask_UserView & add the custom field as a column. It will be easy for you to query the reporting database. You can downlaod the project 2010 SDK for reporting database schema.

    --Suppose the Task level enterprise custom field name is Schedule Status
    select projectuid, TaskUid, [Schedule Status] 
    from  dbo.MSP_EpmTask_UserView

    Local fields like Text1, 2 etc are not stored in projects erver reporting database.
    http://msdn.microsoft.com/en-us/library/ms447495.aspx

    Does that help?


    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

    Thursday, May 24, 2012 11:42 AM