orgDialogPC中filter设置

sandgia

orgDialogPC中filter设置为：(SA_OPOrg.sOrgKindID = 'psm'  AND  SA_OPOrg.sValidState = 1 )

但是过滤后一个也没有出来，数据肯定是有的，请帮忙看看，以下是tomcat的运行sql，死filter 写错了吗？


SQL : SELECT
SA_OPOrg.sID AS SA_OPOrg,
SA_OPOrg.SNAME AS sName,
SA_OPOrg.SCODE AS sCode,
SA_OPOrg.SLONGNAME AS sLongName,
SA_OPOrg.sFName AS sFName,
SA_OPOrg.SFCODE AS sFCode,
SA_OPOrg.sFID AS sFID,
SA_OPOrg.SORGKINDID AS sOrgKindID,
SA_OPOrg.SSEQUENCE AS sSequence,
SA_OPOrg.SVALIDSTATE AS sValidState,
SA_OPOrg.sParent AS sParent,
SA_OPOrg.SLEVEL AS sLevel,
SA_OPOrg.SPHONE AS sPhone,
SA_OPOrg.SFAX AS sFax,
SA_OPOrg.SADDRESS AS sAddress,
SA_OPOrg.SZIP AS sZip,
SA_OPOrg.SDESCRIPTION AS sDescription,
SA_OPOrg.SPERSONID AS sPersonID,
SA_OPOrg.SNODEKIND AS sNodeKind,
SA_OPOrg.SWXDEPTID AS sWxDeptID,
SA_OPOrg.VERSION AS version,
member1.sResourceID AS groupID,
member1.sID AS memberID
FROM
    SA_OPOrg SA_OPOrg
    JOIN SA_ResourceControl member1 ON ( SA_OPOrg.sFID = member1.SORGFID )
    AND ( member1.STYPEID = ? )
    AND ( member1.sResourceID IN ( ? ) )
WHERE
    ( SA_OPOrg.SVALIDSTATE >= ? )
    AND ( ( SA_OPOrg.SVALIDSTATE = ? ) AND ( ( SA_OPOrg.SORGKINDID = ? ) AND ( SA_OPOrg.SVALIDSTATE = ? ) ) )
ORDER BY
    SA_OPOrg.SSEQUENCE ASC --> binds:[customGroup_member, , 0, 1, psm, 1]

jishuang

到数据库能查出数据?要设置只显示人员成员，设置组件的上的includeOrgKind属性