Projects List Populating in aspx page.

M

mahesh

Hi
I am creating a Custom aspx page in that I need to populate all projects
list from Project server 2007 for this i have writen a query in this way

SELECT ProjectUID, ProjectName, ProjectOwnerResourceUID FROM
MSP_EpmProject_UserView WHERE ProjectAuthorName = '" +
Request.ServerVariables["AUTH_USER"]; + "'

My intention is i need to populate only those projects he has created.That
is working

My Problem is If that user is Administrator in Project Server 2007 We need
to Display all the projects.
I am unable to Fetch the Projects Based on the Admin flag.

How to write the Query for that?.
 
Top