SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

It's been tough finding good material on Project Server/SharePoint integration from a development standpoint.

What I'd like to do is create a web part that can be deployed to any sharepoint site, that gets all reminders (Tasks, timelines, timecards, issues, risks etc...) for a given SPUser.

It seems to me I need to be able to do the following:

  1. Find Project Server Site in current Farm/Site Collection
  2. Find all List Items where AssignedTo = SPUser
  3. Returns this collection for sorting, rendering etc...

I've seen a couple walkthroughs that demand you have a Project Server Web Part on the page to get that information, and I need to be able to do this without that dependency. Where do I start?

Can I do something like:

var rootSiteCol =SPContext.Current.Web.Site.WebApplication.Sites[0].Url
var ProjectSite = rootSiteCol.AllSitesAndWeb["Project"];
var Lists = ProjectSite.AllLists;
foreach(List in Lists)
    //Enumerate and win!!
share|improve this question

have you tried using caml to query all lists in sites and subsites?

<Where><Or><Eq><FieldRef Name="AssignedTo" LookupId="TRUE"/><Value Type="Integer"><UserID /></Value></Eq><Membership Type="CurrentUserGroups"><FieldRef Name="AssignedTo"/></Membership></Or></Where><OrderBy><FieldRef Name="DueDate"/></OrderBy>


you can use this ;) :

hope it helps :)

share|improve this answer
That looks like it's specific to SharePoint standard tasks, not Project Server tasks. It IS helpful, though. Upvote for you! – Wesley Sep 25 '12 at 22:54
up vote 0 down vote accepted

Never found an answer, but don't want to mark the incorrect answer

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.