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