KSQL语法错误, columns中的列sParent必须包含在select查出列中

星辰

自定义了一个queryAction，源码如下：
select SA_OPOrg,SA_OPOrg.sName as sName,SA_OPOrg.sCode as sCode,SA_OPOrg.sFID as sFID,SA_OPOrg.sOrgKindID as sOrgKindID,SA_OPOrg.sParent as sParent
    from SA_OPOrg SA_OPOrg
    where SA_OPOrg.sValidState >= 0 AND  SA_OPOrg in (select  SA_OPOrg.sParent as sParent from SA_OPOrg SA_OPOrg  where SA_OPOrg.sCode LIKE '%DWYH%')
    order by SA_OPOrg.sSequence asc


在action中点测试，可查出数据，但是放到页面里就报ksql错误，sParent必须包含在select查出列中

jishuang

前面和后面要去不一样的别名去做区分啊

星辰

jishuang 发表于 2019-11-21 17:40
前面和后面要去不一样的别名去做区分啊

select SA_OPOrg,SA_OPOrg.sName as sName,SA_OPOrg.sCode as sCode,SA_OPOrg.sFID as sFID,SA_OPOrg.sOrgKindID as sOrgKindID,SA_OPOrg.sParent as sParent
    from SA_OPOrg SA_OPOrg
    where SA_OPOrg.sValidState >= 0 AND  SA_OPOrg in (select  SA_OPOrg1.sParent as sParent1 from SA_OPOrg SA_OPOrg1  where SA_OPOrg1.sCode LIKE '%DWYH%')
    order by SA_OPOrg.sSequence asc

改成这样 还是报错

星辰

jishuang 发表于 2019-11-21 17:40
前面和后面要去不一样的别名去做区分啊

action 调用没有变成最新的sql，不是sql有问题

jishuang

放到页面是在BizData中？columns怎么设置的？

星辰

jishuang 发表于 2019-11-22 14:52
放到页面是在BizData中？columns怎么设置的？

已解决了  结贴吧