KSQL语法错误

崔家豪

SELECT FQC_VW_RCV_CheckHeader.*,FQC_RCV_CheckHeader_Add,FQC_RCV_CheckHeader_Add.fCheckDate as fCheckDate,FQC_RCV_CheckHeader_Add.fCheckTime as fCheckTime,FQC_RCV_CheckHeader_Add.fChecker as fChecker,FQC_RCV_CheckHeader_Add.fQualifiedQty as fQualifiedQty,FQC_RCV_CheckHeader_Add.fCheckResults as fCheckResults,FQC_RCV_CheckHeader_Add.fCheckResultsCode as fCheckResultsCode,FQC_RCV_CheckHeader_Add.fAuditStatus as fAuditStatus,(SQL.NVL(FQC_RCV_CheckHeader_Add.fColour, SQL.NVL((select IQC_MaterialSIP.fColour from IQC_MaterialSIP IQC_MaterialSIP where FQC_VW_RCV_CheckHeader.fProductCode = IQC_MaterialSIP.fProductCode), '/'))) as fColour,(SQL.NVL(FQC_RCV_CheckHeader_Add.fCheckerCode, :currentPersonCode())) as fCheckerCode FROM FQC_VW_RCV_CheckHeader FQC_VW_RCV_CheckHeader optional join FQC_RCV_CheckHeader_Add FQC_RCV_CheckHeader_Add on FQC_VW_RCV_CheckHeader = FQC_RCV_CheckHeader_Add.fParentID WHERE ((exists(select 1 from FQC_TransferBasic FQC_TransferBasic ,FQC_UserPermission FQC_UserPermission where FQC_TransferBasic.FID = FQC_UserPermission.fparentid and FQC_TransferBasic.fWHCode=FQC_VW_RCV_CheckHeader.fWareCode and FQC_UserPermission.fmembcode='087458')) AND (FQC_VW_RCV_CheckHeader.fCheckDate >= stringToDate('2018-07-17')) AND (FQC_VW_RCV_CheckHeader.fCheckDate <= stringToDate('2018-08-17')) AND (FQC_RCV_CheckHeader_Add.fAuditStatus = 'N' or FQC_RCV_CheckHeader_Add.fAuditStatus is null)) ORDER BY FQC_VW_RCV_CheckHeader.fCheckDate desc

jishuang

KSQL中不能这样写
select 1 from FQC_TransferBasic FQC_TransferBasic ,FQC_UserPermission FQC_UserPermission

可以用optional关联查询的方式

崔家豪

jishuang 发表于 2018-8-17 10:15
KSQL中不能这样写
select 1 from FQC_TransferBasic FQC_TransferBasic ,FQC_UserPermission FQC_UserPermi ...

if(!common.isNull(fWHCode)){
                        headData.setFilter("filter14", "FQC_VW_RCV_CheckHeader.fWareCode in ("+fWHCode+")");
                }else{
                        headData.setFilter("filter14", "exists(select 1 from FQC_TransferBasic FQC_TransferBasic ,FQC_UserPermission FQC_UserPermission where FQC_TransferBasic.FID = FQC_UserPermission.fparentid and FQC_TransferBasic.fWHCode=FQC_VW_RCV_CheckHeader.fWareCode and FQC_UserPermission.fmembcode='"+this.getContext().getCurrentPersonCode()+"')");                               
                }

这段语句并没有写在KSQL里，写的filters过滤条件，传过去的

jishuang

filter中也是可以自己拼接optional的

崔家豪

jishuang 发表于 2018-8-17 10:38
filter中也是可以自己拼接optional的

具体语句怎么写？这样吗？
headData.setFilter("filter14", "exists(select 1 from FQC_TransferBasic FQC_TransferBasic optional join FQC_UserPermission FQC_UserPermission on FQC_TransferBasic.FID = FQC_UserPermission.fparentid and FQC_TransferBasic.fWHCode=FQC_VW_RCV_CheckHeader.fWareCode and FQC_UserPermission.fmembcode='"+this.getContext().getCurrentPersonCode()+"')");                               

jishuang

and后面的可以写到where条件中

崔家豪

jishuang 发表于 2018-8-17 11:05
and后面的可以写到where条件中

OK，谢谢，可以结贴了