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?.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional listbox cell populating 4
How to import multiple projects into 2007 in one go? 1
Space at end of multi page list to accommodate new entries 1
programmatically get all projects from published store 0
Project Server 2007 - errors while publishing projects updated thr 0
How to build a query that returns a list of projects + values ofproject custom fields 2
Modifying .aspx file in Project Server 2007 2
Can't view projects in Project Center 18

Top