|
版本: |
|
小版本号: |
|
|
|
数据库: |
|
服务器操作系统: |
|
应用服务器: |
|
客户端操作系统: |
|
浏览器: |
|
|
|
概念里有两个关系htid和f_htid设了父子关系,生成grid视图后我把列HTH2的类型设置为tree,同时有一个smartfilter关联着这个HTH2来做过滤查询。然后就报上面的错误。本机上运行没问题,发布到服务器报错。求解答。
错误信息:
编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT BT_HT.*,CT_CLDM.MCH as HTLBMCH,CT_ZYGS.GSMCH as GSMCH,BT_CUSTOMER_MASTER.FULL_NAME as CUSTOMERNAME,BT_CUSTOMER_MASTER_3.FULL_NAME as CARGOOWNERNAME,CT_CLDM_4.MCH as PACKINGNAME,CT_CLDM_5.MCH as CALFEETYPENAME,CT_CLDM_6.MCH as CHECKOUTNAME FROM BT_HT BT_HT optional join CT_CLDM CT_CLDM on BT_HT.HTLB = CT_CLDM AND CT_CLDM.LB = '合同类别' optional join CT_ZYGS CT_ZYGS on BT_HT.GSDM = CT_ZYGS optional join BT_CUSTOMER_MASTER BT_CUSTOMER_MASTER on BT_HT.CUSTOMERID = BT_CUSTOMER_MASTER optional join BT_CUSTOMER_MASTER BT_CUSTOMER_MASTER_3 on BT_HT.CARGOOWNERID = BT_CUSTOMER_MASTER_3 optional join CT_CLDM CT_CLDM_4 on BT_HT.PACKINGID = CT_CLDM AND CT_CLDM.LB = '包装' optional join CT_CLDM CT_CLDM_5 on BT_HT.CALFEETYPEID = CT_CLDM_5 AND CT_CLDM_5.LB = '计费依据' optional join CT_CLDM CT_CLDM_6 on BT_HT.CHECKOUTDATE = CT_CLDM AND CT_CLDM.LB = '结算期限' WHERE ((BT_HT.DAY <= stringToDateTime('2014-05-08'))) ORDER BY BT_HT.DAY desc LIMIT 0, 20
编码: JUSTEP154053; 提示: KSQL语法错误, columns中的列HTH2必须包含在select查出列中
|
|