视图如何用sql模式查询自己处理过的跟单

视图如何用sql模式查询自己处理过的跟单

已办记录
var sql = "select * from tlk_stamp_carving where id in (select doc.mappingid from  T_DOCUMENT  doc,T_ACTORHIS ahis,T_RELATIONHIS rhis,T_FLOW_INTERVENTION pen,T_FLOWSTATERT fs where doc.id=rhis.docid and rhis.id = ahis.nodehis_id and doc.id = pen.id and doc.id =fs.docid and doc.parent is null and doc.state is not null and doc.statelabel is not null and doc.statelabel <> '未提交' and doc.formid='11e4-7088-f1ad0a64-84b2-818effacfb3f' and ahis.actorid in ('"+getWebUser().getId()+"'))";这个SQL语句是查询已经处理过的流程