none
PS2010 - How can I retrieve a filtered list of projects from PSI ? RRS feed

  • Question

  • Hello,

    How can I retrieve a filtered list of projects via PSI ? I have tried with the Project web service with the ReadProjectStatus method, but there's no filtering feature.

    There's also the ProjectGetProjectCenterProjectsForGridJson method in the internal PWA web service, which is actually undocumented, thus unusable...

    Do you have any idea how to achieve this ?

    Wednesday, June 5, 2013 1:43 PM

All replies

  • Hi, maybe you can try PSLib.Filter

    Example:

            /// <summary>
            /// ReadResourcesByName
            /// </summary>
            /// <param name="resourceName">resourceName</param>
            /// <returns>DataView</returns>
            public SvcResource.ResourceDataSet ReadResourcesByName(string resourceName)
            {
                ResourceDataSet _ResourceDataSet = new ResourceDataSet();

                PSLib.Filter resourceFilter = GetResourceFilter();

                if (!string.IsNullOrEmpty(resourceName))
                {
                    PSLib.Filter.FieldOperator existingResourceName = new PSLib.Filter.FieldOperator(PSLib.Filter.FieldOperationType.Contain, _ResourceDataSet.Resources.RES_NAMEColumn.ColumnName, resourceName);
                    resourceFilter.Criteria = existingResourceName;
                }
                string filterXml = resourceFilter.GetXml();

                return ReadResources(filterXml, false);
            }


    Javier Perez | VP | Sr. Technical Architect | MCPD:Enterprise, MCPD:Web, MCITP:Database Dev, MCAD, MCTS:SharePoint | Monterrey, Mexico.

    Wednesday, June 5, 2013 2:49 PM
  • Thank you but it's completely off topic.
    Wednesday, June 5, 2013 2:51 PM