How to read the custom domain and outline code of the MPP file from the project database

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.