Prev
Next
Forums Infor / Lawson Platforms S3 Security

Lawson-supplied MSS Role

 3 Replies
 0 Subscribed to this topic
 15 Subscribed to this forum
Sort:
Author
Messages
Frank Z
Advanced Member
Posts: 32
Advanced Member
12/2/2009 12:16 PM

    Would anyone be able to provide me with the Lawson-supplied MSS rule for the Employee table?  I changed the rule by mistake while working on a class based on it, and really don't feel like unpacking all of those classes again.

     

    TIA.

     

    Frank Z.

    Frank Z
    Advanced Member
    Posts: 32
    Advanced Member
    1/6/2010 5:56 PM
      I completely scrapped the idea of using Lawson's classes for MSS, and built my own. One functions as planned, but is very very slow (up to 2 minutes to return accessible employees). The other is very fast, but the view on the returned data is different (employees are sorted on Employee Groups, and no filtering seems to have been applied). Below are the two rules written against the EMPLOYEE table in question:

      - user.isInChainOfCmdOfEmpInHR(lztrim(table.COMPANY),lztrim(table.EMPLOYEE)) - very slow, dead on accurate data.

      - user.isSupervisorOfEmpInHR(lztrim(table.COMPANY),lztrim(table.EMPLOYEE)) - very fast, but essentially useless.

      We are not using element groups, not using ESS, using LSF 9.0 and LS on Windows. Would anyone be able to tell me how to speed the searches up? I really hate that I may have to resort to using process levels to control access, especially after spending a couple of months making sure our supervisor table is dead accurate.
      riegerj
      Veteran Member
      Posts: 44
      Veteran Member
      1/7/2010 4:54 PM
        Frank, I am not sure if this applies here but I know in the past when I run into issues with performance of employee queries we would explicitly define the company, adding a where company = xxxx to the statement and this would greatly improve response time. If you do not have more than one HR company this may help.
        Frank Z
        Advanced Member
        Posts: 32
        Advanced Member
        1/7/2010 8:15 PM
          Thank you for the help! Your technique did cut the wait down to about 1 minute. Just so I am clear on what suggested, here is what I used:
          user.isInChainOfCmdOfEmpInHR(trim('100'),lztrim(table.EMPLOYEE))

          Since we are not using RSS, I tried entering a supervisor code into the REQUESTER ID field. The response on this was almost instant, but of course this removes alot of the functionality of linking positions to HRSUPER entries. We are really digging for viable options here!