orgselect组件在.m.w文件中报错

lijunfeng

orgselect组件在.m.w文件中报错。
提示: 执行KSQL出错, KSQL: SELECT OA_TasksAssigned.*,SA_Social.sGroupID as sGroupID,SA_Social.sMessageNumber as sMessageNumber,SA_Social_att.sActive as sActive  FROM OA_TasksAssigned OA_TasksAssigned  join (select  SA_Social.sData1, MIN(SA_Social.sGroupID) as sGroupID from SA_Social SA_Social  where  SA_Social.sPersonID = :currentPersonID() AND SA_Social.sTypeID = 'RelativeOrg' AND SA_Social.sValidState = 1   group by SA_Social.sData1) SA_SocialOne on OA_TasksAssigned = SA_SocialOne.sData1 join SA_Social SA_Social on  OA_TasksAssigned = SA_Social.sData1 AND SA_Social.sPersonID = :currentPersonID() AND SA_Social.sTypeID = 'RelativeOrg' AND SA_Social.sValidState = 1 AND SA_Social.sGroupID = SA_SocialOne.sGroupID  optional  join SA_Social SA_Social_att on  OA_TasksAssigned = SA_Social_att.sData1 AND SA_Social_att.sPersonID = :currentPersonID() AND SA_Social_att.sTypeID = 'Focus' AND SA_Social_att.sValidState = 1 ORDER BY OA_TasksAssigned.fLastModifyTime desc LIMIT 0, 1
--> sql: SELECT  OA_TasksAssigned.fID AS OA_TasksAssigned, OA_TasksAssigned.VERSION AS version, OA_TasksAssigned.FNAME AS fName, OA_TasksAssigned.FCONTENT AS fContent, OA_TasksAssigned.FCREATORID AS fCreatorID, OA_TasksAssigned.FCREATOR AS fCreator, OA_TasksAssigned.FCREATORTIME AS fCreatorTime, OA_TasksAssigned.FEXECUTOR AS fExecutor, OA_TasksAssigned.FEXECUTORID AS fExecutorID, OA_TasksAssigned.FCLOSER AS fCloser, OA_TasksAssigned.FCLOSERID AS fCloserID, OA_TasksAssigned.FCLOSERMEMO AS fCloserMemo, OA_TasksAssigned.FSTATUS AS fStatus, OA_TasksAssigned.FLASTMODIFYTIME AS fLastModifyTime, OA_TasksAssigned.FATTACHMENT AS fAttachment, SA_Social.SGROUPID AS sGroupID, SA_Social.SMESSAGENUMBER AS sMessageNumber, SA_Social_att.SACTIVE AS sActive FROM OA_TASKSASSIGNED OA_TasksAssigned JOIN (SELECT  SA_Social.SDATA1 AS sData1, MIN(SA_Social.SGROUPID) AS sGroupID FROM SA_Social SA_Social  WHERE  (SA_Social.SPERSONID =  ? ) AND (SA_Social.STYPEID = ?) AND (SA_Social.SVALIDSTATE = ?)    GROUP BY SA_Social.SDATA1) SA_SocialOne ON OA_TasksAssigned.fID = SA_SocialOne.sData1 JOIN SA_Social SA_Social ON  (OA_TasksAssigned.fID = SA_Social.SDATA1) AND (SA_Social.SPERSONID =  ? ) AND (SA_Social.STYPEID = ?) AND (SA_Social.SVALIDSTATE = ?) AND (SA_Social.SGROUPID = SA_SocialOne.sGroupID)  LEFT JOIN SA_Social SA_Social_att ON  (OA_TasksAssigned.fID = SA_Social_att.SDATA1) AND (SA_Social_att.SPERSONID =  ? ) AND (SA_Social_att.STYPEID = ?) AND (SA_Social_att.SVALIDSTATE = ?)   ORDER BY OA_TasksAssigned.FLASTMODIFYTIME DESC
--> binds: [PSN01, RelativeOrg, 1, PSN01, RelativeOrg, 1, PSN01, Focus, 1]
        at com.justep.exception.BusinessException.create(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.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.BizData.query(Unknown Source)
        at BizProcedure.query(BizProcedure.java:137)

lijunfeng

数据库中也查不到这张表

lijunfeng

机构类型过滤条件无效。岗位，人员还是出来了

jishuang

lijunfeng 发表于 2015-12-7 12:05
数据库中也查不到这张表

平台默认是不会去调用OA_TasksAssigned的，这个不是平台默认提供的，确认是否是OA中的功能设置的问题

includeOrgKind设置的这个现象通过验证是产品缺陷，我们已提交到产品组(内部编号：2015120700024)，感谢楼主的支持与配合。

showFilter的设置如下：showFilter="val('sOrgKindID')=='ogn'"

huaidanzhilei

您好楼主,该缺陷已经在5.3.3版本中得到解决,如没有特殊限制！建议您用新版本

lijunfeng

好的，谢谢。