First, I rename the following Enterprise Domain and enterprise outline in the Enterprise Domain of the Project Server.Code:
Task cost enterprise cost 1 (enterprise cost 1)
Task mark 2 Enterprise mark 2
Task construction period enterprise construction period 1
Task date enterprise date 1
Task digital enterprise number 3
Task text 2 Enterprise text 2
Task enterprise outline code 1
Task enterprise outline Code 2
Note (the above Enterprise Domain and enterprise outline code belong to the task category)
The specific SQL statement is as follows:
Select msp_view_proj_tasks_std.taskname as 'Task name', msp_outline_codes.oc_name as 'outline code 1 ',
Msp_outline_codes_1.oc_name as 'outline code 2', msp_view_proj_tasks_ent.taskenterprisecost1/100 as 'Task cost ',
Msp_view_proj_tasks_ent.taskenterprisedate1 as 'Task date', msp_view_proj_tasks_ent.taskenterpriseduration1/4800 as 'Task schedule ',
Msp_view_proj_tasks_ent.taskenterpriseflag2 as 'Task flag', msp_view_proj_tasks_ent.taskenterprisenumber3 as 'Task number ',
Msp_view_proj_tasks_ent.taskenterprisetext2 as 'Task text'
From msp_view_proj_tasks_ent inner join
Msp_view_proj_tasks_std on msp_view_proj_tasks_ent.wproj_id = msp_view_proj_tasks_std.wproj_id and
Msp_view_proj_tasks_ent.ent_taskuniqueid = msp_view_proj_tasks_std.taskuniqueid inner join
Msp_outline_codes on msp_view_proj_tasks_ent.taskenterpriseoutlinecode1id = msp_outline_codes.code_uid inner join
Msp_outline_codes as msp_outline_codes_1 on
Msp_view_proj_tasks_ent.taskenterpriseoutlinecode2id = msp_outline_codes_1.code_uid inner join
Msp_projects on msp_outline_codes.proj_id = msp_projects.proj_id and
Msp_outline_codes_1.proj_id = msp_projects.proj_id
Where (msp_view_proj_tasks_ent.ent_projectuniqueid = 43) and (msp_projects.proj_type = 2)
Order by msp_view_proj_tasks_ent.ent_taskuniqueid
For details, see Project 2003 data documents pjdb. htm and pjsvrdb. htm database documents.