Prev
Next
Forums User Experience Lawson Portal

RD30 & PORTALROLE attrib

 2 Replies
 0 Subscribed to this topic
 13 Subscribed to this forum
Sort:
Author
Messages
Greg Moeller
Veteran Member
Posts: 1498
Veteran Member
3/23/2006 9:50 PM
    We have about 5000 rd30 records. Most of which do not have the PORTALROLE attribute filled out.
    Is there an easy way to identify the blank ones, and therefore create a LX995 job/file to fill JUST the ones that don't have something in them already?
    John Henley
    Posts: 3353
    3/23/2006 10:11 PM
      You could do a quick Crystal report, joining WEBUSER TO LOMXVALUE on OBJ-ID for MATRIX-CAT=PORTALROLE, and hide ones that don't have a Blank/NULL value on the LOMXVALUE side of the JOIN.

      You could also do something in SQL with SELECT ... MINUS ... along the same lines...
      Thanks for using the LawsonGuru.com forums!
      John
      Alex Tsekhansky
      Veteran Member
      Posts: 92
      Veteran Member
      3/24/2006 3:43 PM
        I also recommend doing PORTALROLE per user category (if you have large number of users to be assigned for the same role) rather than doing individual LX95. See Lawson KB article on Required Content assignment.

        Thanks.

        Alex.