怎么实现用户信息 我的工作 的功能

我想在首页实现 我的工作的功能
如何下的效果
  
请问如何实现

您好，您可以参考一下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