ESS LS

 2 Replies
 0 Subscribed to this topic
 15 Subscribed to this forum
Sort:
Author
Messages
KB
Posts: 23
    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? 
    Al
    Basic Member
    Posts: 17
    Basic Member
      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())
      Al
      John Henley
      Posts: 3353
        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,'
        Thanks for using the LawsonGuru.com forums!
        John