PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 3/24/2006 3:43 PM by  Alex Tsekhansky
RD30 & PORTALROLE attrib
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Greg Moeller
Private
Private
Veteran Member
(4132 points)
Veteran Member
Posts:1474


Send Message:

--
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
    Private
    Private
    Senior Member
    (9899 points)
    Senior Member
    Posts:3317


    Send Message:

    --
    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
    Private
    Private
    Veteran Member
    (276 points)
    Veteran Member
    Posts:92


    Send Message:

    --
    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.
    You are not authorized to post a reply.