后台查询数据前台用树形展示

15030479317

请问我后台查询出的数据,关联bizData数据源设置了treeOption参数.前台用grid展示.为什么页面显示不出数据来??这是怎么回事???

jishuang

把sql语句输出看看执行的sql是什么
http://bbs.wex5.com/forum.php?mo ... 4&pid=165004035

15030479317

jishuang 发表于 2017-7-13 14:12
把sql语句输出看看执行的sql是什么
http://bbs.wex5.com/forum.php?mod=redirect&goto=findpost&ptid=33524 ...

控制台信息

jishuang

压缩包有问题重新发一下

15030479317

jishuang 发表于 2017-7-13 15:00
压缩包有问题重新发一下

控制台信息

jishuang

一样，直接发控制台的错误信息吧

15030479317

jishuang 发表于 2017-7-13 16:24
一样，直接发控制台的错误信息吧

2017-07-13 16:20:11                |-->完成 CompExpressionNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=COM_DynamicView.SWHERE AS sWhere, COM_DynamicView.SNAME AS sName, COM_Management.SORGID AS sOrgID, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM COM_Management COM_Management LEFT JOIN COM_DynamicView COM_DynamicView ON  (COM_DynamicView.sID = COM_Management.SDYNAMICVIEWID) OR (COM_Management.SDYNAMICVIEWID IS NULL) , binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SVALIDSTATE = ?, binds=[1]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SCONCEPT =  ? , binds=[com.justep.system.ksql.node.VariableNode@5ffb2]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SPROCESS =  ? , binds=[com.justep.system.ksql.node.VariableNode@20ae10]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SPROCESS IS NULL, binds=[]>]>]
2017-07-13 16:20:11             |-->完成 LogicalExpressionNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=COM_DynamicView.SWHERE AS sWhere, COM_DynamicView.SNAME AS sName, COM_Management.SORGID AS sOrgID, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM COM_Management COM_Management LEFT JOIN COM_DynamicView COM_DynamicView ON  (COM_DynamicView.sID = COM_Management.SDYNAMICVIEWID) OR (COM_Management.SDYNAMICVIEWID IS NULL) , binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SVALIDSTATE = ?, binds=[1]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SCONCEPT =  ? , binds=[com.justep.system.ksql.node.VariableNode@5ffb2]>]>, <SQLValue dimension=1, values=[<OneValue exp= (COM_Management.SPROCESS =  ? ) OR (COM_Management.SPROCESS IS NULL) , binds=[com.justep.system.ksql.node.VariableNode@20ae10]>]>]
2017-07-13 16:20:11             |-->开始 LogicalExpressionNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=COM_DynamicView.SWHERE AS sWhere, COM_DynamicView.SNAME AS sName, COM_Management.SORGID AS sOrgID, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM COM_Management COM_Management LEFT JOIN COM_DynamicView COM_DynamicView ON  (COM_DynamicView.sID = COM_Management.SDYNAMICVIEWID) OR (COM_Management.SDYNAMICVIEWID IS NULL) , binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SVALIDSTATE = ?, binds=[1]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SCONCEPT =  ? , binds=[com.justep.system.ksql.node.VariableNode@5ffb2]>]>, <SQLValue dimension=1, values=[<OneValue exp= (COM_Management.SPROCESS =  ? ) OR (COM_Management.SPROCESS IS NULL) , binds=[com.justep.system.ksql.node.VariableNode@20ae10]>]>]

15030479317

15030479317 发表于 2017-7-13 16:29
2017-07-13 16:20:11                |-->完成 CompExpressionNode, stack:[, , , , , ]
2017-07-13 16:2 ...

2017-07-13 16:20:11                |-->开始 CompExpressionNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=COM_DynamicView.SWHERE AS sWhere, COM_DynamicView.SNAME AS sName, COM_Management.SORGID AS sOrgID, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM COM_Management COM_Management LEFT JOIN COM_DynamicView COM_DynamicView ON  (COM_DynamicView.sID = COM_Management.SDYNAMICVIEWID) OR (COM_Management.SDYNAMICVIEWID IS NULL) , binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SVALIDSTATE = ?, binds=[1]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SCONCEPT =  ? , binds=[com.justep.system.ksql.node.VariableNode@5ffb2]>]>, <SQLValue dimension=1, values=[<OneValue exp= (COM_Management.SPROCESS =  ? ) OR (COM_Management.SPROCESS IS NULL) , binds=[com.justep.system.ksql.node.VariableNode@20ae10]>]>]
2017-07-13 16:20:11                   |-->开始 OneRelationNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=COM_DynamicView.SWHERE AS sWhere, COM_DynamicView.SNAME AS sName, COM_Management.SORGID AS sOrgID, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM COM_Management COM_Management LEFT JOIN COM_DynamicView COM_DynamicView ON  (COM_DynamicView.sID = COM_Management.SDYNAMICVIEWID) OR (COM_Management.SDYNAMICVIEWID IS NULL) , binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SVALIDSTATE = ?, binds=[1]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SCONCEPT =  ? , binds=[com.justep.system.ksql.node.VariableNode@5ffb2]>]>, <SQLValue dimension=1, values=[<OneValue exp= (COM_Management.SPROCESS =  ? ) OR (COM_Management.SPROCESS IS NULL) , binds=[com.justep.system.ksql.node.VariableNode@20ae10]>]>]
2017-07-13 16:20:11                   |-->完成 OneRelationNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=COM_DynamicView.SWHERE AS sWhere, COM_DynamicView.SNAME AS sName, COM_Management.SORGID AS sOrgID, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM COM_Management COM_Management LEFT JOIN COM_DynamicView COM_DynamicView ON  (COM_DynamicView.sID = COM_Management.SDYNAMICVIEWID) OR (COM_Management.SDYNAMICVIEWID IS NULL) , binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SVALIDSTATE = ?, binds=[1]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SCONCEPT =  ? , binds=[com.justep.system.ksql.node.VariableNode@5ffb2]>]>, <SQLValue dimension=1, values=[<OneValue exp= (COM_Management.SPROCESS =  ? ) OR (COM_Management.SPROCESS IS NULL) , binds=[com.justep.system.ksql.node.VariableNode@20ae10]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SACTIVITY, binds=[]>]>]
2017-07-13 16:20:11                   |-->开始 VariableNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=COM_DynamicView.SWHERE AS sWhere, COM_DynamicView.SNAME AS sName, COM_Management.SORGID AS sOrgID, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM COM_Management COM_Management LEFT JOIN COM_DynamicView COM_DynamicView ON  (COM_DynamicView.sID = COM_Management.SDYNAMICVIEWID) OR (COM_Management.SDYNAMICVIEWID IS NULL) , binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SVALIDSTATE = ?, binds=[1]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SCONCEPT =  ? , binds=[com.justep.system.ksql.node.VariableNode@5ffb2]>]>, <SQLValue dimension=1, values=[<OneValue exp= (COM_Management.SPROCESS =  ? ) OR (COM_Management.SPROCESS IS NULL) , binds=[com.justep.system.ksql.node.VariableNode@20ae10]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SACTIVITY, binds=[]>]>]

15030479317

15030479317 发表于 2017-7-13 16:29
2017-07-13 16:20:11                |-->开始 CompExpressionNode, stack:[, , , , ]
2017-07-13 16:20: ...

2017-07-13 16:20:11                   |-->完成 VariableNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=COM_DynamicView.SWHERE AS sWhere, COM_DynamicView.SNAME AS sName, COM_Management.SORGID AS sOrgID, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM COM_Management COM_Management LEFT JOIN COM_DynamicView COM_DynamicView ON  (COM_DynamicView.sID = COM_Management.SDYNAMICVIEWID) OR (COM_Management.SDYNAMICVIEWID IS NULL) , binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SVALIDSTATE = ?, binds=[1]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SCONCEPT =  ? , binds=[com.justep.system.ksql.node.VariableNode@5ffb2]>]>, <SQLValue dimension=1, values=[<OneValue exp= (COM_Management.SPROCESS =  ? ) OR (COM_Management.SPROCESS IS NULL) , binds=[com.justep.system.ksql.node.VariableNode@20ae10]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SACTIVITY, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp= ? , binds=[com.justep.system.ksql.node.VariableNode@fed523]>]>]
2017-07-13 16:20:11                |-->完成 CompExpressionNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=COM_DynamicView.SWHERE AS sWhere, COM_DynamicView.SNAME AS sName, COM_Management.SORGID AS sOrgID, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM COM_Management COM_Management LEFT JOIN COM_DynamicView COM_DynamicView ON  (COM_DynamicView.sID = COM_Management.SDYNAMICVIEWID) OR (COM_Management.SDYNAMICVIEWID IS NULL) , binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SVALIDSTATE = ?, binds=[1]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SCONCEPT =  ? , binds=[com.justep.system.ksql.node.VariableNode@5ffb2]>]>, <SQLValue dimension=1, values=[<OneValue exp= (COM_Management.SPROCESS =  ? ) OR (COM_Management.SPROCESS IS NULL) , binds=[com.justep.system.ksql.node.VariableNode@20ae10]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SACTIVITY =  ? , binds=[com.justep.system.ksql.node.VariableNode@fed523]>]>]
2017-07-13 16:20:11                |-->开始 CompExpressionNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=COM_DynamicView.SWHERE AS sWhere, COM_DynamicView.SNAME AS sName, COM_Management.SORGID AS sOrgID, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM COM_Management COM_Management LEFT JOIN COM_DynamicView COM_DynamicView ON  (COM_DynamicView.sID = COM_Management.SDYNAMICVIEWID) OR (COM_Management.SDYNAMICVIEWID IS NULL) , binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SVALIDSTATE = ?, binds=[1]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SCONCEPT =  ? , binds=[com.justep.system.ksql.node.VariableNode@5ffb2]>]>, <SQLValue dimension=1, values=[<OneValue exp= (COM_Management.SPROCESS =  ? ) OR (COM_Management.SPROCESS IS NULL) , binds=[com.justep.system.ksql.node.VariableNode@20ae10]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SACTIVITY =  ? , binds=[com.justep.system.ksql.node.VariableNode@fed523]>]>]
2017-07-13 16:20:11                   |-->开始 OneRelationNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=COM_DynamicView.SWHERE AS sWhere, COM_DynamicView.SNAME AS sName, COM_Management.SORGID AS sOrgID, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM COM_Management COM_Management LEFT JOIN COM_DynamicView COM_DynamicView ON  (COM_DynamicView.sID = COM_Management.SDYNAMICVIEWID) OR (COM_Management.SDYNAMICVIEWID IS NULL) , binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SVALIDSTATE = ?, binds=[1]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SCONCEPT =  ? , binds=[com.justep.system.ksql.node.VariableNode@5ffb2]>]>, <SQLValue dimension=1, values=[<OneValue exp= (COM_Management.SPROCESS =  ? ) OR (COM_Management.SPROCESS IS NULL) , binds=[com.justep.system.ksql.node.VariableNode@20ae10]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SACTIVITY =  ? , binds=[com.justep.system.ksql.node.VariableNode@fed523]>]>]
2017-07-13 16:20:11                   |-->完成 OneRelationNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=COM_DynamicView.SWHERE AS sWhere, COM_DynamicView.SNAME AS sName, COM_Management.SORGID AS sOrgID, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM COM_Management COM_Management LEFT JOIN COM_DynamicView COM_DynamicView ON  (COM_DynamicView.sID = COM_Management.SDYNAMICVIEWID) OR (COM_Management.SDYNAMICVIEWID IS NULL) , binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SVALIDSTATE = ?, binds=[1]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SCONCEPT =  ? , binds=[com.justep.system.ksql.node.VariableNode@5ffb2]>]>, <SQLValue dimension=1, values=[<OneValue exp= (COM_Management.SPROCESS =  ? ) OR (COM_Management.SPROCESS IS NULL) , binds=[com.justep.system.ksql.node.VariableNode@20ae10]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SACTIVITY =  ? , binds=[com.justep.system.ksql.node.VariableNode@fed523]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SACTIVITY, binds=[]>]>]

15030479317

15030479317 发表于 2017-7-13 16:29
2017-07-13 16:20:11                   |-->完成 VariableNode, stack:[, , , , , , ]
2017-07-13 16:20 ...

2017-07-13 16:20:11                |-->完成 CompExpressionNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=COM_DynamicView.SWHERE AS sWhere, COM_DynamicView.SNAME AS sName, COM_Management.SORGID AS sOrgID, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM COM_Management COM_Management LEFT JOIN COM_DynamicView COM_DynamicView ON  (COM_DynamicView.sID = COM_Management.SDYNAMICVIEWID) OR (COM_Management.SDYNAMICVIEWID IS NULL) , binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SVALIDSTATE = ?, binds=[1]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SCONCEPT =  ? , binds=[com.justep.system.ksql.node.VariableNode@5ffb2]>]>, <SQLValue dimension=1, values=[<OneValue exp= (COM_Management.SPROCESS =  ? ) OR (COM_Management.SPROCESS IS NULL) , binds=[com.justep.system.ksql.node.VariableNode@20ae10]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SACTIVITY =  ? , binds=[com.justep.system.ksql.node.VariableNode@fed523]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SACTIVITY IS NULL, binds=[]>]>]
2017-07-13 16:20:11             |-->完成 LogicalExpressionNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=COM_DynamicView.SWHERE AS sWhere, COM_DynamicView.SNAME AS sName, COM_Management.SORGID AS sOrgID, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM COM_Management COM_Management LEFT JOIN COM_DynamicView COM_DynamicView ON  (COM_DynamicView.sID = COM_Management.SDYNAMICVIEWID) OR (COM_Management.SDYNAMICVIEWID IS NULL) , binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SVALIDSTATE = ?, binds=[1]>]>, <SQLValue dimension=1, values=[<OneValue exp=COM_Management.SCONCEPT =  ? , binds=[com.justep.system.ksql.node.VariableNode@5ffb2]>]>, <SQLValue dimension=1, values=[<OneValue exp= (COM_Management.SPROCESS =  ? ) OR (COM_Management.SPROCESS IS NULL) , binds=[com.justep.system.ksql.node.VariableNode@20ae10]>]>, <SQLValue dimension=1, values=[<OneValue exp= (COM_Management.SACTIVITY =  ? ) OR (COM_Management.SACTIVITY IS NULL) , binds=[com.justep.system.ksql.node.VariableNode@fed523]>]>]
2017-07-13 16:20:11          |-->完成 LogicalExpressionNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=COM_DynamicView.SWHERE AS sWhere, COM_DynamicView.SNAME AS sName, COM_Management.SORGID AS sOrgID, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM COM_Management COM_Management LEFT JOIN COM_DynamicView COM_DynamicView ON  (COM_DynamicView.sID = COM_Management.SDYNAMICVIEWID) OR (COM_Management.SDYNAMICVIEWID IS NULL) , binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp= (COM_Management.SVALIDSTATE = ?) AND (COM_Management.SCONCEPT =  ? ) AND ( (COM_Management.SPROCESS =  ? ) OR (COM_Management.SPROCESS IS NULL) ) AND ( (COM_Management.SACTIVITY =  ? ) OR (COM_Management.SACTIVITY IS NULL) ) , binds=[1, com.justep.system.ksql.node.VariableNode@5ffb2, com.justep.system.ksql.node.VariableNode@20ae10, com.justep.system.ksql.node.VariableNode@fed523]>]>]
2017-07-13 16:20:11       |-->完成 WhereNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=COM_DynamicView.SWHERE AS sWhere, COM_DynamicView.SNAME AS sName, COM_Management.SORGID AS sOrgID, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM COM_Management COM_Management LEFT JOIN COM_DynamicView COM_DynamicView ON  (COM_DynamicView.sID = COM_Management.SDYNAMICVIEWID) OR (COM_Management.SDYNAMICVIEWID IS NULL) , binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp= WHERE  (COM_Management.SVALIDSTATE = ?) AND (COM_Management.SCONCEPT =  ? ) AND ( (COM_Management.SPROCESS =  ? ) OR (COM_Management.SPROCESS IS NULL) ) AND ( (COM_Management.SACTIVITY =  ? ) OR (COM_Management.SACTIVITY IS NULL) ) , binds=[1, com.justep.system.ksql.node.VariableNode@5ffb2, com.justep.system.ksql.node.VariableNode@20ae10, com.justep.system.ksql.node.VariableNode@fed523]>]>]
2017-07-13 16:20:11    |-->完成 SelectSentenceNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=SELECT  COM_DynamicView.SWHERE AS sWhere, COM_DynamicView.SNAME AS sName, COM_Management.SORGID AS sOrgID FROM COM_Management COM_Management LEFT JOIN COM_DynamicView COM_DynamicView ON  (COM_DynamicView.sID = COM_Management.SDYNAMICVIEWID) OR (COM_Management.SDYNAMICVIEWID IS NULL)   WHERE  (COM_Management.SVALIDSTATE = ?) AND (COM_Management.SCONCEPT =  ? ) AND ( (COM_Management.SPROCESS =  ? ) OR (COM_Management.SPROCESS IS NULL) ) AND ( (COM_Management.SACTIVITY =  ? ) OR (COM_Management.SACTIVITY IS NULL) ) , binds=[1, com.justep.system.ksql.node.VariableNode@5ffb2, com.justep.system.ksql.node.VariableNode@20ae10, com.justep.system.ksql.node.VariableNode@fed523]>]>]
2017-07-13 16:20:11 Connection product name:Oracle
2017-07-13 16:20:11 Connection product version:Oracle Database 11g Release 11.1.0.0.0 - Production
2017-07-13 16:20:11  exec KSQL: select COM_DynamicView.sWhere as sWhere,COM_DynamicView.sName as sName,COM_Management.sOrgID as sOrgID from COM_Management COM_Management OPTIONAL join COM_DynamicView COM_DynamicView ON COM_DynamicView=COM_Management.sDynamicViewID or COM_Management.sDynamicViewID is null where COM_Management.sValidState=1 and COM_Management.sConcept=:concept and (COM_Management.sProcess=:sProcess or COM_Management.sProcess is null)  and (COM_Management.sActivity=:sActivity or COM_Management.sActivity is null)
--> sql:SELECT  COM_DynamicView.SWHERE AS sWhere, COM_DynamicView.SNAME AS sName, COM_Management.SORGID AS sOrgID FROM COM_Management COM_Management LEFT JOIN COM_DynamicView COM_DynamicView ON  (COM_DynamicView.sID = COM_Management.SDYNAMICVIEWID) OR (COM_Management.SDYNAMICVIEWID IS NULL)   WHERE  (COM_Management.SVALIDSTATE = ?) AND (COM_Management.SCONCEPT =  ? ) AND ( (COM_Management.SPROCESS =  ? ) OR (COM_Management.SPROCESS IS NULL) ) AND ( (COM_Management.SACTIVITY =  ? ) OR (COM_Management.SACTIVITY IS NULL) )
--> binds:[1, V_COST_SUPPLYTREE, /PM/PM/process/cont_SupplyTrendChart/cont_SupplyTrendChartProcess, mainActivity]
--> dataModel|M|/system/data
--> fnModelnull
2017-07-13 16:20:11