本帖最后由 spiral 于 2013-4-27 18:06 编辑
- select distinct doc.id ID,doc.formid FORMID,fs.flowid FLOWID,rhis.flowname item_FLOWNAME,pen.lastprocesstime LASTPROCESSTIME,doc.statelabel item_STATELABEL,convert(varchar(1000),pen.summary) as item_SUBJECT,convert(varchar(2000),doc.AUDITORNAMES) as item_AUDITORNAMES,convert(varchar(2000),doc.AUDITORLIST) as
- AUDITORLIST,doc.APPLICATIONID,doc.DOMAINID from DBO.T_DOCUMENT doc,DBO.T_ACTORHIS ahis,DBO.T_RELATIONHIS rhis,DBO.T_FLOW_INTERVENTION pen,DBO.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.issubdoc is null and doc.parent is null and doc.state is not null and doc.statelabel is not null and ahis.actorid in ('"+value+"')
复制代码 “value”为用户id
数据库执行时正常,平台报错
|