销售订单数据规则权限问题
金蝶云社区-云社区用户4eh5433
云社区用户4eh5433
0人赞赏了该文章 1,620次浏览 未经作者许可,禁止转载编辑于2014年11月13日 12:00:46

问题描述:需求:外销类型的销售订单只能由创建人查询。
1、在系统中设置了如下数据规则。


2、并将此数据规则,运用到相应的角色中,


3、用户登录,打开销售订单列表报错,新增订单保存,提交报错。错误信息如下:


发生时间: 11:49:22
错误编号: ??????
错误信息: 过滤条件太长,请修改此过滤条件:(((FSaleOrgId=1) AND (( FBillTypeID = '42f2e99530e1a98211e455d5afdfb9fb' AND FCreatorId.FName = '郑凤珍' )))) or (((FSaleOrgId=100009) AND (( FBillTypeID = '42f2e99530e1a98211e455d5afdfb9fb' AND FCreatorId.FName = '郑凤珍' )))) or (((FSaleOrgId=100012) AND (( FBillTypeID = '42f2e99530e1a98211e455d5afdfb9fb' AND FCreatorId.FName = '郑凤珍' )))) or (((FSaleOrgId=100013) AND (( FBillTypeID = '42f2e99530e1a98211e455d5afdfb9fb' AND FCreatorId.FName = '郑凤珍' )))) or (((FSaleOrgId=122068) AND (( FBillTypeID = '42f2e99530e1a98211e455d5afdfb9fb' AND FCreatorId.FName = '郑凤珍' )))) or (((FSaleOrgId=122070) AND (( FBillTypeID = '42f2e99530e1a98211e455d5afdfb9fb' AND FCreatorId.FName = '郑凤珍' )))) or (((FSaleOrgId=122073) AND (( FBillTypeID = '42f2e99530e1a98211e455d5afdfb9fb' AND FCreatorId.FName = '郑凤珍' )))) or (((FSaleOrgId=122074) AND (( FBillTypeID = '42f2e99530e1a98211e455d5afdfb9fb' AND FCreatorId.FName = '郑凤珍' )))) or (((FSaleOrgId=122091) AND (( FBillTypeID = '42f2e99530e1a98211e455d5afdfb9fb' AND FCreatorId.FName = '郑凤珍' ))))
===================================================
调用堆栈:
at Kingdee.BOS.Core.SqlBuilder.DynamicSqlBuilder.ThrowLongExpException(String strExp)
at Kingdee.BOS.Core.SqlBuilder.DynamicSqlBuilder.TransBinaryOpExpr(SqlExpr expr)
at Kingdee.BOS.Core.SqlBuilder.DynamicSqlBuilder.TransBinaryOpExpr(SqlExpr expr)
at Kingdee.BOS.Core.SqlBuilder.DynamicSqlBuilder.SetExprWithRealName(SqlExpr expr)
at Kingdee.BOS.Core.SqlBuilder.DynamicSqlBuilder.TransBinaryOpExpr(SqlExpr expr)
at Kingdee.BOS.Core.SqlBuilder.DynamicSqlBuilder.TransBinaryOpExpr(SqlExpr expr)
at Kingdee.BOS.Core.SqlBuilder.DynamicSqlBuilder.TransBinaryOpExpr(SqlExpr expr)