查询报错

lbx888

查询窗体 概念是 左关联 其他表
设置模糊过滤字段的时候 如果 字段有其他关联表的字段 会报错

这是标准查询 Action KSQL:select OA_COMPACTEXAPP.*,b.fName as fCompactKindName,c.fName as fbizorginName,d.sName as fpersonsName,e.sName as fDeptName,f.sName as fMakePersonName,g.sName as fMakeDeptName,h.sName as fCreatePosName,j.fName as fdutyName
    from OA_COMPACTEXAPP OA_COMPACTEXAPP
     optional  join OA_Pub_BaseCode b on OA_COMPACTEXAPP.FCOMPKIND = b.fCode AND b.fScope = '公司合同类型'
     optional  join OA_Pub_BaseCode c on OA_COMPACTEXAPP.FBIZORIGN = c.fCode AND c.fScope = '单据所属公司'
     optional  join V_SA_OPOrg d on OA_COMPACTEXAPP.FCREATEURL = d.sFID AND d.sOrgKindID = 'psm'
     optional  join V_SA_OPOrg e on OA_COMPACTEXAPP.FCREATEDEPTID = e AND e.sOrgKindID = 'dpt'
     optional  join V_SA_OPOrg f on OA_COMPACTEXAPP.FCREATEPERID = f.sPersonID AND f.sOrgKindID = 'psm'
     optional  join V_SA_OPOrg g on OA_COMPACTEXAPP.FCPMakeDept = g AND g.sOrgKindID = 'dpt'
     optional  join V_SA_OPOrg h on OA_COMPACTEXAPP.FCREATEPOSID = h AND h.sOrgKindID = 'pos'
     optional  join OA_Pub_BaseCode j on OA_COMPACTEXAPP.fduty = j.fCode

lbx888

        ... 21 more
Caused by: com.justep.model.exception.ModelException: 执行ksql:SELECT OA_COMPACTEXAPP.*,b.fName as fCompactKindName,c.fName as fbizorginName,d.sName as fpersonsName,e.sName as fDeptName,f.sName as fMakePersonName,g.sName as fMakeDeptName,h.sName as fCreatePosName,j.fName as fdutyName  FROM OA_COMPACTEXAPP OA_COMPACTEXAPP  optional  join OA_Pub_BaseCode b on OA_COMPACTEXAPP.FCOMPKIND = b.fCode AND b.fScope = '公司合同类型' optional  join OA_Pub_BaseCode c on OA_COMPACTEXAPP.FBIZORIGN = c.fCode AND c.fScope = '单据所属公司' optional  join V_SA_OPOrg d on OA_COMPACTEXAPP.FCREATEURL = d.sFID AND d.sOrgKindID = 'psm' optional  join V_SA_OPOrg e on OA_COMPACTEXAPP.FCREATEDEPTID = e AND e.sOrgKindID = 'dpt' optional  join V_SA_OPOrg f on OA_COMPACTEXAPP.FCREATEPERID = f.sPersonID AND f.sOrgKindID = 'psm' optional  join V_SA_OPOrg g on OA_COMPACTEXAPP.FCPMakeDept = g AND g.sOrgKindID = 'dpt' optional  join V_SA_OPOrg h on OA_COMPACTEXAPP.FCREATEPOSID = h AND h.sOrgKindID = 'pos' optional  join OA_Pub_BaseCode j on OA_COMPACTEXAPP.fduty = j.fCode WHERE ((fBizState IN ('bsEditing','bsExecuting','bsFinished')) AND ((FCREATEPERID = '2E245EC4F99A423E9523D0D0F654630C') OR (OA_COMPACTEXAPP IN (SELECT EXECUTE_CONCEPT.fMasterID AS EXECUTE_CONCEPT_fMasterID FROM OA_COMPACTEXAPPExecute EXECUTE_CONCEPT WHERE EXECUTE_CONCEPT.fCreatePsnID = '2E245EC4F99A423E9523D0D0F654630C') )) AND ((((((((UPPER(FCREATEPERID) LIKE '%信息部%') OR (UPPER(FPRONAME) LIKE '%信息部%')) OR (UPPER(FCOMPACT) LIKE '%信息部%')) OR (UPPER(FCOMPKIND) LIKE '%信息部%')) OR (UPPER(FCOMPSUMR) LIKE '%信息部%')) OR (UPPER(FRealCompact) LIKE '%信息部%')) OR (UPPER(fBizStateName) LIKE '%信息部%')) OR (UPPER(fDeptName) LIKE '%信息部%'))) ORDER BY FCREATETIME DESC LIMIT 0, 100时出错！
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.BizData.query(Unknown Source)
        at BizProcedure.query(BizProcedure.java:12)
        ... 26 more
Caused by: java.sql.SQLException: 列名 'fDeptName' 无效。
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
        at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
        ... 31 more

jishuang

java.sql.SQLException: 列名 'fDeptName' 无效。
数据库中没有这个字段

lbx888

有这个字段 是通过关联其他表
e.sName as fDeptName

lbx888

设置模糊查询字段

jishuang

KSQL中的语法，关系前面用概念别名.关系别名

ecoolper

用的那个组件

lbx888

有用别名.字段名 e.sName as fDeptName

lbx888

用这个
standardProcessQueryBar(标准流程查询工具栏)

jishuang

自己开发的功能还是OA原有的功能？

OR (UPPER(fDeptName) LIKE '%信息部%'))) ORDER BY FCREATETIME 按照上面的格式写