select
t.name as projectType,--项目类型
p.namecontainerinfo as projectName,--项目名称
p.projectnumber as projectNumber,--项目编号
p.phase ,--项目阶段
(select u1.name from WTUser u1 where u1.ida2a2=p.ida3e2containerinfo) as
projectOwnerName,--项目所有者用户名
(select u1.fullname from WTUser u1 where u1.ida2a2=p.ida3e2containerinfo) as projectOwnerFullname,--项目所有者全名
a.name as taskName,--任务名
a.startdate as planStartDate,--任务计划开始时间
a.finishdate as planFinishDate,--任务计划完成时间
u.fullname as taskOwnerFullname,--任务负责人全名
u.name as taskOwnerName--任务负责人用户名
from planactivity a,Project2 p,wttypedefinition t,WTUser u
where a.ida3containerreference = p.ida2a2
and a.ida3a2ownership=u.ida2a2(+)
and a.plannableState='INPROCESS'
and p.idA2typeDefinitionReference=t.ida2a2
Windchill系统处理中项目任务视图
最新推荐文章于 2024-07-22 18:42:29 发布