ksql编辑器的问题

hbyczg

标准动作修改querAction的SELECT为（select AO_OrderDetail.*,AO_Order.fDate as fDate,AO_Order.fAgreementNO as fAgreementNO,AO_Order.fShortName as fShortName,customSub1.fQuantity as fCgQuantity     from AO_OrderDetail AO_OrderDetail optional
    join AO_Order AO_Order on AO_Order = AO_OrderDetail.fMainID optional
    join (select AO_OrderDetail.fOrderDetailFID as fOrderDetailFID, sum(customSub2.fQuantity) as fQuantity from AO_OrderDetail AO_OrderDetail optional
    join AO_Order AO_Order on AO_Order = AO_OrderDetail.fMainID optional
    join (select AO_OrderDetail.fOrderDetailFID as fOrderDetailFID, AO_OrderDetail.fQuantity as fQuantity from AO_OrderDetail AO_OrderDetail optional
    join AO_Order AO_Order on AO_Order = AO_OrderDetail.fMainID
    where AO_Order.fSheetType = '采购订单' )customSub2 on AO_OrderDetail = customSub2.fOrderDetailFID where AO_Order.fSheetType = '销售订单'
    group by AO_OrderDetail.fOrderDetailFID) customSub1 on AO_OrderDetail.fOrderDetailFID = customSub1.fOrderDetailFID where AO_Order.fSheetType = '采购合同'）
修改完成点测试结果正确。可在页面运行总报错，回标准动作处查看发现上面Select中红色括号没有了，加上保存后再查看SELECT语句发现红色的括号又没有了，求解？在BEX5 3.6中

jishuang

queryAction不支持group by
http://bbs.wex5.com/forum.php?mo ... &extra=page%3D1

hbyczg

jishuang 发表于 2017-6-29 17:28
queryAction不支持group by
http://bbs.wex5.com/forum.php?mod=viewthread&tid=54836&extra=page%3D1

ksqlQueryProcedure 是不是也不支持

jishuang

支持

hbyczg

jishuang 发表于 2017-6-30 09:03
支持

使用ksqlQueryProcedure在设置上述select时出现同样的情况

jishuang

直接到action的源码中写select语句

hbyczg

jishuang 发表于 2017-6-30 13:49
直接到action的源码中写select语句

自定义action搞定。自定义的action只能是用loadDATA加载吗

jishuang

loadData是最简单的