- 帖子
- 62
- 主題
- 10
- 精華
- 0
- 積分
- 253
- 點名
- 0
- 作業系統
- xp , win7
- 軟體版本
- office2003
- 閱讀權限
- 20
- 性別
- 男
- 來自
- 人心
- 註冊時間
- 2010-5-21
- 最後登錄
- 2012-8-3
|
2#
發表於 2011-5-28 10:43
| 只看該作者
解出來了- select *
- from WorkItem W,ProcessInstance P ,
- (SELECT MAX(P1.createdTime ) AS m FROM WorkItem W1 ,ProcessInstance P1
- Where P1.contextOID= W1.contextOID
- And P1.processDefinitionId='PerformanceAssessment_003'
- And W1.workItemName='自評填寫'
- And W1.performerOID in (
- select Us.OID,uid,ddate,depId,umasterId,cdepId
- from
- Users Us,
- PerformanceAssessment_007_Grid0 G0,
- (SELECT MAX(formSerialNumber) AS m ,performerOID FROM PerformanceAssessment_007_Grid0 PG0
- Where PG0.depId ='J010'
- And PG0.ddate='2011-上半年'
- And PG0.umasterId='MH0433') AS C
- where
- G0.formSerialNumber = C.m
- And G0.depId= 'J010'
- And ddate='2011-上半年'
- And umasterId='MH0433'
- AND Us.id = uid
- )
- GROUP BY W1.performerOID) AS B
- where
- P.contextOID=W.contextOID
- And P.processDefinitionId='PerformanceAssessment_003'
- And workItemName='自評填寫'
- And performerOID in (B.performerOID)
- And P.createdTime =B.m
- And P.currentState in ('3','1')
複製代碼 |
|