A
andrea molinari
Hello
I need to get some personalized fields from project server. I read
different approaches, and I tried my methods, joining tables as
explained in the documentation, but I'm getting different results based
on different approaches.
In particular, I need to get some enterprise project outline codes, the
RBS value and some other enterprise task personalized values. Can
someone outline the *best* and *safest* way to get these values?
I directly went on MSP_WEB_ and MSP_OUTLINE_CODES, but had some
problems with project ID references, because some enterprise fields are
not related with my test wproj_id. Then I read that is always better to
use the MSP_VIEW_ tables (???), but some fields are missing, and so I
have to join back to a mix of MSP_ and MSP_WEB tables. Then I
discovered that the proj_id of MSP_OUTLINE_CODES references to a global
template, but with this ID I get only a part of the personalized codes,
not all. I tried with left joins, but same results. Any help or final
reference to look at?
Thank you
AM
I need to get some personalized fields from project server. I read
different approaches, and I tried my methods, joining tables as
explained in the documentation, but I'm getting different results based
on different approaches.
In particular, I need to get some enterprise project outline codes, the
RBS value and some other enterprise task personalized values. Can
someone outline the *best* and *safest* way to get these values?
I directly went on MSP_WEB_ and MSP_OUTLINE_CODES, but had some
problems with project ID references, because some enterprise fields are
not related with my test wproj_id. Then I read that is always better to
use the MSP_VIEW_ tables (???), but some fields are missing, and so I
have to join back to a mix of MSP_ and MSP_WEB tables. Then I
discovered that the proj_id of MSP_OUTLINE_CODES references to a global
template, but with this ID I get only a part of the personalized codes,
not all. I tried with left joins, but same results. Any help or final
reference to look at?
Thank you
AM