数据权限提示错误 一个权限表达式只能约束一个对象

liuaqiuping

JUSTEP154100, 一个权限表达式只能约束一个对象, [RM_NBLLD.fXDBM, RM_NBLLDMX.fCLRBM],刷新数据失败表达式：AND ( :currentDeptFName() like concat(RM_NBLLD.fXDBM,'%')  OR :currentDeptFName() like concat(RM_NBLLDMX.fCLRBM,'%'))
-------------------------------------
2018-09-12 16:16:20 excute stream action, params:{process=/RM/RSo/process/NBLLD/nBLLDProcess, translateParameter={"dataType":"row-list","transformIdcolumn":true,"rowsConfig":{"concept":"RM_NBLLD","sequence":"fXDR,fXDRQ,fRWMC,fZXZT,fJSR,fCLR,YQWCSJ,fWCSJ,fYQ,fLX,space-column,RM_NBLLD,version,fZT,fXJGSCCG,fXDRID,fXDBM,fYQWCSJ,fYQDDXG,fNRMS,fTSSM,fGLCP,fFJ,fLoc,fJSRID,RM_NBLLDMX,fCLRBM,fCLJG,fCLFJ,fJGPJ,fQRJG,fQRYJ,fBCQRYJ"},"useNamespace":true,"cellnameByRelation":false}, executor=0F19841C616A41C5B2AD9E3F7E5F1F3A, action=queryRM_NBLLDAndMXAction, actionFlag=__action_0__, parameters={"limit":20,"orderBy":"fXDRQ DESC,fXDR DESC,fRWMC DESC","columns":"RM_NBLLD,version,fZT,fLX,fXJGSCCG,fXDRQ,fXDR,fXDRID,fXDBM,fYQWCSJ,fRWMC,fYQDDXG,fNRMS,fTSSM,fGLCP,fFJ,fLoc,fJSR,fJSRID,fZXZT,fYQ,RM_NBLLDMX,fCLR,fCLRBM,YQWCSJ,fWCSJ,fCLJG,fCLFJ,fJGPJ,fQRJG,fQRYJ,fBCQRYJ,fID","offset":0,"filter":"((RM_NBLLD.fRWMC like '%%' or RM_NBLLD.fNRMS like '%%') and  (RM_NBLLD.fXDR like '%%' or RM_NBLLD.fXDBM like '%%') and  (''='' or RM_NBLLDMX.fCLR like '%%' or RM_NBLLDMX.fJSR like '%%' or RM_NBLLDMX.fCLRBM like '%%' ) and  (''='' or RM_NBLLDMX.fYQWCSJ >= '') and  (''='' or RM_NBLLDMX.fYQWCSJ <= '') and  (''='' or RM_NBLLD.fLoc ='') and  (''='' or (''='Y' and SQL.ISNULL(RM_NBLLDMX.fZXZT,'') <>'完成' and SQL.ISNULL(RM_NBLLDMX.fZXZT,'') <>'终止')) and (''='' or RM_NBLLDMX.fZXZT like '%%'))","variables":{}}, activity=NBLLDMng, executeContext=}
com.justep.exception.BusinessException: 编码: JUSTEP154100; 提示: 一个权限表达式只能约束一个对象, [RM_NBLLD.fXDBM, RM_NBLLDMX.fCLRBM]
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.util.Utils.check(Unknown Source)
        at com.justep.system.ksql.permission.DataPermissionImpl.setDest(Unknown Source)
        at com.justep.system.ksql.permission.PermissionVisitor.parse(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.parseDataPermission(Unknown Source)
        at com.justep.system.data.KSQL.parseDataPermission(Unknown Source)
        at com.justep.system.opm.a.a(Unknown Source)
        at com.justep.system.opm.Permissions.a(Unknown Source)
        at com.justep.system.opm.Person.a(Unknown Source)
        at com.justep.system.opm.Operator.getPermissionParameter(Unknown Source)
        at com.justep.system.opm.Operator.getPermissionParameter(Unknown Source)
        at com.justep.system.interceptor.CheckPermission.a(Unknown Source)
        at com.justep.system.interceptor.CheckPermission.execute(Unknown Source)
        at com.justep.system.action.EngineInterceptor.excute(Unknown Source)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
        at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:662)

jishuang

:currentDeptFName() like concat(RM_NBLLD.fXDBM,'%')和:currentDeptFName() like concat(RM_NBLLDMX.fCLRBM,'%')分别括起来看看

liuaqiuping

jishuang 发表于 2018-9-12 17:13
:currentDeptFName() like concat(RM_NBLLD.fXDBM,'%')和:currentDeptFName() like concat(RM_NBLLDMX.fCL ...

做了 还是不行

jishuang

添加两个分别控制看看

liuaqiuping

jishuang 发表于 2018-9-12 17:34
添加两个分别控制看看

UI界面上本身还有Where条件，正常的sql语句是  AND ( :currentDeptFName() like concat(RM_NBLLD.fXDBM,'%')  OR :currentDeptFName() like concat(RM_NBLLDMX.fCLRBM,'%'))，

改为2行后要写成
OR ( :currentDeptFName() like concat(RM_NBLLD.fXDBM,'%') )
OR (:currentDeptFName() like concat(RM_NBLLDMX.fCLRBM,'%'))
问下 这个数据权限的KSQL 和 ui界面上面的filter关系是什么 是怎么组合查询的

jishuang

AND的方式

liuaqiuping

jishuang 发表于 2018-9-13 09:23
AND的方式

数据权限的内部所有依据自己的写的KSQL连接方式连接，外部再与UI where连接 条件用 and 是这样吗？，
这个里面有个疑问 数据权限的第一行or 是什么概念了？

jishuang

就是给非数据权限中设置的条件之间的连接方式

liuaqiuping

jishuang 发表于 2018-9-13 11:21
就是给非数据权限中设置的条件之间的连接方式

先结贴吧