none
Custom field in pwa. RRS feed

  • Question

  • Hi All,

    If I create a custom field at project level in PWA 2010 then in SQL which table I refer to see entries.

    Thanks in advance!

    Anuranjan Prasad

    • Moved by Wayne Fan Friday, July 29, 2011 8:32 AM It's Project Server Issue, thanks. (From:SharePoint 2010 - General Questions and Answers)
    Thursday, July 28, 2011 7:28 AM

Answers

  • Thanks all !

    Yes, I can get all the custom field information from different user View. 

    Thanks 

    Anuranjan Prasad

    Wednesday, August 3, 2011 6:52 PM

All replies

  • Hello,

    best option is to see those fields in Reporting Database in View MSP_EpmProject_UserView.

    for lookup fields you will need to join it with additional tables.

    Best regards,

    Anton Kravtsov

    www.FluentPro.com

     

    • Proposed as answer by Parth Rawal Monday, August 1, 2011 5:15 AM
    Friday, July 29, 2011 4:58 PM
  • Yes, all Views ending with _UserView Have relevant custom fields appended to them automatically.


    Rod Gill

    The one and only Project VBA Book Rod Gill Project Management
    • Proposed as answer by Parth Rawal Monday, August 1, 2011 5:15 AM
    Saturday, July 30, 2011 1:28 AM
    Moderator
  • YOu can look in the MSP_EPMProject_userView in Reporting database which contains the project level custom field as a column in view.

    Hope that helps.


    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    Monday, August 1, 2011 5:48 AM
  • Thanks all !

    Yes, I can get all the custom field information from different user View. 

    Thanks 

    Anuranjan Prasad

    Wednesday, August 3, 2011 6:52 PM