Who's On?

	Membership:
	Latest: John Bonin
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5270

	People Online:
	Visitors: 311
	Members: 0
	Total: 311

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1375
Roger French	1315
mark.cook	1244

ESS LS

2 Replies

0 Subscribed to this topic

16 Subscribed to this forum

Sort:

Author

Messages

Posts: 23

7/6/2011 12:59 PM

We are troubleshooting our ESS LS rule and are having a problem with a DME call. On the table we have tried to secure we have a conditional rule as follows...

if(user.getEmployeeId()==table.EMPLOYEE)
'I,'
else
'NO_ACCESS,'

We are trying to lock the table down so they can only see their own data.

A DME call against this same data returns 0 results.

Shouldn't this rule work?

Basic Member Send Private Message

Posts: 17

7/6/2011 1:22 PM

You will need to use lztrim function. Example of our rule in ESS is:

if(lztrim(table.COMPANY)==user.getCompany()&&lztrim(table.EMPLOYEE)==user.getEmployeeId())

John Henley

Posts: 3351

7/6/2011 2:01 PM

This is the rule I would use (note the lztrim as well as checking the RM access flag for selected users to bypass this rule):
if(user.getCompany()==lztrim(table.COMPANY)&&user.getEmployeeId()==lztrim(table.EMPLOYEE) || user.getAttribute('Access')=='Y')
'I,'
else
'NO_ACCESS,'