microsoft project server
enterprise project outline code
1
select
CODE_UID,OC_PARENT,OC_FIELD_ID,OC_NAME,OC_DESCRIPTION
2![None.gif](/Images/OutliningIndicators/None.gif)
3
FROM
MSP_OUTLINE_CODES
4![None.gif](/Images/OutliningIndicators/None.gif)
5
WHERE
6![None.gif](/Images/OutliningIndicators/None.gif)
7
PROJ_ID
=
423
AND
8![None.gif](/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
![None.gif](/Images/OutliningIndicators/None.gif)
2
![None.gif](/Images/OutliningIndicators/None.gif)
3
![None.gif](/Images/OutliningIndicators/None.gif)
4
![None.gif](/Images/OutliningIndicators/None.gif)
5
![None.gif](/Images/OutliningIndicators/None.gif)
6
![None.gif](/Images/OutliningIndicators/None.gif)
7
![None.gif](/Images/OutliningIndicators/None.gif)
8
![None.gif](/Images/OutliningIndicators/None.gif)
9
![None.gif](/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