Search code examples
ms-projectproject-serverms-project-server-2013

Where is timeline information stored in MS Project Server Database

Which table/view can I pull "Display on Timeline" checkbox info from the Project Server Database? I can see all Task Information from [MSP_EpmTask_UserView], [pub.Task]. The only data I can not find is "Display on Timeline". Anyone has experience with that?

screenshot

Solution

  • Found the timeline data in the table pub.MSP_PROJECT_FRONT_END

    timeline data stored as XML format in PFE_PROPERTIES field