如何查询已办事项

我想用sql语句查询出用户曾经审核过的文档，请问有没有什么列子可以提供一下？

==我找下资料。看有不。

您参考下下面那段sql:
SELECT * FROM ( SELECT * FROM (SELECT DISTINCT doc.id DOCID,doc.formid FORMID,fs.flowid FLOWID,rhis.flowname FLOWNAME,doc.statelabel STATELABEL,pen.summary SUBJECT,doc.AUDITORNAMES,doc.AUDITORLIST,doc.APPLICATIONID,doc.DOMAINID  FROM  OBPMAPP.T_DOCUMENT  doc,OBPMAPP.T_ACTORHIS ahis,OBPMAPP.T_RELATIONHIS rhis,OBPMAPP.T_FLOW_INTERVENTION pen,OBPMAPP.T_FLOWSTATERT fs,OBPMAPP.T_NODERT node,OBPMAPP.T_ACTORRT actor  WHERE doc.id=rhis.docid AND rhis.id = ahis.nodehis_id AND doc.id = pen.id AND doc.id =fs.docid AND fs.id =node.flowstatert_id AND  node.id = actor.nodert_id AND doc.issubdoc IS NULL AND doc.parent IS NULL AND doc.state IS NOT NULL AND  doc.statelabel IS NOT NULL  AND (actor.actorid IN ('11de-c13a-0cf76f8b-a3db-1bc87eaaad4c') OR ahis.actorid IN ('11de-c13a-0cf76f8b-a3db-1bc87eaaad4c')) ORDER BY doc.formid,fs.flowid) table_0 WHERE table_0.DOMAINID ='11de-c138-782d2f26-9a62-8bacb70a86e1' ) AS TB LIMIT 0,10

回复 3# shary


    这个好像是查看所有的已办啊，实在看不懂，能不能帮忙精减一下。只查看一个文档的已办

稍等。我去试一下。

您好，如果你要查单条的加一个条件
SELECT * FROM
( SELECT * FROM
(SELECT DISTINCT doc.id DOCID,doc.formid FORMID,fs.flowid FLOWID,rhis.flowname FLOWNAME,doc.statelabel STATELABEL,pen.summary SUBJECT,doc.AUDITORNAMES,doc.AUDITORLIST,doc.APPLICATIONID,doc.DOMAINID
FROM
OBPMAPP.T_DOCUMENT  doc,OBPMAPP.T_ACTORHIS ahis,OBPMAPP.T_RELATIONHIS rhis,OBPMAPP.T_FLOW_INTERVENTION pen,OBPMAPP.T_FLOWSTATERT fs,OBPMAPP.T_NODERT node,OBPMAPP.T_ACTORRT actor  
WHERE
doc.id=rhis.docid
AND
rhis.id = ahis.nodehis_id
AND
doc.id = pen.id
AND
doc.id =fs.docid
AND
fs.id =node.flowstatert_id
AND
  node.id = actor.nodert_id
AND
doc.issubdoc IS NULL
AND
doc.parent IS NULL
AND
doc.state IS NOT NULL
AND
  doc.statelabel IS NOT NULL  
AND
(actor.actorid IN ('11de-c13a-0cf76f8b-a3db-1bc87eaaad4c') OR ahis.actorid IN ('11de-c13a-0cf76f8b-a3db-1bc87eaaad4c')) and doc.id='11e0-a929-caac2f54-ae76-59eeabe80b43' ORDER BY doc.formid,fs.flowid) table_0 WHERE table_0.DOMAINID ='11de-c138-782d2f26-9a62-8bacb70a86e1' ) AS TB LIMIT 0,10
红色粗体部分就是要查询的单条doc的id值。你参考下。谢谢

回复 6# shary


    actor.actorid IN ('11de-c13a-0cf76f8b-a3db-1bc87eaaad4c') OR ahis.actorid IN ('11de-c13a-0cf76f8b-a3db-1bc87eaaad4c'))
这两个ID分别是什么呀？

当前登录用户的UserId