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
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" wrote: > 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
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. "Andrew Jacks" wrote: > 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" wrote: > > > 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
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" wrote: > 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. > > "Andrew Jacks" wrote: > > > 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" wrote: > > > > > 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
Thank you. Didn't know that. "Chris Boyd" wrote: > 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" wrote: > > > 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. > > > > "Andrew Jacks" wrote: > > > > > 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" wrote: > > > > > > > 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
