5.2.7ksql子查询怎样应用？

梦冷亦寒

select tabInPlanInfo.*,tabBOM.fSingleQty as fSingleQty,tabPlaneModelBatch.fBatchNo as fBatchNo,tabPlaneModelBatch.fShipQty as fShipQty,tabBaseBomInfo.fName as fName,tabBaseBomInfo.fPartNo as fPartNo,tabBaseBomInfo.fBrand as fBrand,tabBaseBomInfo.fSize as fSize,tabBaseBomInfo.fStandard as fStandard,tabBaseBomInfo.fItemState as fItemState,tabBaseBomInfo.fItemType as fItemType,tabBaseBomInfo.fUnit as fUnit,tabBaseBomInfo.fOneClass as fOneClass,tabBaseBomInfo.fTwoClass as fTwoClass,tabBaseBomInfo.fThreeClass as fThreeClass,tabHistoryPrice.fHistoryPrice as fHistoryPrice,tabHistoryPrice.fSupplierName as fSupplierName,tabPlaneModel.fModelName as fModelName,tabPlaneModel.fModelCode as fModelCode,tabHistoryPrice.fBaseBomInfoId as fBaseBomInfoId,tabMaterielPrivilege.fPlannerId as fPlannerId,tabMaterielPrivilege.fPlannerName as fPlannerName,tabBOM.fPlaneModelBatchId as fPlaneModelBatchI
    from tabInPlanInfo tabInPlanInfo
     optional  join tabBOM tabBOM on tabInPlanInfo.fBOMId = tabBOM
     optional  join tabPlaneModelBatch tabPlaneModelBatch on tabBOM.fPlaneModelBatchId = tabPlaneModelBatch
     optional  join tabBaseBomInfo tabBaseBomInfo on tabBOM.fBaseBomInfoId = tabBaseBomInfo
     optional  join tabHistoryPrice tabHistoryPrice on tabHistoryPrice.fBaseBomInfoId = tabBaseBomInfo
     optional  join tabPlaneModel tabPlaneModel on tabPlaneModel = tabPlaneModelBatch.fPlaneModelId
     optional  join tabMaterielPrivilege tabMaterielPrivilege on tabBaseBomInfo = tabMaterielPrivilege.fBaseBomInfoId
     optional  join (select (max(tabWare.fBaseBomInfoId)) as fBaseBomInfoId,(sum(tabWare.fTotaQty)) as fTotaQty from tabWare tabWare group by tabWare.fBaseBomInfoId, tabWare.fTotaQty) w on w.fBaseBomInfoId =  tabBOM.fBaseBomInfoId
    order by tabInPlanInfo.fPlanType asc


提示ksql中的本体，在定义的dataModel中不存在，这会导致运行时错误



测试ksql有数据，如最后的数量，但是.w页面看不到这个字段的列

jishuang

1.ksql编辑器检查可能有问题，要看运行时控制的错误
2.
select (max(tabWare.fBaseBomInfoId)) as fBaseBomInfoId前面的关系已经有这个关系别名，这个地方需要设置一个不一样的别名

梦冷亦寒

jishuang 发表于 2016-4-11 16:10
1.ksql编辑器检查可能有问题，要看运行时控制的错误
2.
select (max(tabWare.fBaseBomInfoId)) as fBaseBom ...

运行不报错，但是.w页面没法加载子查询中的字段啊

jishuang

关系别名修改了吗？
w页面没法加载子查询中的字段具体什么现在？直接在.w中写的子查询的关系别名不会显示数据？

zhaoxz

jishuang 发表于 2016-4-11 18:35
关系别名修改了吗？
w页面没法加载子查询中的字段具体什么现在？直接在.w中写的子查询的关系别名不会显示数 ...

原项目businessProcess模块有概念，也添加了action，之后我把businessProcess模块的概念部分删除，调用的hotline模块的概念，现在就导致businessProcess模块的action不存在了。
来下远程吧，我的QQ2824116725

jishuang

确认data目录下inculde了hotline模块的data目录
注意是data目录不是ontology目录