smartfilter 传入参数出问题

ssoqyhm

----后台检测到的filter
(StorageItemStore.storageType = '1' OR StorageItemStore.storageType = '2') AND ((((UPPER(StorageItemStore.storageNo) LIKE '%2%') OR (UPPER(StorageItemStore.storageName) LIKE '%2%')) OR (UPPER(itemNo) LIKE '%2%')) OR (UPPER(StorageItemStore.itemDescribe) LIKE '%2%')) AND ((StorageItemStore.storageNo = 'WJ'))
----系统报错信息
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select (sum(StorageItemStore.pieceQuantityL)) as sumJS,(sum(StorageItemStore.quantityL)) as sumSL from StorageItemStore StorageItemStore  where StorageItemStore.quantityL <> 0 and (StorageItemStore.storageType = '1' OR StorageItemStore.storageType = '2') AND ((((UPPER(StorageItemStore.storageNo) LIKE '%2%') OR (UPPER(StorageItemStore.storageName) LIKE '%2%')) OR (UPPER(itemNo) LIKE '%2%')) OR (UPPER(StorageItemStore.itemDescribe) LIKE '%2%')) AND ((StorageItemStore.storageNo = 'WJ'))
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.KSQL.select(Unknown Source)
        at Common.userBizQuery(Common.java:143)
        ... 26 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP154054; 提示: KSQL语法错误, itemNo找不到对应的符号描述
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.util.Utils.check(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.IdentiferNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.FunctionNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.CompExpressionNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.LogicalExpressionNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.LogicalExpressionNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.LogicalExpressionNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.WhereNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.SelectSentenceNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.QueryVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.QuerySentence.accept(Unknown Source)
        ... 31 more

jason2014

itemNo找不到对应的符号描述，这么明显的提示，要加表别名StorageItemStore吧

ssoqyhm

jason2014 发表于 2014-6-27 15:53
itemNo找不到对应的符号描述，这么明显的提示，要加表别名StorageItemStore吧

smartFilter 控件，你能自己加？

jason2014

ssoqyhm 发表于 2014-6-27 16:02
smartFilter 控件，你能自己加？

那你的itemNo是什么？不是表的字段吗？

ssoqyhm

jason2014 发表于 2014-6-27 16:19
那你的itemNo是什么？不是表的字段吗？

是表的字段，smartFilter控件里面选的，代码规则是控件定好了

jason2014

ssoqyhm 发表于 2014-6-27 16:21
是表的字段，smartFilter控件里面选的，代码规则是控件定好了

好吧，我错了，smartFilter生成的ksql是这样的。具体什么错我就不知道了

ssoqyhm

jason2014 发表于 2014-6-27 16:33
好吧，我错了，smartFilter生成的ksql是这样的。具体什么错我就不知道了

是啊 ，不懂怎么会生成这样其他地方也不会

jishuang

只有这个itemNO是smartFilter查询的，其他的字段是通过什么方式生成的过滤条件，smartFilter设置的正确吗？在smartFilter组件的onGetCondition中看一下这个组件拼出来的filter是否就错了

ssoqyhm

jishuang 发表于 2014-6-27 17:41
只有这个itemNO是smartFilter查询的，其他的字段是通过什么方式生成的过滤条件，smartFilter设置的正确吗？ ...

onGetCondition拼出来的filter 就错了

zhaixin

编辑一下w文件的源码，给itemNO前面加上概念名和点