SharePoint Events

 ProjectReady Applications for the AEC
 8/23/2016 - Webcast: What's New in Document Management for SharePoint 2016 & Online
 8/24/2016 - Webcast: AEC Project & Program Management Made Easy in SharePoint & Office 365
 8/25/2016 - Webcast: Legal Matters Management in SharePoint & Microsoft Outlook
 9/22/2016 - Webcast: Modernizing the Enterprise with SharePoint
 9/27/2016 - Webcast: Legal Email Management and Routing with Microsoft Outlook
 9/28/2016 - Webcast: Document Control for the AEC with SharePoint – RFI, Transmittal & Submittal Management
 9/29/2016 - Webcast: Project & Program Management with SharePoint
(More Links...)

 SharePoint Videos

 Security & Sharing in SharePoint 2016, Online & Office 365
 Enterprise Records Management in SharePoint & Office 365
 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
(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