ksql 提示没有from ？？？

tlkj

select zyq,xlzd,zongjixiu,xlzd-zongjixiu zongtuoche,zongxianlu,xianlujixiu,zongxianlu-xianlujixiu xianlutuoche,xlzd-zongxianlu zongzhandian,zongjixiu-xianlujixiu zhandianjixiu,xlzd-zongjixiu-(zongxianlu-xianlujixiu) zhandiantuoche
from
(
  select zong.zyq zyq,count(zong.xlzd)xlzd,count(zongjixiu.zongjixiu)   zongjixiu,count(zongxianlu.zongxianlu)zongxianlu,count(xianlujixiu.xianlujixiu)xianlujixiu
  from
  (select xlzd xlzd,wgsj zongwgsj ,disp_id zongdisp_id ,zyq zyq from v_report where wgsj <= :hou and wgsj >= :qian) zong
  left join
  (select qxjg zongjixiu,disp_id zongjixiudisp_id  from v_report where qxjg = '即修' and  wgsj <= :hou and wgsj >= :qian) zongjixiu
  on zong.zongdisp_id=zongjixiu.zongjixiudisp_id
  left join
  (select qxjg zongxianlu ,disp_id zongxianludisp_id  from v_report where xlzd = '线路抢修' and wgsj <= :hou and wgsj >= :qian) zongxianlu
  on zong.zongdisp_id=zongxianlu.zongxianludisp_id
  left join
  ( select qxjg xianlujixiu,disp_id xianlujixiudisp_id from v_report where xlzd = '线路抢修' and qxjg = '即修'and  wgsj <= :hou and wgsj >= :qian)  xianlujixiu
  on zong.zongdisp_id=xianlujixiu.xianlujixiudisp_id
  group by zong.zyq
)A
----------------------------------------------
不知道这是哪里的错误

tlkj

请问关于自定义可以传值的action的应用有例子或者教程吗

jishuang

复杂的就不要用KSQL操作用sql操作，报表传参的案例在http://bbs.wex5.com/forum.php?mo ... 7&pid=165222013

tlkj

你给我的这个链接什么信息也得不到

jishuang

/UI2/demo/report/process/property/parameterFilterReport.w
报表查询的案例，结合对应的action的实现

tlkj

我写的是这样public static Table queryBaobiao(java.sql.Date qian,java.sql.Date hou){
                Map<String, Object> params = new HashMap<String, Object>();
                params.put("qian",qian);
                params.put("hou",hou);
                String sql=一条语句 其中 有where wgsj >= :qian and wgsj <= :hou
               
                Table table = KSQL.select(sql, params, "/qx/qx/data", null);
                return table;
        }
然后在model的data属性source调用这个action 但是报错 显示没有定义variables 该怎么修改

tlkj

这个问题的原因是什么呀 请指教

jishuang

reportData的定义源码发一下

tlkj

<div xmlns="http://www.w3.org/1999/xhtml" xid="window" class="window" component="$UI/system/components/justep/window/window" design="device:pc">  
  <div component="$UI/system/components/justep/model/model" xid="model" style="height:auto;left:56px;top:129px;" onLoad="modelLoad"><div component="$UI/system/components/justep/reportData/reportData" xid="reportData1">
   <source xid="default1"><action xid="default2" name="queryBaobiaoAction" type="ksqlaction"></action></source></div>
  <div component="$UI/system/components/justep/data/data" autoLoad="true" xid="riqiData" idColumn="a" autoNew="false"><column name="a" type="Date" xid="xid1"></column>
  <column name="b" type="Date" xid="xid2"></column>
  <data xid="default3">[{&quot;a&quot;:&quot;&quot;,&quot;b&quot;:&quot;&quot;}]</data></div>
  <div component="$UI/system/components/justep/data/data" autoLoad="true" xid="tbrdata" idColumn="name"><column name="name" type="String" xid="xid3"></column>
  <data xid="default4">[{&quot;name&quot;:&quot;&quot;}]</data></div></div>
<div component="$UI/system/components/justep/contents/contents" class="x-contents x-full" active="0" xid="contents1">
   <div class="x-contents-content" xid="content1"><div xid="div1">
  <div component="$UI/system/components/justep/toolBar/toolBar" class="x-toolbar form-inline x-toolbar-spliter"
          xid="toolBar1">
         

jishuang

<source xid="default1"><action xid="default2" name="queryBaobiaoAction" type="ksqlaction"></action></source>
type不是ksqlaction
是action,然后自己设置columns