概念左关联的字段，能不能所谓setFilter里的值做过滤

eqwfrfsky

概念左关联的字段，能不能在这个概念里setFilter这个字段作为过滤这个概念的条件做过滤，我这里这么操作报错说这个概念没有映射，但是我在这个概念的bizdata里已经勾选了这个左关联的字段，请教！

jishuang

看报错执行的ksql是什么？

eqwfrfsky

Caused by: com.justep.exception.BusinessException: 编码: JUSTEP154038; 提示: T_LX_XMLXLZ.fRKMC找不到对应的关系映射

eqwfrfsky

编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL:

1. SELECT T_LX_XMLXLZ.*,SA_OPORG.SNAME as XMLXLZCDDW,SA_OPORG_2.SNAME as XMLXLZGKGLDW,SA_OPPERSON.SNAME as XMLXLZFZR,SA_OPPERSON_3.SNAME as XMLXLZBZR,T_ZD_YJXMJHGCZD.FMC as XMLXLZYJXMMC,T_ZD_YJXMJHGCZD_4.FMC as XMLXLZSHJHMC,T_ZD_YJXMJHGCZD_5.FMC as XMLXLZSHGCMC,T_ZD_YS_TYPE.F_YS_TYPE as XMLXLZYSLXMC,SA_OPORG_3.SNAME as XMJSSHJGNAME,SA_OPORG_4.SNAME as XMYSSHJGNAME,SA_OPORG_1.SNAME as XMLXLZJSSHDWMC,T_JH_BZXXZB.fXMMC as SSEJXMNAME,T_LX_XMRK.fRKMC as fRKMC  FROM T_LX_XMLXLZ T_LX_XMLXLZ  optional  join SA_OPORG SA_OPORG on SA_OPORG.SCODE = T_LX_XMLXLZ.fXMCDDW optional  join SA_OPORG SA_OPORG_2 on SA_OPORG_2.SCODE = T_LX_XMLXLZ.fGKGLDW optional  join SA_OPPERSON SA_OPPERSON on SA_OPPERSON.SCODE = T_LX_XMLXLZ.fXMFZR optional  join SA_OPPERSON SA_OPPERSON_3 on SA_OPPERSON_3.SCODE = T_LX_XMLXLZ.fYSBZR optional  join T_ZD_YJXMJHGCZD T_ZD_YJXMJHGCZD on T_ZD_YJXMJHGCZD = T_LX_XMLXLZ.fSZYJXM optional  join T_ZD_YJXMJHGCZD T_ZD_YJXMJHGCZD_4 on T_ZD_YJXMJHGCZD_4 = T_LX_XMLXLZ.fSZJH optional  join T_ZD_YJXMJHGCZD T_ZD_YJXMJHGCZD_5 on T_ZD_YJXMJHGCZD_5 = T_LX_XMLXLZ.fSZGC optional  join T_ZD_YS_TYPE T_ZD_YS_TYPE on T_ZD_YS_TYPE.FYSLX = T_LX_XMLXLZ.fYSLX optional  join SA_OPORG SA_OPORG_3 on SA_OPORG_3.SCODE = T_LX_XMLXLZ.fJSSHJG optional  join SA_OPORG SA_OPORG_4 on SA_OPORG_4.SCODE = T_LX_XMLXLZ.fYSSHJG optional  join SA_OPORG SA_OPORG_1 on SA_OPORG_1.SCODE = T_LX_XMLXLZ.fJSSHJG optional  join SA_OPORG SA_OPORG_2 on SA_OPORG_2.SCODE = T_LX_XMLXLZ.fGKGLDW optional  join T_JH_BZXXZB T_JH_BZXXZB on T_JH_BZXXZB.fXMBH = T_LX_XMLXLZ.fSZEJXM optional  join T_LX_XMRK T_LX_XMRK on T_LX_XMRK.fZBID = T_LX_XMLXLZ WHERE ((T_LX_XMLXLZ.fRWBSID = 'b6fd4a38645a4a3f84cbc4eb40ba229a' and T_LX_XMLXLZ.fRKMC is not null)) LIMIT 0, 20
   

复制代码

eqwfrfsky

红线是左关联的字段和概念

jishuang

设置filter的时候写概念名了吗？