SharePoint Events

  5/06/2014 - Webcast: Advanced Workflow, Forms and Mobility in Office 365 and SharePoint 2013 from Nintex
  5/07/2014 - Webcast: View, Annotate and Secure your Content Anywhere and on Any Device in SharePoint 2013
  5/08/2014 - Webcast: Advanced Records Management with SharePoint

 SharePoint Videos

  Why SharePoint 2013
  Keys to Successful SharePoint Initiatives and User Adoption
  Out of the Box Business Intelligence and Reporting in SharePoint 2013
  Driving the Business Case and User Adoption for SharePoint
  Automate Business Processes with SharePoint 2013 and Business Connectivity Services
  SharePoint and Office 365 Migration Made Easy
  Full Lifecycle Content Management with SharePoint 2013
  Compliant Document Generation and Assembly in SharePoint
  Application of Content Security and Corporate Risk Protection in SharePoint
  How to Redline, Markup, Collaborate and Review Content in SharePoint
  Advanced Content Lifecycle and Records Management in SharePoint
  Advanced Workflow Made Easy with SharePoint 2013 and Nintex
  Full Lifecycle Content Management with SharePoint 2013
  SharePoint 2013 Solutions for the Financial Services Industry
  ProjectReady 2013: SharePoint Solutions built for the AEC
  SharePoint 2013 Solutions for the Legal Industry
  Driving the Business Case and User Adoption for SharePoint
  Investment Considerations for SharePoint 2010 and SharePoint 2013
  SharePoint 2013 and Enterprise Content Management
  SharePoint 2013 Launch
(More Links...)

 Archives

Opening SharePoint Links in a new windowUse SHIFT+ENTER to open the menu (new window).
Mail Enabled Lists vs. The Missing Windows 2008 POP3/IMAP Server Use SHIFT+ENTER to open the menu (new window).
7 Tools for SharePoint DevelopersUse SHIFT+ENTER to open the menu (new window).
Public Facing Masterpage TechniquesUse SHIFT+ENTER to open the menu (new window).
How to Quickly Deploy and Activate a Timer Service to Your Site CollectionUse SHIFT+ENTER to open the menu (new window).
Custom SharePoint Master Page Feature with WSP BuilderUse SHIFT+ENTER to open the menu (new window).
Date Math with InfoPathUse SHIFT+ENTER to open the menu (new window).
Enterprise Search Tricks and Tips Part 1Use SHIFT+ENTER to open the menu (new window).
Populating Word Documents With SharePoint Data. Try The DIP!Use SHIFT+ENTER to open the menu (new window).
Programmatic Deep Dive into Blank SharePoint Lookup ColumnsUse SHIFT+ENTER to open the menu (new window).
1 - 10 Next
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

        

Comments

There are no comments yet for this post.
Items on this list require content approval. Your submission will not appear in public views until approved by someone with proper rights. More information on content approval.

Your Name *


e-mail address *


Website (optional)


Comment *


Attachments

 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