关于视图过滤所有待办问题

视图sql代码如下（数据库为sqlserver）：

1. var user = getWebUser();
   
2. var userid= user.getId();
   
3. var domainid = getDomainid();
   
4. 
   
5. var sql="SELECT * FROM ( SELECT * FROM (";
   
6. sql+="select distinct doc.id DOCID,doc.DOMAINID,doc.formid FORMID,doc.AUDITORNAMES,";
   
7. sql+="doc.AUDITORLIST,doc.APPLICATIONID,doc.statelabel item_STATELABEL,";
   
8. sql+="fs.flowid FLOWID,pen.flowname item_FLOWNAME,pen.summary item_SUBJECT";
   
9. sql+=" from  T_DOCUMENT doc,T_FLOW_INTERVENTION pen,T_FLOWSTATERT fs,T_NODERT node,T_ACTORRT actor  ";
   
10. sql+=" where doc.id = pen.id and doc.id =fs.docid and fs.id =node.flowstatert_id and  node.id = actor.nodert_id ";
    
11. sql+=" and doc.parent is null and doc.state is not null and doc.statelabel is not null  ";
    
12. sql+=" and actor.actorid in ('"+userid+"')) table_0 ";
    
13. sql+=" WHERE table_0.DOMAINID ='"+domainid +"') AS TB LIMIT 0,10";
    
14. println("===sql=="+sql);
    
15. sql;
    

复制代码

列脚本为：

1. var value=getItemValueAsString("SUBJECT");
   
2. value;

复制代码

但在前台视图点击列，进去后显示红叉

亲啊。您之前不是提过了吗？http://www.teemlink.com/bbs/view ... peid%3D2&page=2 不是帮你修改好了么？您自己先通过打印语句定位一下错在哪，看错误信息提示。

问题已解决