Prev
Next
Forums S3 Security

MSS Rule on Employee table

Sort:
You are not authorized to post a reply.
Author
Messages
msjmg111
Veteran Member
Posts: 74
Veteran Member
9/7/2011 2:31 PM

    We are working on writing rules for the Direct Reports link in MSS.  We've had ESS in for some time and my rule writing is a bit rusty, so I would appreciate any help with MSS.  I loaded the MSS delivered template and the rule for the Employee table  - if(user.isSupervisorOf(getIdFromEmpNbr(lztrim(table.COMPANY),lztrim(table.EMPLOYEE))))'ALL_ACCESS';else'NO_ACCESS'.  When I try to access one of my direct reports I get an error retrieving database records.  The rule seems straightforward so what am I missing?

    BarbR
    Veteran Member
    Posts: 306
    Veteran Member
    9/7/2011 2:46 PM
      Here is what we have and are doing just fine with it:
      user.isInChainOfCmdOfEmpInHR(lztrim(table.COMPANY),lztrim(table.EMPLOYEE))
      msjmg111
      Veteran Member
      Posts: 74
      Veteran Member
      9/7/2011 6:56 PM
        Thanks Barb, it worked like a charm. I'm curious, does anyone know the difference between the InChainOfCmd and isSupervisorOf?
        BarbR
        Veteran Member
        Posts: 306
        Veteran Member
        9/7/2011 7:32 PM
          Pretty much what it sounds like.
          isSupervisorOf is the employee's direct supervisor.
          InChainOfCmd is the employee's complete management chain-of-command.
          We use the chain-of-command access for our MSS Personnel Action flows so that any manager in the chain has the same access.
          BarbR
          Veteran Member
          Posts: 306
          Veteran Member
          9/7/2011 7:33 PM
            Same access to the employee in question, that is.
            In other words, the employee's supervisor, manager, director, vice president, COO, CEO - whatever the chain is if you follow the HR07 org path.
            You are not authorized to post a reply.