如何查询已办事项

【myApps/OBPM版本号】：v4.4- sp XX
【浏览器类型】：Chrome/其他
【联系方式-QQ】：请留下您的QQ号码
【联系电话】:    请留下您的联系电话，以便技术同事更好解决您的问题
【问题描述】：如何查询已办事项









1、参考下下面那段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