microsoft project server
enterprise project outline code
1
SELECT A.ATTRIB_FIELD_ID,B.AS_VALUE
2![](/Images/OutliningIndicators/None.gif)
3
FROM
4![](/Images/OutliningIndicators/None.gif)
5
MSP_FIELD_ATTRIBUTES A,
6![](/Images/OutliningIndicators/None.gif)
7
MSP_ATTRIBUTE_STRINGS B
8![](/Images/OutliningIndicators/None.gif)
9
WHERE
10![](/Images/OutliningIndicators/None.gif)
11
A.PROJ_ID = B.PROJ_ID
12![](/Images/OutliningIndicators/None.gif)
13
AND A.AS_ID = B.AS_ID
14![](/Images/OutliningIndicators/None.gif)
15
AND A.ATTRIB_FIELD_ID >= 188744529
16![](/Images/OutliningIndicators/None.gif)
17
AND A.ATTRIB_FIELD_ID <= 188744768
18![](/Images/OutliningIndicators/None.gif)
19
AND A.ATTRIB_ID = 206
20![](/Images/OutliningIndicators/None.gif)
21
AND A.PROJ_ID = 424
22![](/Images/OutliningIndicators/None.gif)
23
ORDER BY A.ATTRIB_FIELD_ID
![](/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)
10
![](/Images/OutliningIndicators/None.gif)
11
![](/Images/OutliningIndicators/None.gif)
12
![](/Images/OutliningIndicators/None.gif)
13
![](/Images/OutliningIndicators/None.gif)
14
![](/Images/OutliningIndicators/None.gif)
15
![](/Images/OutliningIndicators/None.gif)
16
![](/Images/OutliningIndicators/None.gif)
17
![](/Images/OutliningIndicators/None.gif)
18
![](/Images/OutliningIndicators/None.gif)
19
![](/Images/OutliningIndicators/None.gif)
20
![](/Images/OutliningIndicators/None.gif)
21
![](/Images/OutliningIndicators/None.gif)
22
![](/Images/OutliningIndicators/None.gif)
23
![](/Images/OutliningIndicators/None.gif)
需要注意的是
proj_ID 是改变的,一旦修改了企业自定义大纲代码它就会改变。
它是怎么来的呢?
可以根据
这个存储过程得到exec MSP_PDS_ReadGlobalInfo
这是存储过程定义
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
这个查询的with 子句指定了查询时候使用的索引。
查询结果是
ATTRIB_FIELD_ID AS_VALUE
188744589 Project Status
188744590 Project Category
188744591 Project Phase
188744592 Product Development Manager
188744593 Project Manager
188744594 Project Assistant
188744729 Remark