ksql的子查询不起作用

会爬树程序猿

http://bbs.wex5.com/forum.php?mo ... 4%E6%9C%AC%E4%BD%93
问题和这个帖子一样，查询的后两个字段在前面的data中看不到

jishuang

ksql编辑器中子查询可能有问题，到源码中看是否正确

看前端运行结果是否正确

会爬树程序猿

jishuang 发表于 2017-12-28 13:34
ksql编辑器中子查询可能有问题，到源码中看是否正确

看前端运行结果是否正确 ...

<action name="queryTM_QU_DETAILandTM_QU_DETAILAction" procedure="bizQueryProcedure"><permission name="range" type="List"/>
<private name="concept" type="String" value="TM_QU_DETAIL"/>
<private name="select" type="String" value="TM_QU_DETAIL.*,customSub2.QU_UNIT_PRICE2 as QU_UNIT_PRICE3,customSub2.BD_QU_ID2 as BD_QU_ID3"/>
<private name="from" type="String" value="TM_QU_DETAIL TM_QU_DETAIL  optional  join (select  detail.BD_QU_ID as BD_QU_ID2, detail.QU_UNIT_PRICE as QU_UNIT_PRICE2 from TM_QU_DETAIL detail  where detail.BID_FLAG = '1'  order by detail.BID_DATE desc) customSub2 on TM_QU_DETAIL.BD_QU_ID = customSub2.BD_QU_ID2"/>
<private name="aggregate" type="String"/>
<private name="dataModel" type="String" value="/pms/tm/data"/>
<private name="fnModel" type="String"/>
<protected name="condition" type="String"/>
<public name="distinct" type="Boolean" value="false"/>
<public name="idColumn" type="String" value="TM_QU_DETAIL"/>
<public name="filter" type="String"/>
<public name="limit" type="Integer"/>
<public name="offset" type="Integer"/>
<public name="columns" type="String"/>
<public name="orderBy" type="String"/>
<public name="aggregateColumns" type="String"/>
<public name="variables" type="Map"/>
</action>



这是action的源码，我看不出有什么问题，前台运行结果也是有问题的，首先是data中没有这两个字段，就算我在对应的grid源码中加上这两个字段也是没有数据的

jishuang

把sql语句打出来看看是http://bbs.wex5.com/forum.php?mo ... 33524&pid=165004035

不行推荐用sql实现，ksql中用子查询某些情况会有问题

会爬树程序猿

jishuang 发表于 2017-12-28 15:09
把sql语句打出来看看是http://bbs.wex5.com/forum.php?mo ... 33524&pid=165004035

不行推荐用sql实现，ks ...

2017-12-29 09:58:44 [SQL Time]sql 执行时间：14ms, exec KSQL: SELECT TM_QU_DETAIL.*,customSub2.QU_UNIT_PRICE2 as QU_UNIT_PRICE3,customSub2.BD_QU_ID2 as BD_QU_ID3  FROM TM_QU_DETAIL TM_QU_DETAIL  optional  join (select  detail.BD_QU_ID as BD_QU_ID2, detail.QU_UNIT_PRICE as QU_UNIT_PRICE2 from TM_QU_DETAIL detail  where detail.BID_FLAG = '1'  order by detail.BID_DATE desc) customSub2 on TM_QU_DETAIL.BD_QU_ID = customSub2.BD_QU_ID2 WHERE ((TM_QU_DETAIL.QU_ID = 'C7D0012CC4100001EFA5A7B041709070')) LIMIT 0, 20
  --> sql:SELECT  TM_QU_DETAIL.AMT AS AMT, TM_QU_DETAIL.BD_QU_ID AS BD_QU_ID, TM_QU_DETAIL.BID_DATE AS BID_DATE, TM_QU_DETAIL.BID_FLAG AS BID_FLAG, TM_QU_DETAIL.BID_REVIEW_ID AS BID_REVIEW_ID, TM_QU_DETAIL.ITEM_CODE AS ITEM_CODE, TM_QU_DETAIL.ITEM_NAME AS ITEM_NAME, TM_QU_DETAIL.ITEM_NO AS ITEM_NO, TM_QU_DETAIL.QUOTA_CODE AS QUOTA_CODE, TM_QU_DETAIL.QU_AMT AS QU_AMT, TM_QU_DETAIL.QU_DIFF_AMT AS QU_DIFF_AMT, TM_QU_DETAIL.QU_ID AS QU_ID, TM_QU_DETAIL.QU_UNIT_PRICE AS QU_UNIT_PRICE, TM_QU_DETAIL.REF_WORK_QUAN AS REF_WORK_QUAN, TM_QU_DETAIL.REMARK AS REMARK, TM_QU_DETAIL.SITU_DESC AS SITU_DESC, TM_QU_DETAIL.SPEC AS SPEC, TM_QU_DETAIL.fID AS TM_QU_DETAIL, TM_QU_DETAIL.UNIT AS UNIT, TM_QU_DETAIL.UNIT_PRICE AS UNIT_PRICE, TM_QU_DETAIL.VERSION AS version FROM TM_QU_DETAIL TM_QU_DETAIL LEFT JOIN (SELECT  detail.BD_QU_ID AS BD_QU_ID2, detail.QU_UNIT_PRICE AS QU_UNIT_PRICE2 FROM TM_QU_DETAIL detail  WHERE (detail.BID_FLAG = ?) AND (detail.client_id = '1D3FA7FAD43E4A64B71971EA34FD0CA0')  ORDER BY detail.BID_DATE DESC) customSub2 ON TM_QU_DETAIL.BD_QU_ID = customSub2.BD_QU_ID2  WHERE (TM_QU_DETAIL.QU_ID = ?) AND (TM_QU_DETAIL.client_id = '1D3FA7FAD43E4A64B71971EA34FD0CA0')
--> binds:[1, C7D0012CC4100001EFA5A7B041709070]
2017-12-29 09:58:44 [SQL Time]sql 执行时间：26ms, exec KSQL:
  --> sql:SELECT count(*) FROM TM_QU_DETAIL TM_QU_DETAIL LEFT JOIN (SELECT  detail.BD_QU_ID AS BD_QU_ID2, detail.QU_UNIT_PRICE AS QU_UNIT_PRICE2 FROM TM_QU_DETAIL detail  WHERE (detail.BID_FLAG = ?) AND (detail.client_id = '1D3FA7FAD43E4A64B71971EA34FD0CA0')  ORDER BY detail.BID_DATE DESC) customSub2 ON TM_QU_DETAIL.BD_QU_ID = customSub2.BD_QU_ID2  WHERE (TM_QU_DETAIL.QU_ID = ?) AND (TM_QU_DETAIL.client_id = '1D3FA7FAD43E4A64B71971EA34FD0CA0')
--> binds:[1, C7D0012CC4100001EFA5A7B041709070]


这是SQL语句，好像是有查到，但是为什么前台没有显示字段呢？

会爬树程序猿

会爬树程序猿 发表于 2017-12-29 10:02
2017-12-29 09:58:44 [SQL Time]sql 执行时间：14ms, exec KSQL: SELECT TM_QU_DETAIL.*,customSub2.QU_U ...

帮忙看一下控制台的SQL是不是有问题？

jishuang

把sql拿到数据库中执行看看

会爬树程序猿

jishuang 发表于 2017-12-29 10:19
把sql拿到数据库中执行看看

数据库执行是没有问题的

jishuang

那应该是ksql子查询的缺陷
在data上添加计算关系，设置为没有显示的两个字段的名字看看

会爬树程序猿

jishuang 发表于 2017-12-29 11:15
那应该是ksql子查询的缺陷
在data上添加计算关系，设置为没有显示的两个字段的名字看看 ...

试了不行