微软项目管理[EPM]数据库剖析2:如何取得全局项目中某个大纲代码的列表值
关键字:
microsoft project server
enterprise project outline code
microsoft project server
enterprise project outline code
1
select CODE_UID,OC_PARENT,OC_FIELD_ID,OC_NAME,OC_DESCRIPTION
2![](/Images/OutliningIndicators/None.gif)
3
FROM MSP_OUTLINE_CODES
4![](/Images/OutliningIndicators/None.gif)
5
WHERE
6![](/Images/OutliningIndicators/None.gif)
7
PROJ_ID = 423 AND
8![](/Images/OutliningIndicators/None.gif)
9
OC_CACHED_IS_VALID > 0 AND OC_FIELD_ID IN (188744592) AND CODE_UID > 0 ORDER BY OC_FIELD_ID,CODE_UID
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/None.gif)
3
![](/Images/OutliningIndicators/None.gif)
4
![](/Images/OutliningIndicators/None.gif)
5
![](/Images/OutliningIndicators/None.gif)
6
![](/Images/OutliningIndicators/None.gif)
7
![](/Images/OutliningIndicators/None.gif)
8
![](/Images/OutliningIndicators/None.gif)
9
![](/Images/OutliningIndicators/None.gif)
至于这里PROJ_ID也是全局项目模板ID
188744592 是大纲代码的域ID
查询结果
CODE_UID OC_PARENT OC_FIELD_ID oc_name
89 0 188744592 lucy.goole
90 0 188744592 lemonade.jiang