How to build a query that returns a list of projects + values ofproject custom fields

[Maxwell Anderson]

How to build a query that returns a list of projects + values of
project custom fields? I consulted the Project 2007 SDK, schema of
reporting DB, but did not find anything.

 

[Stephen Sanderlin]

Use the MSP_EpmProject_UserView view for your query. This view is
updated whenever a custom field is added or updated to include the
custom field information. It should appear at the far right side of the
view.

--

Stephen Sanderlin

Principal Consultant

MSProjectExperts



For Project Server Consulting: http://www.msprojectexperts.com

For Project Server Training: http://www.projectservertraining.com



Read my blog at: http://www.projectserverhelp.com/

Join the community at: http://forums.epmfaq.com

 

[Maxwell Anderson]

Use the MSP_EpmProject_UserView view for your query. This view is
updated whenever a custom field is added or updated to include the
custom field information. It should appear at the far right side of the
view.

--

Stephen Sanderlin

Principal Consultant

MSProjectExperts

For Project Server Consulting:http://www.msprojectexperts.com

For Project Server Training:http://www.projectservertraining.com

Read my blog at:http://www.projectserverhelp.com/

Join the community at:http://forums.epmfaq.com






- Show quoted text -

Okay Stephen Sanderlin, thank you.