SharePoint Events

 ProjectReady Applications for the AEC
 06/28/16 - Webcast: Compliant Legal Document Control & Collaboration in SharePoint
 06/30/16 - Webcast: AutoCAD & Document Management, Viewing, Markup & Mobility in SharePoint
 07/01/16 - Webcast: Best New Security Features of SharePoint 2016 and SharePoint Online
 07/26/16 - Webcast: Project & Program Management Made Easy in SharePoint & Office 365
 07/27/16 - Webcast: Matter Management Engine in SharePoint & Microsoft Outlook
 07/28/16 - Webcast: Project & Program Management for the AEC with SharePoint
 07/29/16 - Webcast: Why Office 365 and the Microsoft Cloud is Ready for the Financial Services Industry
(More Links...)

 SharePoint Videos

 Best New Features of SharePoint 2016
 The Value of the Microsoft Cloud: Understanding the Scalability, Affordable Storage & Security Advantages of Office 365
 Task, Resource & Utilization Management & Reporting for the AEC with SharePoint and Office 365
 Legal Matter Task Management and Reports in SharePoint and Office 365
 What’s Coming in Office 365 & SharePoint 2016
 Automating Contract Management with Workflow in the Cloud or On-Premise
 Manage Email in the Cloud or On-Premise with SharePoint & Office 365
 Governance Essentials for SharePoint 2013 and SharePoint Online
 Easily Move Email, Files and SharePoint to Office 365
 Enterprise Workflow in the cloud with SharePoint & Office 365
 Why SharePoint 2013
 SharePoint 2013 vs SharePoint Online and Office 365 Security, Compliance and eDiscovery
 Expanding the Use, Potential and Value of SharePoint and Office 365 through 3rd Party Applications
 Keys to Successful SharePoint Initiatives and User Adoption
 SharePoint 2013 vs. SharePoint Online: Workflow
 Ensure Auditability and Compliance with Advanced Workflows in SharePoint
 SharePoint 2013 vs. SharePoint Online and Office 365: Enterprise Content Management
 SharePoint 2013 vs. SharePoint Online and Office 365: Business Intelligence
 SharePoint 2013 vs. SharePoint Online: Search
 Power Business Intelligence for SharePoint Online and Office 365
(More Links...)

 Archives ‭[1]‬

Opening SharePoint Links in a new window
Mail Enabled Lists vs. The Missing Windows 2008 POP3/IMAP Server 
7 Tools for SharePoint Developers
Public Facing Masterpage Techniques
How to Quickly Deploy and Activate a Timer Service to Your Site Collection
Custom SharePoint Master Page Feature with WSP Builder
Date Math with InfoPath
Enterprise Search Tricks and Tips Part 1
Populating Word Documents With SharePoint Data. Try The DIP!
Programmatic Deep Dive into Blank SharePoint Lookup Columns
1 - 10Next
How Project Server 2010 Store Custom Field Values

By: Yi Fan Tang

Project Server 2010 comes as a web application to a SharePoint 2010 Farm, along with a service application for provisioning and managing. Although it is a web application, large part of the data are not stored in the web application’s content database. They are stored in a separated database created during the provision of the project server web application. I will use the custom fields as an example to show briefly how Project Server 2010 stores the data in that database.

SharePoint_Blog_How_Project_Server_2010_Store_Custom_Field_Values

Basically, a custom field value for a project will involve four tables, the project field values table, the custom fields table, the lookup tables table and the lookup tables values table. The following table shows the roles of each table.

SharePoint_Blog_How_Project_Server_2010_Store_Custom_Field_Values

The following diagram shows the relationship of all the four tables.

SharePoint_Blog_How_Project_Server_2010_Store_Custom_Field_Values

The “Project Field Values” table only stores the custom field values. If the custom field is a look up field, the “Project Field Values” table stores the lookup table value ID. The value’s actual display name, for example, is stored in the “Lookup Table Values” table. Given a project ID and a custom field ID, you can get the name of the custom field in the “Custom Fields” table and its value in the “Project Field Values” table, or further the value’s display information in the “Lookup Table Values” table.

For developers to access the project custom fields’ information programmatically, the following out of box Project Server 2010 web service will come in handy:

SharePoint_Blog_How_Project_Server_2010_Store_Custom_Field_Values

Please check the following MSDN article for the full information of each web service:

http://msdn.microsoft.com/en-us/library/ee767707.aspx

By: Yi Fan Tang

        

 Subscribe

  GigWerks RSS  Gig Werks Mailing List 

 Contact Us

 Connect

 Resources

 On Demand SharePoint Webcast Recordings
 Upcoming Webinars
 SharePoint Resources
 Business Intelligence Resources
 Gig Werks Website



©2009 Gig Werks. All rights reserved. Privacy Policy