EntitySet: ProjectBaselines (ProjectData service)

Office 2013

Last modified: October 05, 2012

In this article
Definition
Attributes
Parent element
Child elements

Specifies the collection of project baselines in the ReportingData schema.


<EntitySet Name="ProjectBaselines" EntityType="ReportingData.ProjectBaseline" />

Attribute

Value

Description

Name

ProjectBaselines

The name of the entity set.

EntityType

ReportingData.ProjectBaseline

The type of entity.

Element

Description

EntityContainer element: ReportingData

Contains definitions of entity sets for internal use in queries of the online Reporting database.

The ProjectBaselines entity set has a default maximum page limit of 200 project baselines in one query. For information about how to query for more than 200 project baselines, and how to get and set the page limit, see ProjectData - OData service reference.

The following statement uses LINQ query syntax to retrieve ProjectBaseline entity data from the OData interface of the Project Server reporting tables. To use the statement in an application, set a service reference to the ProjectDataService, and initialize the ReportingData context. The ProjectBaselines entity set can then be accessed as context.ProjectBaselines. For more information, see Querying OData feeds for Project 2013 reporting data.


    var query =
    from p in ProjectBaselines
    select new
    {
        ProjectName = p.ProjectName,
        StartDate = p.ProjectBaselineStartDate,
        EndDate = p.ProjectBaselineFinishDate,
        ProjectBaselineWork = p.ProjectBaselineWork,
        ProjectBaselineCost = p.ProjectBaselineCost
    };

The preceding statement can be written by using Lambda expression syntax, as follows:


    var query = ProjectBaselines
    .Select( p => new
    {
        ProjectName = p.ProjectName,
        StartDate = p.ProjectBaselineStartDate,
        EndDate = p.ProjectBaselineFinishDate,
        ProjectBaselineWork = p.ProjectBaselineWork,
        ProjectBaselineCost = p.ProjectBaselineCost
    });

Either statement creates the following REST URL (all on one line).

http://ServerName/pwa/_vti_bin/client.svc/ProjectServerData/ProjectBaselines()?
$select=ProjectName,ProjectBaselineStartDate,ProjectBaselineFinishDate,ProjectBaselineWork,ProjectBaselineCost


All three of the sample queries get the same data.

Sample results of the ProjectBaseline query

ProjectName

StartDate

EndDate

ProjectBaselineWork

ProjectBaselineCost

ProjectA

3/26/2012 8:00:00 AM

3/30/2012 5:00:00 PM

144.0 hrs

$2380.00

ProjectB

3/12/2012 8:00:00 AM

3/16/2012 5:00:00 PM

87.5 hrs

$1835.90

ProjectC

3/12/2012 8:00:00 AM

3/17/2012 5:00:00 PM

112.0 hrs

$1872.00

Show:
© 2014 Microsoft