Locating Custom Enterprise Field in Table

[Sinister]

I've created a custom enterprise field and now I need to locate what table
that information is stored in. Can anyone help me?

Thansk,
Patrick

 

[Andrew Jacks]

Patrick,

The best place to get access to your custom fields is from views within the
Project Server Report.

For projects look at MSP_EpmProject_UserView
Tasks MSP_EpmTask_UserView
etc.

Unfortunaltly the Projects have to have been publish for this data to be
availiable.

Hope this helps

 

[Sinister]

I also found the table that shows the non-published projects. It's a draft
table.

Thanks for the assistance, it helped point me in the right direction.

 

[Chris Boyd]

Just remember that reading data from the draft DB is not supported and you
run the risk of a patch/service pack install breaking you. If you need to get
the data from the draft DB, you should use the PSI to get at the information.
--
Chris Boyd
MS Project
Program Manager

Blog: http://blogs.msdn.com/project_programmability/

 

[Sinister]

Thank you. Didn't know that.

Just remember that reading data from the draft DB is not supported and you
run the risk of a patch/service pack install breaking you. If you need to get
the data from the draft DB, you should use the PSI to get at the information.
--
Chris Boyd
MS Project
Program Manager

Blog: http://blogs.msdn.com/project_programmability/