details: https://code.openbravo.com/erp/devel/pi/rev/a895b65c70a1
changeset: 18970:a895b65c70a1
user: Augusto Mauch <augusto.mauch <at> openbravo.com>
date: Wed Dec 05 10:34:39 2012 +0100
summary: Related to issue 22391: Removes not needed trim
There is not need to trim the userlevel, as it only matters if it contains an
'S', 'O', or 'C', the spaces are irrelevant.
diffstat:
src/org/openbravo/base/secureApp/Seguridad_data.xsql | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diffs (18 lines):
diff -r 92963171b300 -r a895b65c70a1
src/org/openbravo/base/secureApp/Seguridad_data.xsql
--- a/src/org/openbravo/base/secureApp/Seguridad_data.xsql Tue Dec 04
18:34:37 2012 +0100
+++ b/src/org/openbravo/base/secureApp/Seguridad_data.xsql Wed Dec 05
10:34:39 2012 +0100
@@ -241,10 +241,10 @@
and t.isActive='Y'
and tb.isActive='Y'
and tb.ad_table_id = t.ad_table_id
- and ( (TO_NUMBER(t.accessLevel)=4 and
instr(trim(r.userLevel),'S')!=0)
- or (TO_NUMBER(t.accessLevel)=1 and
instr(trim(r.userLevel),'O')!=0)
- or (TO_NUMBER(t.accessLevel)=3 and
(instr(trim(r.userLevel),'C')!=0 or instr(trim(r.userLevel),'O')!=0))
- or (TO_NUMBER(t.accessLevel)=6 and
(instr(trim(r.userLevel),'S')!=0 or instr(trim(r.userLevel),'C')!=0))
+ and ( (TO_NUMBER(t.accessLevel)=4 and instr(r.userLevel,'S')!=0)
+ or (TO_NUMBER(t.accessLevel)=1 and instr(r.userLevel,'O')!=0)
+ or (TO_NUMBER(t.accessLevel)=3 and (instr(r.userLevel,'C')!=0
or instr(r.userLevel,'O')!=0))
+ or (TO_NUMBER(t.accessLevel)=6 and (instr(r.userLevel,'S')!=0
or instr(r.userLevel,'C')!=0))
)
and not exists (select 1
from ad_table_access ta
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
