|
版本: |
|
小版本号: |
|
|
|
数据库: |
|
服务器操作系统: |
|
应用服务器: |
|
客户端操作系统: |
|
浏览器: |
|
|
|
在ksql编辑器中测试通过,调用时grid列表添加不了字段cumID,js中同意也得不到cumID,cumID是通过关联子查询后得到
查询语句如下:
select SA_OPPerson.sName as DispatchingName,ERP_ME_WorkCenterMain.fName as fName,ERP_GY_PTProcedure.fProcedureNameID as ProcedureNameID,ERP_MM_ProcedurePlan.fProcedureNum as ProcedureID,ERP_MM_ProcedurePlan.fProduceOrderID as ProduceOrder,ERP_GY_PTProcedure.fProcedureNum as ProcedureNum,ERP_GY_PTProcedure.fCode as fCode,ERP_MM_ProductionOrder.fProjectName as OProjectName,ERP_MM_ProductionOrder.fMaterielCode as OMaterielCode,ERP_MM_ProductionOrder.fProduceOrderNO as OProduceOrderNO,ERP_ME_WorkCenterMain.fName as WWorkName,ERP_ME_WorkCenterMain.fDocumentNumber as WDocumentNumber,ERP_MM_ProductionOrder.fBatchNo as OBatchNo,ERP_StockArchives.fStockName as fOMStockName,ERP_MM_ProcedurePlan,ERP_MM_ProcedurePlan.version as version,ERP_MM_ProcedurePlan.fPlannedStartDate as fPlannedStartDate,ERP_MM_ProcedurePlan.fPlannedEndDate as fPlannedEndDate,ERP_MM_ProcedurePlan.fActualStartDate as fActualStartDate,ERP_MM_ProcedurePlan.fActualEndDate as fActualEndDate,ERP_MM_ProcedurePlan.fTotalManhour as fTotalManhour,ERP_MM_ProcedurePlan.fDispatchingDate as fDispatchingDate,ERP_MM_ProcedurePlan.fTransferQuantity as fTransferQuantity,ERP_MM_ProcedurePlan.fTransferredQuantity as fTransferredQuantity,ERP_MM_ProcedurePlan.fCompletionQuantity as fCompletionQuantity,ERP_MM_ProductionOrder.fOrgName as fOrgName,ERP_MM_ProductionOrder.fOrderStatus as fOrderStatus,ERP_MM_ProcedurePlan.fLeadtimeCompressionRatio as fLeadtimeCompressionRatio,ERP_MM_ProcedurePlan.fTransferredQuantity as fTransferredQuantity1,SA_OPPerson_3.sName as plannerName,(select count(w) as custom8
from ERP_SF_ProblemList w
where w.fBizState <> '已解决' AND w.fProcedureNum = ERP_MM_ProcedurePlan.fProcedureNum ) as custom1,ERP_MM_ProductionOrder.fResultNum as fResultNum,ERP_MM_ProcedurePlan.fIFcompleted as fIFcompleted,ERP_MM_ProductionOrder.fDeliveryDate as fDeliveryDate,ERP_MM_ProductionOrder.fCustomerToken as fCustomerToken,ERP_StockArchives.fProjectCode as fProjectCode,ERP_MM_ProcedurePlan.fResourceNumber as fResourceNumber,ERP_AP_AppraisePlanDetail.fMainID as MainID,customSub1.fProcedureID as cumID from ERP_MM_ProcedurePlan ERP_MM_ProcedurePlan optional
join SA_OPPerson SA_OPPerson on ERP_MM_ProcedurePlan.fDispatchingPsnID = SA_OPPerson optional
join ERP_ME_WorkCenterMain ERP_ME_WorkCenterMain on ERP_MM_ProcedurePlan.fWorkCenterID = ERP_ME_WorkCenterMain optional
join ERP_GY_PTProcedure ERP_GY_PTProcedure on ERP_MM_ProcedurePlan.fProcedureNum = ERP_GY_PTProcedure optional
join ERP_MM_ProductionOrder ERP_MM_ProductionOrder on ERP_MM_ProcedurePlan.fProduceOrderID = ERP_MM_ProductionOrder optional
join ERP_StockArchives ERP_StockArchives on ERP_MM_ProductionOrder.fMaterielCode = ERP_StockArchives.fStockCode optional
join SA_OPPerson SA_OPPerson_3 on ERP_MM_ProductionOrder.fPlaner = SA_OPPerson_3 optional
join ERP_AP_AppraisePlanM ERP_AP_AppraisePlanM on ERP_AP_AppraisePlanM.fReviewDate = :currentDate() AND ERP_AP_AppraisePlanM.fAppraiseType = '工序计划' optional
join ERP_AP_AppraisePlanDetail ERP_AP_AppraisePlanDetail on ERP_AP_AppraisePlanM = ERP_AP_AppraisePlanDetail.fMainID AND ERP_MM_ProcedurePlan = ERP_AP_AppraisePlanDetail.fSourceID AND ERP_AP_AppraisePlanDetail.fSuccessOrError = '否' AND ERP_AP_AppraisePlanDetail.fType = '工作中心' optional
join (select distinct ERP_MM_DispatchingRecord.fProcedureID as fProcedureID from ERP_AP_AppraisePlanDetail ERP_AP_AppraisePlanDetail optional
join ERP_AP_AppraisePlanM ERP_AP_AppraisePlanM on ERP_AP_AppraisePlanDetail.fMainID = ERP_AP_AppraisePlanM optional
join ERP_MM_DispatchingRecord ERP_MM_DispatchingRecord on ERP_AP_AppraisePlanDetail.fSourceID = ERP_MM_DispatchingRecord where ERP_AP_AppraisePlanM.fReviewDate = :currentDate() AND ERP_AP_AppraisePlanDetail.fSuccessOrError = '否' AND ERP_AP_AppraisePlanDetail.fType = '班组' ) customSub1 on customSub1.fProcedureID = ERP_MM_ProcedurePlan where ( ERP_MM_ProductionOrder.fOrderStatus = '计划' OR ERP_MM_ProductionOrder.fOrderStatus = '暂停' )
|
-
编辑器存在的问题
-
测试是可以的
|