SA_OPAuthorize

dh_n

我需要过滤SA_OPAuthorize表。
选择数据源后，绑定好概念表，测试count()为0，测试绑定的action没有问题。
过滤后也是没有数据。

jishuang

把sql语句打出来到数据库中执行
http://bbs.wex5.com/forum.php?mo ... 4&pid=165004035

dh_n

1. SELECT  SA_OPAuthorize.sID AS SA_OPAuthorize, SA_OPOrg.sFName AS orgFName, SA_OPOrg.SORGKINDID AS orgKindID, SA_OPOrg.SNAME
   
2. AS orgName, SA_OPRole.SDESCRIPTION AS roleDescription, SA_OPRole.SNAME AS roleName, SA_OPAuthorize.sAuthorizeRoleID
   
3.   AS sAuthorizeRoleID, SA_OPAuthorize.SCREATETIME AS sCreateTime, SA_OPAuthorize.SCREATORFID AS sCreatorFID,
   
4.    SA_OPAuthorize.SCREATORFNAME AS sCreatorFName, SA_OPAuthorize.SDESCRIPTION AS sDescription, SA_OPAuthorize.SORGFID
   
5.     AS sOrgFID, SA_OPAuthorize.SORGFNAME AS sOrgFName, SA_OPAuthorize.SORGID AS sOrgID, SA_OPAuthorize.SORGNAME AS
   
6.      sOrgName, SA_OPAuthorize.VERSION AS version FROM SA_OPAuthorize SA_OPAuthorize
   
7.       JOIN SA_OPOrg SA_OPOrg ON SA_OPAuthorize.SORGID = SA_OPOrg.sID JOIN SA_OPRole SA_OPRole
   
8.        ON SA_OPAuthorize.sAuthorizeRoleID = SA_OPRole.sID  WHERE  ( ( (SA_OPOrg.SVALIDSTATE = 1)
   
9.        AND (SA_OPRole.SVALIDSTATE = 1) ) AND (0 = 1) ) AND (SA_OPAuthorize.SORGID LIKE 'PSN01%')   
   
10. ORDER BY SA_OPAuthorize.sAuthorizeRoleID ASC, SA_OPOrg.SSEQUENCE ASC
    
11. [code]select SA_OPAuthorize.*,SA_OPOrg.sName as orgName,SA_OPOrg.sFName as orgFName,SA_OPOrg.sOrgKindID as orgKindID,SA_OPRole.sName as roleName,SA_OPRole.sDescription as roleDescription
    
12.     from SA_OPAuthorize SA_OPAuthorize
    
13.      join SA_OPOrg SA_OPOrg on SA_OPAuthorize.sOrgID = SA_OPOrg
    
14.      join SA_OPRole SA_OPRole on SA_OPAuthorize.sAuthorizeRoleID = SA_OPRole
    
15.     where SA_OPOrg.sValidState = 1 AND SA_OPRole.sValidState = 1
    
16.     order by SA_OPAuthorize.sAuthorizeRoleID asc, SA_OPOrg.sSequence asc

复制代码

[/code]
where 语句里多了一个（0=1），这个是哪里加的，action里面有2个条件，我加的是最后一个条件，多了一个条件不知道哪里加上的。

jishuang

你设置的queryAction是按角色查的，传角色了吗？没传就会拼上
可以看action对应的java代码的具体实现

dh_n

已解决，结贴