on 09-20-2009 8:36 AM
请问一下大家,在SBO中如果我想在查询接口中查出现在登录者的名称标识,譬如能找出现在是manager,或代码-1等。
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
楼上误解我的意思了,我说的是使用$USER 只能在格式化搜索中使用,在做客户化报表时,如果需要根据当前登录用户来制作用户报表是不行。SBO有个数据权限的功能,例如销售订单可以设置用户只能看到自己的销售订单,但查询报表上无法做到。SBO在这一点上存在设计思存在断层。
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SELECT T0.U_NAME FROM OUSR T0 WHERE INTERNAL_K = (SELECT $[USER]) FOR BROWSE
这样就可以在查询接口用了。
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear zhijun chen,
这个语句是不能直接在查询管理器中运行的。
您需要先保存这个语句,然后使用用户定义值将它与界面上的某个字段关联,然后显示.
Best Regards
Jane Jing
SAP Business One Forums team
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
但在查询管理器中是不能使用楼上的方法的。
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Zhiheng He,
可以在B1中定义查询:
SELECT T0.U_NAME FROM OUSR T0 WHERE INTERNAL_K = $[USER] FOR BROWSE
然后再绑定到某个界面字段显示出来。
Best Regards
Jane Jing
SAP Business One
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.