查询报错

lbx888

自己开发的功能

lbx888

执行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时出错！

这个是 平台自带控件 standardProcessQueryBar(标准流程查询工具栏)  并错出来KSQL语句

jishuang

这个是OA的appCommon中的，不是平台标准的，不是平台提供的组件，自己找一下看看组件中的实现

lbx888

那要用哪个组件

lbx888

哥们

jishuang

自己放相关的XXXFilter组件进行过滤查询

lbx888

用标准流程查询工具栏





设置进行模块过滤的字段

e.sName as fDeptName,f.sName as fMakePersonName,g.sName as fMakeDeptName 这些都是关联其他表 出来的字段
查询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

模糊过滤报错如下：：



Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at com.justep.system.action.Engine.invokeActions(Native Method)
... 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 '%DD%') OR (UPPER(FPRONAME) LIKE '%DD%')) OR (UPPER(FCOMPACT) LIKE '%DD%')) OR (UPPER(FCOMPKIND) LIKE '%DD%')) OR (UPPER(FCOMPSUMR) LIKE '%DD%')) OR (UPPER(FRealCompact) LIKE '%DD%')) OR (UPPER(fBizStateName) LIKE '%DD%')) OR (UPPER(fDeptName) LIKE '%DD%'))) 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

lbx888

报错

wangyutao

你好，你的平台版本是什么，Appcommon是从哪里获取的？
我们这边根据你的环境，看看能不能重现问题